Goanna Posted January 15, 2004 Share Posted January 15, 2004 Okay, I put a site up, and it is all workign fine, accept that twice now it crashed because of the whos_online database table. Something keeps getting messed up with it. I have to go into phpmyadmin, drob the whos online table from my live shop database, then I go into the test shop and copy over its whos online table, and then it works with no problems. If this keeps up, can I just drop the table permenantly? Will the site work if I drop the table? Has anyone ever had this problem before? Please, any info is apreciated. This is the second time in two weeks that this happened. Link to comment Share on other sites More sharing options...
Guest Posted January 15, 2004 Share Posted January 15, 2004 perhaps it is something dealing with sessions? how is the session setup in the configure.php files? also, cookies, check those Wiki documentation explains these items Link to comment Share on other sites More sharing options...
Goanna Posted January 15, 2004 Author Share Posted January 15, 2004 I will take a look and see. Thanks for the reply. Any other information will still be apreciated though. Link to comment Share on other sites More sharing options...
Guest Posted January 15, 2004 Share Posted January 15, 2004 Your host has upgraded MySQL... the version of PHP on the server does not include MySQL client libraries that work properly with MySQL4 - the result is corrupt tables - usually whos_online and sessions in osCommerce. Matti Link to comment Share on other sites More sharing options...
Goanna Posted January 15, 2004 Author Share Posted January 15, 2004 Is there any way I can fix that? Can I permenantly drop the whos online table? Should I contact the host to see if they can do anything? Link to comment Share on other sites More sharing options...
Guest Posted January 15, 2004 Share Posted January 15, 2004 Have a look in the tips and tricks forum. There is a thread titled something like "Whos online temporary fix" which is all about this. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.