search

pixelant / pxa_product_manager

Product Manager. Allow to create and list products on a site. Create dynamical attributes for products. Filter by categories and attributes
11 stars 14 forks source link

After Updates all products gone #390

Open edley07 opened 1 year ago

edley07 commented 1 year ago

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 commented 1 year ago

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

edley07 commented 1 year ago

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 commented 1 year ago

@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 commented 1 year ago

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

MattiasNilsson commented 1 year ago

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

MattiasNilsson commented 1 year ago

@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 commented 1 year ago

@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 commented 1 year ago

Hello @MattiasNilsson

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

Thank you for your support.