Who's online table keeps crashing.

[sharc316]

Hi,

My who's online table keeps on crashing and takes the whole website down.

Can anyone please advice what I can do with this?

website: www.bequjuice.com

[Ajeh]

First, go to phpMyAdmin and locate your database to find your tables ...

Then click the checkbox next to:
whos_online

Now, in the bottom Dropdown, select:
Repair

See if that corrects the problem ...


If not, you could try remaking it and seeing if that fixes it:

DROP TABLE IF EXISTS whos_online;
CREATE TABLE whos_online (
  customer_id int(11) default NULL,
  full_name varchar(64) NOT NULL default '',
  session_id varchar(128) NOT NULL default '',
  ip_address varchar(15) NOT NULL default '',
  time_entry varchar(14) NOT NULL default '',
  time_last_click varchar(14) NOT NULL default '',
  last_page_url varchar(255) NOT NULL default '',
  host_address text NOT NULL,
  user_agent varchar(255) NOT NULL default '',
  KEY idx_ip_address_zen (ip_address),
  KEY idx_session_id_zen (session_id),
  KEY idx_customer_id_zen (customer_id),
  KEY idx_time_entry_zen (time_entry),
  KEY idx_time_last_click_zen (time_last_click),
  KEY idx_last_page_url_zen (last_page_url)
) ENGINE=MyISAM;

[sharc316]

Ajeh,

Yes, that does fix it. But the table crashed yesterday and I repaired it through phpMyAdmin. Then this morning it's crashed again. So I repaired again with phpMyAdmin.

Do you suggest I remake it? Where do I put the code above?

[Ajeh]

If you have tried and failed Repair in phpMyAdmin, then click on the SQL link in the header and paste the SQL code to DROP/CREATE it again and see if that corrects the problem ...

[sharc316]

Ajeh,

So I'm still having issues with tables crashing. The who's online and sessions tables keep crashing continuously. I have to check the website constantly throughout the day to see if it crashed to repair it. Otherwise the site will be down.

Do you have any idea about what could be causing this?

When I do the repair the website is back up and running but then it crashed again the next day or even same day. I don't want to mess up the site completely where I cant repair it. Will dropping the tables take the site down?

[Ajeh]

NOTE: THE CODE HERE IS SPECIFIC TO v1.3.9h. DO NOT USE ON OTHER VERSIONS!!!

You could set your site to Down for Maintenance for a minute, then run the following SQL in the Tools ... Install SQL ...

DROP TABLE IF EXISTS whos_online;
CREATE TABLE whos_online (
  customer_id int(11) default NULL,
  full_name varchar(64) NOT NULL default '',
  session_id varchar(128) NOT NULL default '',
  ip_address varchar(15) NOT NULL default '',
  time_entry varchar(14) NOT NULL default '',
  time_last_click varchar(14) NOT NULL default '',
  last_page_url varchar(255) NOT NULL default '',
  host_address text NOT NULL,
  user_agent varchar(255) NOT NULL default '',
  KEY idx_ip_address_zen (ip_address),
  KEY idx_session_id_zen (session_id),
  KEY idx_customer_id_zen (customer_id),
  KEY idx_time_entry_zen (time_entry),
  KEY idx_time_last_click_zen (time_last_click),
  KEY idx_last_page_url_zen (last_page_url)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS sessions;
CREATE TABLE sessions (
  sesskey varchar(32) NOT NULL default '',
  expiry int(11) unsigned NOT NULL default '0',
  value mediumblob NOT NULL,
  PRIMARY KEY  (sesskey)
) ENGINE=MyISAM;

These will drop those two tables and rebuild them for you ...

[sharc316]

Do I have to set the site down for maintenance or can I just run the code?

Just want to make sure I'm doing this right. I'm going to tools then Install SQL Patches. In the dialog box there I run the codes you provided once at a time?

My version of zencart is: v1.3.9h

Please let me know if I got this right.

[Ajeh]

You can just run the SQL code without the Down for Maintenance ... The advantage of the Down for Maintenance is you can post a 15 minute warning that the site will be down for 5 minutes and to login to save current carts for your customers ...

If no one is on your site right now, then you can just run the two SQLs ...

They do run quickly, as in a few seconds.

The Down for Maintenance would just be a nice for your customers who might be shopping and not logged in so they have a change to login so that their current cart is saved before you run those two SQL.

They can be run separately or together in the Install SQL Patches ...

[sharc316]

Ajeh,

Thanks for the help. I ran the codes and I guess we'll just have to wait and see if the tables crash again.

[sharc316]

Hi Ajeh,

So the rebuilding the tables worked for a few days but yesterday night the sessions table crashed. I repaired it. Then this morning who's online crashed. This takes the whole site down. I rebuilt the tables again.

Any idea why this is happening? I really don't know what to do at this point.

Please help.