Any topic modules PrestaShop Sitolog »

Error while cloning products customizations

» Unsubscribe » Search

Author	Post
Luca R. Registered on : 01/29/2014 Posts : 1	Posted : 01/29/2014 18:40:50 "Quote" I got this error trying to copy customization fields between two products: Sorry, an error occured. Error code: Fatal error: Uncaught Unknown column 'id_shop' in 'where clause'UPDATE `ps_product` SET `customizable`=0 WHERE `id_product` = 2 AND id_shop=1 thrown in /dati/home/serramentibrombal/domains/crm.serramentibrombal.it/public_html/prestashop/classes/db/Db.php on line 613 It is a single store (no multistore) based on version 1.5.6.0 Please let me know how can I fix this. Thanks. Luca
Sitolog Registered on : 12/04/2011 Posts : 524	Posted : 02/09/2014 01:12:57 "Quote" Hi Luca, Please send me a private mail containing a logging to your back office and the FTP connections parameters, so I can reproduce the error and trace the module code to see what is happening. ([email protected]). Note: Code : thrown in /dati/home/serramentibrombal/domains/crm.serramentibrombal.it/public_html/prestashop/classes/db/Db.php on line 613 The error is coming from Db.php, a class of Prestashop. I wonder if your site has been migrated from PS 1.4 to PS1.5. If this is the case, looks like this classe has not been properly updated (id_shop is not a field of ps_product table, so this error is logical looking at this query: Code : UPDATE `ps_product` SET `customizable`=0 WHERE `id_product` = 2 AND id_shop=1 ) . Rgds Franck

Author

Post

Luca R.

Registered on : 01/29/2014

Posts : 1

Posted : 01/29/2014 18:40:50 "Quote"

I got this error trying to copy customization fields between two products:

Sorry, an error occured. Error code:
Fatal error: Uncaught Unknown column 'id_shop' in 'where clause'UPDATE `ps_product` SET `customizable`=0

WHERE `id_product` = 2 AND id_shop=1
thrown in /dati/home/serramentibrombal/domains/crm.serramentibrombal.it/public_html/prestashop/classes/db/Db.php on line 613

It is a single store (no multistore) based on version 1.5.6.0

Please let me know how can I fix this.
Thanks.
Luca

Sitolog

Registered on : 12/04/2011

Posts : 524

Posted : 02/09/2014 01:12:57 "Quote"

Hi Luca,

Please send me a private mail containing a logging to your back office and the FTP connections parameters, so I can reproduce the error and trace the module code to see what is happening. ([email protected]).

Note:

Code :

thrown in /dati/home/serramentibrombal/domains/crm.serramentibrombal.it/public_html/prestashop/classes/db/Db.php on line 613

The error is coming from Db.php, a class of Prestashop. I wonder if your site has been migrated from PS 1.4 to PS1.5. If this is the case, looks like this classe has not been properly updated (id_shop is not a field of ps_product table, so this error is logical looking at this query:

Code :

UPDATE `ps_product` SET `customizable`=0

WHERE `id_product` = 2 AND id_shop=1

) .

Rgds
Franck

Post reply Return Forum