database exception error after move to new hoster

[peter4661]

Dear all,

 

We moved to new hoster. Site is up and running in test. PS V 1.6.0.9.

 

In test, we came accross 2 errors: 1) cannot add new product, 2) cannot add product to cart. Rest of the site is tested and O.K.

 

Here is the error warning: http://screencast.com/t/cV9yWpFSrY0v

 

Tip(s) wanted  .

 

Peter

 

 

 

[vekia]

i see that you use override

for what purposes?

 

override alters default prestashop core code so it affects whole workflow

you have overrides of:

- cartController

- Dispatcher

[peter4661]

i see that you use override

for what purposes?

 

override alters default prestashop core code so it affects whole workflow

you have overrides of:

- cartController

- Dispatcher

 

 

Heya Milos,

 

Thank you for your help.  We don't have enough knowlegde to apply overrides, must be part of modules. By uninstalling no Presta core modules one by one, we could identify a module which created an back office issue.

 

We continued with uninstalling all non core modules. The front issue , cannot add product to cart, persist.

 

I tried to understand the details of the error warnings, Ssee some code which is referring to Pagecache (  module is also uninstalled ) .  Could this be the remains of old installation?

 

 

If you can tip us here how to solve.

 

In summary, we have only core modules installed now.

 

 

http://screencast.com/t/sEYIb6OWfwV

http://screencast.com/t/fb8upOtsS526

http://screencast.com/t/oiPPa5Jes0S

[peter4661]

Heya Milos,

 

Thank you for your help.  We don't have enough knowlegde to apply overrides, must be part of modules. By uninstalling no Presta core modules one by one, we could identify a module which created an back office issue.

 

We continued with uninstalling all non core modules. The front issue , cannot add product to cart, persist.

 

I tried to understand the details of the error warnings, Ssee some code which is referring to Pagecache (  module is also uninstalled ) .  Could this be the remains of old installation?

 

 

If you can tip us here how to solve.

 

In summary, we have only core modules installed now.

 

http://screencast.com/t/sEYIb6OWfwV

http://screencast.com/t/fb8upOtsS526

http://screencast.com/t/oiPPa5Jes0S

 

 

Solution came from database expert:

 

 

Field 'modules' doesn't have a default value, needs to be removed

we should change it as empty in phpmyadmin

set the modules as NULL

 

we cannot change the mysql setting for this sever, some servers allow the field as NULL ,

If we define the field as not empty, but we insert empty , it will display the error