missing whos_online table

[Ajeh]

You can recreate it with the original SQL code found in /zc_install/sql/mysql_zencart.sql

check if you are using prefixes, and if so you need to adjust the table name references ...

[eastboy]

Thank You very much Ajeh

All working

[Ajeh]

Thanks for the update that this was able to fix your missing table ...

[thevagr1]

Thank you also for putting this information up.
I have been trying all day to get my site back up after it all went blank save the warning message onscreen instead of my website.
I thought it was a server side issue until I re-installed the entire zen cart and it still happened.

myDEBUG in the cache folder was a great help and then this article solved it all for me.

Thanks very much

[Cross]

You can recreate it with the original SQL code found in /zc_install/sql/mysql_zencart.sql

check if you are using prefixes, and if so you need to adjust the table name references ...

Ajeh, I'm having this problem. Where can I find out how to do the above?

Thanks.

[Ajeh]

prefixes on the database tables would mean that when you look at your database in phpMyAdmin your would see something like:
zen_admin

vs seeing:
admin

but the better way to check is to look in your two files:
/includes/configure.php
/your_secret_admin/includes/configure.php

for the line:

  define('DB_PREFIX', '');

and see if that is blank or has a value ...

Or, you could run in the Tools ... Install SQL Patches ... the code:

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

which will make the table for you and manage the prefixes for you ...

[Cross]

Thanks so much! I will try this.