bksmartit Posted March 3, 2021 Share Posted March 3, 2021 (edited) I have Prestashop 1.7.6.1 running and I would like to upgrade to 1.7.7.2 version but I can't upgrade it because I noticed when I clicked under 'Orders / Shopping Carts' showing error: Bad SQL query Table 'xxxxjqdz_pres379.pshop_a4875MaGn_connections' doesn't exist How to fix this? Thank you Edited March 7, 2021 by bksmartit (see edit history) Link to comment Share on other sites More sharing options...
Rhobur Posted March 4, 2021 Share Posted March 4, 2021 Is this, xxxxjqdz_pres379.pshop_a4875MaGn, your tables prefix? Do all your tables start with this string? Link to comment Share on other sites More sharing options...
bksmartit Posted March 4, 2021 Author Share Posted March 4, 2021 Yes, it does. Link to comment Share on other sites More sharing options...
bksmartit Posted March 5, 2021 Author Share Posted March 5, 2021 Any idea? Why do I have this error under 'Orders / Shopping Carts' and how to fix this? I would like to fix this before I upgrade to 1.7.7.2. Thank you for any help! Link to comment Share on other sites More sharing options...
Rhobur Posted March 5, 2021 Share Posted March 5, 2021 (edited) Does this table (with this identical name) really exists in your database? Edited March 5, 2021 by Rhobur (see edit history) Link to comment Share on other sites More sharing options...
bksmartit Posted March 5, 2021 Author Share Posted March 5, 2021 Thank you Rhobur. I checked my database and it doesn't exist there? So how to fix this? Link to comment Share on other sites More sharing options...
Rhobur Posted March 5, 2021 Share Posted March 5, 2021 (edited) Using the mysql console or phpmyadmin or adminer or similar export the table ps_connections from a fresh default Prestashop install and import it into your current database then change its name from ps_connections to xxxxjqdz_pres379.pshop_a4875MaGn_connections. Or export it from whatever other install, import it, rename it and empty it so it won't have unrelated data in it. Edited March 5, 2021 by Rhobur (see edit history) Link to comment Share on other sites More sharing options...
bksmartit Posted March 6, 2021 Author Share Posted March 6, 2021 Thank you VERY MUCH Rhobur!!! I did it what you recommended. I never done this before but it works and this "Bad SQL query" error disappeared. I had to not only rename the file with the proper name but also I had to edit ps_connections.sql to change its name, etc so this table work properly with my live database. Basically, had 3 missing tables from my live database: _connections _connections_page _connections_source I had to import them from a fresh default Prestashop install. 1 Link to comment Share on other sites More sharing options...
Rhobur Posted March 7, 2021 Share Posted March 7, 2021 Glad it works! These tables are for statistical purposes only, if you don't use PS statistic dashboard (the stats about visitors etc) they can be periodically emptied since in time they grow quite big slowing the dash. Please edit your first post and [SOLVED] before the post title so other people find it when looking for a similar problem. 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