missing whos_online table

[eastboy]

Hello all

I am getting an error when trying to access my online store -->" whos_online table missing"
I would like to recreate the table again in MySQL using phpMyadmin but am not sure what the columns and overall structure is.

If anybody can point me in the right direction much appreciated...

Thanks guys

Eastboy

[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.