Munki Posted June 11, 2010 Posted June 11, 2010 I have just checked the front end of my website to find it has crashed and is showing the following message: 145 - Table './munki_osc1/whos_online' is marked as crashed and should be repaired delete from whos_online where time_last_click < '1276228748' [TEP STOP] Can someone tell me how to fix this and also ow to prevent it happening again. It has happened once before and it cost me a lot of $$'s to get someone to sort who, after billing me, advised me he had been unable to do so until posted a query on this forum and received the necessary information - I am hoping to bypass the expense this time :o). Many thanks in anticipation Jenne (aka Munki) :'(
Munki Posted June 11, 2010 Author Posted June 11, 2010 In case someone need the website to see for themselves, the website is www.MuranoNZ.com and I have all access required, I just need to know what to do :-"
Jan Zonjee Posted June 11, 2010 Posted June 11, 2010 145 - Table './munki_osc1/whos_online' is marked as crashed and should be repaired Try PHPMyAdmin to run the repair command: repair whos_online It that doesn't help you could drop that table and add it again. Use the equivalent code you have in a backup of the database (you might have added contributions). This is from a default RC2a osCommerce installation: 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 text NOT NULL );
Munki Posted June 11, 2010 Author Posted June 11, 2010 Hi Jan, thanks for helping me. I have found PHPMyAdmin through the C-Panel but having opened it, I do not have a clue where to go to run the "repair whos_online" command you suggest. I can use a computer very competently, I can upload & create my own website listings - from there I am very much novice so some detailed instructions would be helpful. Once I have this sorted I will file the information away safely so I will know what to do next time it happens. cheers Jenne
Munki Posted June 11, 2010 Author Posted June 11, 2010 Hi Jan I have now found the PHPMyAdmin through the C-Panel and the who's online database under osc1. Do I now click 'edit' and type in the 'repair whos_online' command? thanks Jenne
NodsDorf Posted June 11, 2010 Posted June 11, 2010 Hi Jan I have now found the PHPMyAdmin through the C-Panel and the who's online database under osc1. Do I now click 'edit' and type in the 'repair whos_online' command? thanks Jenne Your cpanel /myPHPadmin may already have a button to "repair" the table. If not select the table, then select the SQL tab, it should be some where near the middle top. Then in the text box type in (clear anything in there first) repair whos_online Then hit go.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.