Comments (8)
Hi @edley07 when you mean they are gone? Are they not visible in the backend? Are they all gone from the database?
from pxa_product_manager.
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.
from pxa_product_manager.
@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?
from pxa_product_manager.
@MattiasNilsson Typo3 update as usual: all EXts deactivated - system updates - all Exts activated or update where necessary
from pxa_product_manager.
@edley07 Ok this is something new for us. Not sure how to proceed with it. Do you have any more information?
from pxa_product_manager.
@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
from pxa_product_manager.
@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 ;-(
from pxa_product_manager.
Hello @MattiasNilsson
Could you please let me know a solution for this issue?
Thank you for your support.
from pxa_product_manager.
Related Issues (20)
- [BUG] indexed solr images should be "processed", not just the "publicUrl"
- [FEATURE] Complete and replace external google docs-documentation with rendered REST-documentation HOT 2
- [TASK] Add valuable links to README
- [TASK] Move documentation from README to Documentation/
- Call to undefined method Doctrine\DBAL\Driver\Mysqli\MysqliStatement::fetchAllAssociative() HOT 3
- [BUG] Cannot set Attribute in Filter HOT 1
- Route Enhancer not working with v11 [BUG] HOT 7
- [FEATURE] Related products by category HOT 1
- [BUG] Sorting "Product Renderer" List not working HOT 2
- [FEATURE] Lazy loading back button (Product Renderer List & Show)
- [BUG] translation of additionalAttributes for list not working HOT 3
- [BUG] translation filter not working HOT 1
- Product list not appearing in frontend HOT 5
- [BUG] Non-admins unable to set initial attribute value
- [BUG]: Attributes not working HOT 2
- [BUG] SQL Error on filter category caused by 'groupBy('tpppm.uid_local')' HOT 1
- [FEATURE] Attributes on List under Product Name HOT 4
- [FEATURE] TYPO3 v12 support HOT 4
- PHP Runtime Deprecation Notice: Automatic conversion of false to array is deprecated
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pxa_product_manager.