Jump to content
Simon Christiansen

[SOLVED] Bad SQL query Table 'ndosupply_dk_db.clk_9367875130_connections' doesn't exist

Recommended Posts

Hi there.

Im facing an issue on my shop, when clicking the costumers tab no customer data is shown, and i get the error "Bad SQL query Table 'ndosupply_dk_db.clk_9367875130_connections' doesn't exist"

I cant find a way to fix this, can anyone provide a fix for it? Best regards! :)

PrestaShop-version: 1.7.0.4

 

Edited by Simon Christiansen (see edit history)

Share this post


Link to post
Share on other sites

via phpmyadmin check that connections table exists, there are 3 connection type tables.

Share this post


Link to post
Share on other sites

1. back up your db via phpmyadmin, make sure to download to local

2. import the following attached file via phpmyadmin,  note you can also copy the commands and execute in sql tab of phpmyadmin

connections.sql

(I did not test this, but it's a dump of a 1.7.6.1 shop)  (you did not post your ps version)

 

Edited by El Patron (see edit history)

Share this post


Link to post
Share on other sites

Update. i when i searched tables inside the database i noticed a table called ps_connections. i renamed this to ndosupply_dk_db.clk_9367875130_connections, now the backend gives me Unknown column 'c.date_add' in 'field list' instead

Share this post


Link to post
Share on other sites

Problem solved. I renamed the newly renamed ndosupply_dk_db.clk_9367875130 to ndosupply_dk_db.clk_9367875130_OLD and uploaded the one from El Patron and renamed it ndosupply_dk_db.clk_9367875130, even though versions was not similar it solved the problem.

Thanks alot El Patron!

  • 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