Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1017 - Can't find file: 'whos_online.MYI' (errno:


phileve

Recommended Posts

Posted

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

Posted
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

 

 

I would say you lost an index file from your who's online table

Treasurer MFC

Posted

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! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Posted

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?

Posted

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! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Posted

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...