Bad SQL query - can't see shopping carts

[plutocrata]

Good afternoon, after upgrade to the version 1.7.8.4 using the 1-click-upgrade got this error when trying to see the shopping carts.

 

Bad SQL query
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'id_cart\`` DESC LIMIT 0, 50' at line 31

Any idea?

THanks in advance!

[Prestachamps]

Hi,

please enable the debug mode to see the exact location of the php code where this is happening, as most probably you have some old override or module which is not compatible with the new version of your upgraded shop.

Let me know the error, so I can help you out with this.

Kind regards, Leo.

[plutocrata]

 

Good point and thank you! It happened just after the version update... I couldnt post the code here

 

Edited April 6, 2022 by plutocrata (see edit history)

[plutocrata]

Ah, updated to 1.7.8.5 using the 1click update and remains the same

 

[knacky]

An incorrect sql notation can be seen in sql.
The file has been modified AdminCartsController.php

ORDER BY a.'\'id_cart\' ' DESC ...

and it should be right

ORDER BY a.id_cart DESC ...

Or there is a module installed that adds or adds $this->_orderBy ....

Edited April 7, 2022 by knacky (see edit history)

[plutocrata]

5 hours ago, knacky said:

$this->_orderBy

Interesting that I've replaced the AdminCartsController.php and they look the same... it works in another PS environment but not in this one...same error.

[knacky]

I wrote that some module or override can do it too !!!

[plutocrata]

Yeah, and I will investigate module by  module... however disabled all overrides and all non prestashop modules and the error remain.