Who's Online table Crashed

[JorgeR]

1146 Table 'MYDATABASENAME_zenca15.zen_whos_online' doesn't exist

in:
[delete from zen_whos_online where time_last_click < '1392089929' or (time_entry=time_last_click and time_last_click < '1392090589')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I tried to follow Dr.byte and repair the table through the phpmyadmin but I cannot find the table. How do I repair the table?

please advice

Thanks

jorge

[JorgeR]

the table whos_online is gone, so I cannot repair it. How do I recreate the table? I tried the patch and it didn't t work.

Please advice

thanks

[lat9]

From your phpMyAdmin, click the SQL tab, paste the following into the textbox, changing DB_PREFIX_ to whatever your database prefix is and click "Go". Please note that this table structure is compatible with Zen Cart v1.3.9h, having been pulled from that version's SQL initialization file; other Zen Cart versions might have an updated structure:

#
# Table structure for table 'whos_online'
#

DROP TABLE IF EXISTS DB_PREFIX_whos_online;
CREATE TABLE DB_PREFIX_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;