Veeps Posted February 26, 2007 Share Posted February 26, 2007 I have an error with my whos_online table. I tried to repair it and deleted it by accident. How do I create a new one? Link to comment Share on other sites More sharing options...
user99999999 Posted February 27, 2007 Share Posted February 27, 2007 Go to phpMyAdmin sql box and paste the followin in then click go. You can fine all the sql in the install dir of osc zip "oscommerce.sql" DROP TABLE IF EXISTS whos_online; CREATE TABLE whos_online ( customer_id int, full_name varchar(64) NOT NULL, session_id varchar(128) NOT NULL, ip_address varchar(15) NOT NULL, time_entry varchar(14) NOT NULL, time_last_click varchar(14) NOT NULL, last_page_url varchar(64) NOT NULL ); Link to comment Share on other sites More sharing options...
Veeps Posted February 27, 2007 Author Share Posted February 27, 2007 awesome! Thanks for the quick response and help. My site is up and running again. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.