currupt database

[bagged89s10]

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?

[michael_s]

Get the sql from the install directory in the oscommerce download package. Edit the sql file in a text editor, find the whos_online table sql and paste it into the sql box of phpmyadmin or whatever mysql front end you are using...

[bagged89s10]

Thanks but someone on another forum help me and I did the following...........

whos_online table deleted. Need help creating new one. - osCommerce Community Support Forums


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(12 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
);

[michael_s]

That is exactly what I told you to do... Glad you got it working.