Jump to content

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


Recommended Posts

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 

 

Link to comment
Share on other sites

  • 4 weeks later...

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

Link to comment
Share on other sites

  • 1 month later...

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. /**
Edited by Dino Matijasevic (see edit history)
Link to comment
Share on other sites

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).

Link to comment
Share on other sites

  • 2 weeks later...

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 :o

 

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 :)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...