plutocrata Posted April 6, 2022 Share Posted April 6, 2022 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! Link to comment Share on other sites More sharing options...
Prestachamps Posted April 6, 2022 Share Posted April 6, 2022 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. Link to comment Share on other sites More sharing options...
plutocrata Posted April 6, 2022 Author Share Posted April 6, 2022 (edited) 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) Link to comment Share on other sites More sharing options...
plutocrata Posted April 6, 2022 Author Share Posted April 6, 2022 Ah, updated to 1.7.8.5 using the 1click update and remains the same Link to comment Share on other sites More sharing options...
knacky Posted April 7, 2022 Share Posted April 7, 2022 (edited) 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) Link to comment Share on other sites More sharing options...
plutocrata Posted April 7, 2022 Author Share Posted April 7, 2022 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. Link to comment Share on other sites More sharing options...
knacky Posted April 7, 2022 Share Posted April 7, 2022 I wrote that some module or override can do it too !!! Link to comment Share on other sites More sharing options...
plutocrata Posted April 7, 2022 Author Share Posted April 7, 2022 Yeah, and I will investigate module by module... however disabled all overrides and all non prestashop modules and the error remain. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now