An error occurred while updating an object. product () 1.6.14

[bhomrah]

Hello friends 

 

i have updated prestashop from 1.6.0.5 to prestashop 1.6.14 latest one and i am not able to add product .. when i add a new product or try to  change any thing so its says An error occurred while updating an object. product ()

 

can some one please help 

 

[Vitazzz]

 

Got same error after I reinstalled Prestashop and imported latest SQL damp

[bhomrah]

I think problem in new latest version 1.6.1.4  beacuse cms page is not working and in product page i cannot do nothing ...

[Rohit]

Hello Friends,

I have already faced this error. I am very frustrated form some days. Finally I have a developer guess trick solution.

Please install your Prestashop Setup with default language English(EN) Or change your webshop default language to EN.

 

Regards

Avi Chitranshu

[Dino Matijasevic]

I have the same problem...

 

I've updated my shop from 1.6.0.9 to 1.6.0.14 on a test server and everything worked just fine. When I tried it on the production shop I get the same error if I try changing any product data.

 

Tried to enable the debug mode and I get this when I enter a product page in the BO:

 

[PrestaShopDatabaseException]

Unknown column 'last_connection_date' in 'where clause'
 

UPDATE `ps_employee` SET `last_connection_date` = CURRENT_DATE() WHERE `id_employee` = 4 AND `last_connection_date`< CURRENT_DATE()
at line 646 in file classes/db/Db.php

641. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 642. } 643. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 644. { 645. if ($sql) 646. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 647. throw new PrestaShopDatabaseException($this->getMsgError()); 648. } 649. } 650. 651. /**

• DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 480 - classes/db/Db.php] - [1 Arguments]
• DbCore->execute - [line 460 - classes/Employee.php] - [1 Arguments]
• EmployeeCore::setLastConnectionDate - [line 2458 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->init - [line 163 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

Edited May 31, 2015 by Dino Matijasevic (see edit history)

[szkrin]

You are missing some rows in database. ps_employee in last_connection_date table. You have to add this manualy.

Same thing above - turn on debug mode and check which rows are you missing and then add them through phpmyadmin.

It's easier when you can compare it with other working database (fresh presta install or other working shop).

[Dino Matijasevic]

Yes I thot so and added them manualy, then found more missing columns, added them too, them more and more. So I realised, the update of the shop didn't update the DB at all...for some reason

 

Tried some fixes even tried to RE-update my backuped shop and the same problem again...I have no ide why.

 

So for the time, I'm just using my old version 1.6.0.9 untill I really need to update to a newer version

[szkrin]

I guess that safest way to update presta is to install new version and then copy database and modifications you did. Using 1click update usually failed to me