After Updates all products gone

[edley07]

After TYPO3 update from 9.5.30 to 11.5.19 and pxa_product_manager from 9.9.2 to 11.0.7 all products disappeared. Is there a possibility to restore them?

[MattiasNilsson]

Hi @edley07 when you mean they are gone? Are they not visible in the backend? Are they all gone from the database?

[edley07]

Hi @MattiasNilsson - all the DB tables of the pxa_product_manager and the BE are both empty. The BE shows only the product categories. But i have the old DB with the working products.

[MattiasNilsson]

@edley07 This is strange as we have no migration wizard etc. But we have updated table structure to may have done so that you may loose some data.

How did you do the upgrade?

[edley07]

@MattiasNilsson Typo3 update as usual: all EXts deactivated - system updates - all Exts activated or update where necessary

[MattiasNilsson]

@edley07 Ok this is something new for us. Not sure how to proceed with it. Do you have any more information?

[MattiasNilsson]

@edley07 I just want to mention that we have WIP (work in progress) update wizard if you want to try that.

https://github.com/pixelant/pxa_product_manager_upgrade

[edley07]

@MattiasNilsson What kind of info do you need ?
Today I copied the pxa_product_manager tables from version 9.9.2 to the new version 11.0.7 as far as possible.
When importing the tx_pxaproductmanager_product_product_mm there was already an error:

The import was completed successfully, 15 queries were executed. (tx_pxaproductmanager_product_mm.sql)
-- phpMyAdmin SQL Dump
-- version 4.9.10
-- https://www.phpmyadmin.net/

-- Host: db773712078.hosting-data.io
-- Creation time: 07 Dec 2022 at 09:26
-- Server version: 5.7.38-log
-- PHP version: 7.0.33-0+deb9u12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";# MySQL returned an empty result (i.e. zero records).
SET AUTOCOMMIT = 0;# MySQL returned an empty result (i.e. zero records).
START TRANSACTION;# MySQL returned an empty result (i.e. zero records).
SET time_zone = "+00:00";# MySQL returned an empty result (i.e. zero records).

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;# MySQL returned an empty result (i.e. zero records).
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;# MySQL returned an empty result (i.e. zero records).
/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# MySQL
returned an empty result (i.e. null [...]

Now the products are listed in the BE again but when I try to edit them I get an error message:

(1/2) Doctrine\DBAL\Exception\InvalidFieldNameException
An exception occurred while executing 'SELECT * FROM tx_pxaproductmanager_product_mm WHERE (tablenames = ?) AND (fieldname = ?) AND (uid_foreign = ?) ORDER BY sorting_foreign ASC, uid_local ASC' with params ["tx_pxaproductmanager_domain_model_product", "related_products", 858]: Unknown column 'tablenames' in 'where clause'......

The WIP (work in progress) update wizard is beyond my technical knowledge ;-(

[arunspt]

Hello @MattiasNilsson

Could you please let me know a solution for this issue?

Thank you for your support.