Forum
Can't remove or add product after Shop App update
I've updated Perch to latest version (from an old version < 2.5) and made the same for Shop App (from "Shop App" 1.0 to "Foxycart Shop App" 2.0) but now I can't edit, add or remove any product. I've got the error "Sorry, that product could not be updated." when I want to add or remove a product. Shop App is used only to display products, no payments.
How can I solve this problem ?
Here is diagnostic :
Rapport du Diagnostique
HEALTH CHECK
Perch is up to date
PHP 5.5.9-1ubuntu4.5 is up to date
MySQL 5.5.40-0ubuntu0.14.04.1 is up to date
Image processing available
SUMMARY INFORMATION
Perch: 2.7.4, PHP: 5.5.9-1ubuntu4.5, MySQL: 5.5.40, with PDO
Server OS: Linux, fpm-fcgi
Installed apps: content (2.7.4), assets (2.7.4), categories (2.7.4), perch_events (1.9), perch_forms (1.8.2), perch_shop_foxycart (2)
App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_forms', 'perch_events', 'perch_shop_foxycart', );
PERCH_LOGINPATH: /perch
PERCH_PATH: /home/stylecars/www/perch
PERCH_CORE: /home/stylecars/www/perch/core
PERCH_RESFILEPATH: /home/stylecars/www/perch/resources
Image manipulation: GD
PHP limits: Max upload 16M, Max POST 16M, Memory: 256M, Total max file upload: 16M
Resource folder writeable: Yes
HTTP_HOST: stylecars.fr
DOCUMENT_ROOT: /home/stylecars/www
REQUEST_URI: /perch/core/settings/diagnostics/
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
If you turn on debug, do you get any errors when that happens?
Here is the message (unknown column). My knowledge in MySQL is very low... How can I fix it ?
Was this originally the FoxyCart shop?
It was the first shop app, originaly named "perch_shop" (version 1 if I remember), so I updated the apps.php like mentioned here: https://grabaperch.com/add-ons/apps/shop-foxycart
When you updated, did you see an update run?
I don't remember having seen any update message or confirmation. Should I downgrade to previous versions ? (I made a backup before update)
It could be worth a try. I"m not overly familiar with this app, but I'll see what I can find out.
I've downgraded to old version (perch and shop app) and it works (but I'm still with old version of Perch and apps). Here is diagnostic page for info.
If you have a solution so I can update safely, tell me ;)
I'll have a look into it and see what I can come up with.