is there a fix for this?

[Guest]

I had another site with this error message and store was down.

 

I ran to repair the tables and got this message:

Repairing tables

designho_forum.phpbb_sessions

error : The handler for the table doesn't support repair

thefitne_osc.whos_online

 

Is there anyway to fix the whos_online table so this will stop happening?

[Ajeh]

Quick fix is a drop and re-create:

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

);

[wizardsandwars]

And complain to your host that they need to roll back to MySQL v 3.xx.

 

Version 4.1.12 is not stable in conjunction with the cpanel auto update.

[Guest]

Hi,

 

I did drop the table and redo it.

 

I am the host and I don't want to revert back to mysql 3.0.

 

There are only 2 sites that I'm having problems with.