"An error occurred while updating an object. product ()" after Importing SQL damp

[Vitazzz]

 

Hello,

 

I'm gettin' the message

An error occurred while updating an object. product ()

after I reinstalled the Prestashop with same (14) version and imported my last SQL backup. Also Prestashop does not find the content for my configured CMS pages (which of course should be in database) but displays their names.  How can I solve this issue?

Edited March 28, 2015 by Vitazzz (see edit history)

[climaticmoments]

Hi,

 

I don't usually answer technical questions in forums because by NO MEANS am I as qualified as the amazing techs on here, but I thought my post might help you with the CMS part at least.

 

https://www.prestashop.com/forums/topic/430259-please-help-errors-with-cms-after-upgrading-from-16011-to-16013/

 

This might help you if you are using Prestashop 1.6.0.13 or 1.6.0.14 and if your CMS pages are still showing in your database, but not displaying on your website or back office.

 

Nemo was a lot of help and now I am able to at least edit my cms and top horizontal menu.

 

I did find the main problem, but I am still working on fixing the rest of the issues. The upgrade 1.6.0.12 I guess in short failed, but I didn't realize it. That upgrade included the needed query to add id_shop to a couple tables, it also didn't run the query that affected the pack table which affects specific pricing plus a few other things. I tried rolling back my working database as well from 3 different sources, but it didn't change anything.

 

I hope I was a little help as far as the CMS portion is concerned.

 

Have a great day.

 

Athena

www.climaticmoments.com