Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

145-Table problem


Munki

Recommended Posts

Posted

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) :'(

Posted

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 :-"

Posted

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

Posted

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

Posted

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

Posted

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.

 

 

 

Archived

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

×
×
  • Create New...