| |
Haven't registered yet? Do it here now!
|
Porndude
Joined: 17 Mar 2007
Posts: 21
|
|
|
 |
|
 |
|
 Posted: Sun Mar 18, 2007 11:16 pm Post subject: getting error number 145 Cant Open boevents.MYI |
 |
|
|
 |
|
 |
|
|
|
|
this is the error I'm getting when I try to see System Events
Query to MySQL Failed: Can't open file: 'boevents.MYI'. (errno: 145)
help!
-Adam |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Sun Mar 18, 2007 11:21 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
hi there, looks like your "boevents" mysql table got corrupted. If you have phpmyadmin go and repair the table or contact your host and tell them to repair the table.
Keep me posted on more problems..
_________________
Thanks,
Kaktusan
 |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Sun Mar 18, 2007 11:22 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
huh, you might want to look whats up with your mysql and if its configured okay, coz you installed the software before couple of days and you got corrupted table, while noone else still got a corrupted table in with BO.. pretty strange..
_________________
Thanks,
Kaktusan
|
|
|
|
|
|
|
|
Porndude
Joined: 17 Mar 2007
Posts: 21
|
|
|
|
|
|
|
| Posted: Mon Mar 19, 2007 12:37 am Post subject: |
|
|
|
|
|
|
|
|
|
|
well, so far, I'm stuck with the error. Even after support ran a repair on the table.. Tech had this to say...
I ran a repair on that database, see if it still reports the error. I can't hazard a guess as to why the table may have become corrupted, as that sort of thing is extremely difficult to troubleshoot. To hazard a wild guess, I did have to restart mysql a couple of hours ago because someone's script wasn't closing tables properly, so it's possible that it was either your script doing this, OR that the abrupt shutdown caused the corruption on this table. It was a graceful mysql restart, though, so it should not have corrupted anything. I would suggest watching it for the time being and if it happens again it may bear further investigation.
Thanks. |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Mon Mar 19, 2007 12:44 am Post subject: |
|
|
|
|
|
|
|
|
|
|
so, after the repair its corrupted again?
well, your support gave a good reply and if all works now watch it over and if it happens again then it should be investigated. As i said in my earlier reply it is kinda strange, because this is the first time a mysql table of BO got corrupted and even so soon after a new install..
_________________
Thanks,
Kaktusan
|
|
|
|
|
|
|
|
Porndude
Joined: 17 Mar 2007
Posts: 21
|
|
|
|
|
|
|
| Posted: Mon Mar 19, 2007 2:28 am Post subject: |
|
|
|
|
|
|
|
|
|
|
well, now it appears to be working, but I only see one entry
2007-03-17 12:47:02 BO Updater executed successfully
and nothing further.. I've run a few UPDATEs on blogs to get some new entries pulled in, but nothing...
something is strange here for sure.
-A |
|
|
|
|
|
|
|
Porndude
Joined: 17 Mar 2007
Posts: 21
|
|
|
|
|
|
|
| Posted: Mon Mar 19, 2007 3:14 am Post subject: |
|
|
|
|
|
|
|
|
|
|
got this error now...
Query to MySQL Failed: Got error 127 from table handler
wtf?! |
|
|
|
|
|
|
|
Porndude
Joined: 17 Mar 2007
Posts: 21
|
|
|
|
|
|
|
| Posted: Mon Mar 19, 2007 3:20 am Post subject: |
|
|
|
|
|
|
|
|
|
|
It sometimes works but still only shows the one server event I mentioned before.. but then sometimes I check System events, it shows the error 127 now. Its back and forth.. what the hell!?
now this, the latest..
Could not connect to MySQL Server: Lost connection to MySQL server during query |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Mon Mar 19, 2007 9:13 am Post subject: |
|
|
|
|
|
|
|
|
|
|
humm, there is definitely something wrong with the mysql server...
get your host support look at the mysql server again and probably you will need to provide me url and pass for BO and ftp access to see whats up with your install, coz definitely things are pretty much wrong..
Let me know..
_________________
Thanks,
Kaktusan
|
|
|
|
|
|
|
|
Porndude
Joined: 17 Mar 2007
Posts: 21
|
|
|
|
|
|
|
| Posted: Mon Mar 19, 2007 9:30 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
we dumped the db and I started over.. I didn't have much in there anyway so its ok..
now it seems to be working fine.. fingers crossed because I know Murphy's Law could kick in..
we'll see. 
thanks for your help! |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Mon Mar 19, 2007 10:16 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
i see, thats fine. Well and i hope all to be fine, coz definitely the situation was pretty weird with those unusual mysql problems..
keep me posted..
_________________
Thanks,
Kaktusan
|
|
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|
 |
|
 |
| |
