Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help Needed - I'v Deleted my visitors table!


iantates

Recommended Posts

It would seem that I have deleted my visitor table as when customers try to open a new account they are getting the following error message

 

1146 - Table 'db109416868.visitors' doesn't exist

 

update visitors set customers_id = '753' where browser_ip = '81.135.234.186' AND browser_language = 'en-gb' AND to_days(now()) - to_days(date) < 1

 

[TEP STOP]

 

Now I cant remeber deleting the visitor table but I cant can see it!

 

How do I reinstall it?

 

Many thanks

Link to comment
Share on other sites

"visitors" is not a standard OSC table. First check in phpMyAdmin to see if the table is really there or not. If it is, try a repair. If not, you need to find the contrib you used to add it, and run the SQL script provided in the contrib to recreate it (perhaps you added a contrib and never actually ran this script, so the table has never been there?)

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...