Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

is there a fix for this?


Guest

Recommended Posts

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?

Link to comment
Share on other sites

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

);

Link to comment
Share on other sites

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.

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...