jhbethea Posted February 11, 2004 Share Posted February 11, 2004 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' [TEP STOP] I'm trying to process orders but I can't get in there. Any ideas? John Bethea :( Link to comment Share on other sites More sharing options...
wizardsandwars Posted February 11, 2004 Share Posted February 11, 2004 Ouch. 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 More sharing options...
KA-300 Posted February 25, 2004 Share Posted February 25, 2004 FYI, that error mean that the table is corrupted. You can try doing a repair on it with the MySQL syntax "REPAIR TABLE orders;" Regards, Kieran ___________________________ Kieran [email protected] 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.