Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

What Happened??!


Guest

Recommended Posts

Posted

Out of nowhere I get the following error:

 

-----

 

 

1016 - Can't open file: 'whos_online.MYI'. (errno: 145)

 

delete from whos_online where time_last_click < '1080234439'

 

[TEP STOP]

 

----

 

What would have happened??

Posted

In trying to research the problem....

 

I looked at the database and found the table 'whos_online' is in use???

 

When I tried to open it I got this error:

 

Can't open file: 'whos_online.MYI'. (errno: 145)

 

 

----

 

I'm leaning toward contacting my host to ask them if they can see anything obvious.

Posted

Ok...My Last post :huh:

 

I may be able to solve my own problem...

 

 

I'm debating on deleting the bad table and replacing it with a new one using the same name and structure.

 

Does anyone see a problem with doing that?

 

 

 

This whole thing still makes me nervous about SQL stability, so if anyone can answer why this happened I would really appreciate it.

Posted

I did solve the problem by droping the table and recreating it using the same strucgture and name.

 

Just incase anyone cares :)

Archived

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

×
×
  • Create New...