vendlus Posted August 18, 2003 Posted August 18, 2003 I suddenly started getting this error on my forums this morning out of nowhere. mySQL error: Can't open file: 'invis_topics.MYI'. (errno: 145)mySQL error code: 1016 Date: Monday 18th of August 2003 07:05:26 AM Basically, it's not opening the table invis_topics. Any ideas why?? When I go into phpMyAdmin, the tale is shown as "in use" and if I click on the properties, I get the same error as above. No one has access to the ftp or cpanel except me, and I was asleep when the problem started (about an hour ago). Anyone have any thoughts?? I'm on Server 35 if that helps. (Yeah, I've also sent a ticket to help, but thought maybe someone here is having the same problem or has run into this before.) - vendlus Quote
surefire Posted August 18, 2003 Posted August 18, 2003 I haven't seen that before so I doubt that my guess will hit the mark, but here it is anyhow: are you using persistent connection in your scripts? If so, you might want to change that so the connections lapse automatically. Look for mysql_pconnect() in your scripts. I've read that persistent connections are not advised for shared servers. Quote
vendlus Posted August 18, 2003 Author Posted August 18, 2003 It's the invision board, just like the one here. I've got no idea how it keeps the connection. I've added in a couple of minor mods (like new ibf codes for people to post with), but they've been in for weeks without problems (and I took from from invision's mod site, where no one mentioned any problems). Quote
vendlus Posted August 18, 2003 Author Posted August 18, 2003 Is there anyway to check the current connections to the database and kill them if they are there?? Quote
Head Guru Posted August 18, 2003 Posted August 18, 2003 I attempted to repair the issues on your DB and was unable to do so. Sorry That does not indicate that the errors are not fixable, it means someone with bigger brain power needs to look. I have sent your ticket over to our admin team for a peak. Alan or Mark will respond directly. If they can not restore it to a working state, we always have backups from last night that we can restore from. Bill Quote
vendlus Posted August 18, 2003 Author Posted August 18, 2003 Mark fixed it. And was even nice enough to tell me how to if it happens again. Rock Sign Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.