Jump to content

SQL Syntax error when reorder items ps 1.7

Recommended Posts


when I try to reorder items on my prestashop i get this error, can you help me?




You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '),
p.`date_upd` = "2018-08-21 09:13:55",
product' at line 5<br /><br /><pre>UPDATE `ps7_category_product` cp
INNER JOIN `ps7_product` p ON (cp.`id_product` = p.`id_product`)
INNER JOIN ps7_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
SET cp.`position` = ELT(cp.`position`, ),
p.`date_upd` = "2018-08-21 09:13:55",
product_shop.`date_upd` = "2018-08-21 09:13:55"
WHERE cp.`id_category` = 132 AND cp.`id_product` IN (24,8,48,87,168,180,183,204,271,272,283,321,342,354,372,373,405,440,520,527)</pre>


Share this post

Link to post
Share on other sites
  • 2 years later...

Es hat sich gerade selber erledit. Nachdem ich den Debug Mode ausgeschaltet habe, funktioniert das Sortieren einwandfrei ohne Fehlermeldung

(English: For me the problem went away without doing anything except switch off debug mode).

  • Like 1

Share this post

Link to post
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...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More