major oscom problems, still need help!

[dustytrb]

A few days ago we posted regarding a crash problem.....Our site has gone down and all that comes up are the lines that state:

 

145 - Table './******/whos_online' is marked as crashed and should be repaired

 

delete from whos_online where time_last_click < '1272386278'

 

How do I do this repair? Can still access the site via admin.

 

 

 

 

We have logged on via phpmyadmin, and the table has the samw error message, there is no way to browse the table. it just says "error" can I delete that table and reinstall it? if so, where can I get a fresh table from?

 

Now, days later, the same message comes up, but with a few different numbers:

 

 

145 - Table './tribal/whos_online' is marked as crashed and should be repaired

 

delete from whos_online where time_last_click < '1272667903'

 

 

Have tried to restore to an earlier save - from January - but nothing will work. Now the message comes when restore is attempted:

 

The server encountered an unexpected condition which prevented it from fulfilling the request.

The script had an error or it did not produce any output. If there was an error, you should be able to see it in the error log.

 

 

Cannot see anything in the error log...........

 

Really need some help and advice here, as no site means no income. Any thoughts or direction would be most appreciated

 

dusty

 

 

 

 

I have logged on via phpmyadmin, and the table has the samw error message, there is no way to browse the table. it just says "error" can I delete that table and reinstall it? if so, where can I get a fresh table from?

[♥mdtaylorlrim]

delete from whos_online

 

 

That should remove everything in the table. If it happens again I would simply rebuild the table from scratch.

 

 

DROP TABLE IF EXISTS whos_online;
CREATE TABLE IF NOT EXISTS whos_online (
 customer_id int(11) default NULL,
 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(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[dustytrb]

Thanks for the quick reply - will try this right away

 

dusty

[dustytrb]

This worked brilliantly and took only about 20 minutes to do. Thank you so much! -dusty

[Classic-Images]

delete from whos_online

 

 

That should remove everything in the table. If it happens again I would simply rebuild the table from scratch.

 

 

DROP TABLE IF EXISTS whos_online;
CREATE TABLE IF NOT EXISTS whos_online (
 customer_id int(11) default NULL,
 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(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

Hello, I'm somewhat new to all this oscommerce and php type stuff and I'm having the same Issue... To fix this issue all I have to do is delete my whos_online.php file? Will it create a new one once I do that? and will deleting the file have any effect on any of my products or anything else?

 

Thanks in advanced!

Phil

[jigga1234]

Hello, I'm somewhat new to all this oscommerce and php type stuff and I'm having the same Issue... To fix this issue all I have to do is delete my whos_online.php file? Will it create a new one once I do that? and will deleting the file have any effect on any of my products or anything else?

 

Thanks in advanced!

Phil

I would remove it. It doesnt do much, you cant get much information from it if you are on a shared server it can hammer your bandwidth. remove and get Google's analytics tool it is much better and does not need much work to get it started.

[MrPhil]

NO NO NO NO NO! This is the whos_online table that is to be emptied out (or deleted and recreated), not the whos_online.php file.

 

Your hosting control panel > MySQL databases should have a button to CHECK your database tables, and a button to REPAIR damaged ones.