SQL Syntax error when reorder items ps 1.7

[transmetent]

Hi,

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

 

Thanks

Quote

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>

 

[transmetent]

I've the same problem

[Knowband Plugins]

I can see there is a bug in the SQL query. I think you need to report the same to the PS team.

Meanwhile I can provide the solution using the core file changes. Kindly let us know if you are okay with core file changes?

 

[transmetent]

Hi,

how can I report it to ps team?

[Guest]

Have you reported on Github?

[salouso]

Same problem here. Any solutions?

[Guest]

.

Edited July 26, 2021 by Guest (see edit history)

[salouso]

Hallo Guest

Wo muss ich das ändern? Ich bin eher neu mit PS unterwegs und MYSQL ist nicht mein Fachgebiet. Ist dies in einem File oder der DB zu ändern?

LG

[salouso]

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