Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Database error - I think


Recommended Posts

When I try to log into the admin area of my site - www.easy-matrix.com - I can't get in. I get the osCommerce error page which displays this:


1016 - Can't open file: 'orders.MYD'. (errno: 145)


select count(*) as count from orders where orders_status = '1'




I'm trying to process orders but I can't get in there.


Any ideas?


John Bethea :(

Link to comment
Share on other sites



If this is a live store, with alot of transactions, you might have a serious problem here.


You'll need to ask your host to restore the database from the latest backup. If they do a dump of the database each night, you should be able to pick through it and find that particular table, drop and re-create it, and insert all of your previous values.


If this is a new store, and losing previous orders isn't really a problem for you, then just drop and recreate the table.


NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

  • 2 weeks later...

FYI, that error mean that the table is corrupted. You can try doing a repair on it with the MySQL syntax "REPAIR TABLE orders;"







Link to comment
Share on other sites


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

  • Create New...