Zen Cart Logo
Forums / General Questions / zen_whos_online crashed, how do I replace?

zen_whos_online crashed, how do I replace?

Locked

Views: 708

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
3 Mar 2009, 11:27 PM
#1
wahmania avatar

wahmania

New Zenner

Join Date:
Mar 2009
Posts:
2
Plugin Contributions:
0

zen_whos_online crashed, how do I replace?

Hi, ok the short story is I have a zen cart site hosted on a reseller server which crashed yesterday. All is restored excepted for the corruped whos_online table. The ISP has logged the problem but with many others to deal with I don't have time to wait for them to fix.

I've tried repairing in cpanel. I've tried running a repair table sql query. I think my only option left is to drop and replace the table.

When I create the table, can someone tell me what I need, ie how many fields etc? My backup db is stored with these people so getting that back right now is also not an option (and for all I know, is corrupted too).

Thanks for your help, much appreciated :)

3 Mar 2009, 11:46 PM
#2
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: zen_whos_online crashed, how do I replace?

in the zen cart distro
look in the zc_install/sql/ folder....

yu will see the zencart sql file

open it and grab the drop and insert statement for the whos online table

3 Mar 2009, 11:51 PM
#3
wahmania avatar

wahmania

New Zenner

Join Date:
Mar 2009
Posts:
2
Plugin Contributions:
0

Re: zen_whos_online crashed, how do I replace?

Thanks so much for your quick reply.

I just thought I'd mention if anyone else has this issue (and I saw there were similar past posts) that I also had to restore:

/admin/whos_online.php
includes/modules/sideboxes/whos_online.php

in order for it to work.