phileve Posted December 13, 2004 Posted December 13, 2004 I hope someone can help point us in the right direction here. As soon as anyone goes to the home page of our site www.securitytagshop.com the following error is displayed: 1017 - Can't find file: 'whos_online.MYI' (errno: 2) delete from whos_online where time_last_click < '1102933287' The site was taking orders fine on Sat but not working at all this morning, we have been up and running fine for about four months with no problems and now this seems to have come from nowhere. Could some helpful person please point me in the right direction to fixing this. Many Thanks
boxtel Posted December 13, 2004 Posted December 13, 2004 I hope someone can help point us in the right direction here. As soon as anyone goes to the home page of our site www.securitytagshop.com the following error is displayed: 1017 - Can't find file: 'whos_online.MYI' (errno: 2) delete from whos_online where time_last_click < '1102933287' The site was taking orders fine on Sat but not working at all this morning, we have been up and running fine for about four months with no problems and now this seems to have come from nowhere. Could some helpful person please point me in the right direction to fixing this. Many Thanks <{POST_SNAPBACK}> I would say you lost an index file from your who's online table Treasurer MFC
241 Posted December 13, 2004 Posted December 13, 2004 you have a bad table in the database that will require a repair FIX: The database table has crashed and needs to be repaired with the following SQL statement: repair table <table>; Replace the word "<table>" with the name of the table that needs to be repaired. No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
phileve Posted December 13, 2004 Author Posted December 13, 2004 Thanks for your quick response guys, I have just been into phpMyAdmin and the following tables seems to be missing: customers customers_basket whos_online I can't run a repair on these tables as I just get an error saying can't find. Is it possible to rebuild just these tables?
241 Posted December 13, 2004 Posted December 13, 2004 do you have a backup copy of the database that you can use No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
phileve Posted December 13, 2004 Author Posted December 13, 2004 I have rolled the database back to the last backup as of Friday night. Not ideal as we have lost the customers who signed up over the weekend but we have the orders that were placed and the site is back up and running again. Thanks for your help.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.