PDA

View Full Version : Table database error


Tien
6-15-04, 01:40 PM
Hey, I'm using invisionboard and there is a table called ibf_sessions

But lately I've been receiving this kind of error very often
This problem will fix after repair the table but it's really annoying when you have to repair the table one or two times a week. I already reported this and as they said quoted "We've checked this report and found that it's not a bug in IPB. (This is an auto-reply)
"


mySQL query error: DELETE FROM ibf_sessions WHERE running_time < 1087313335 or member_id='1'

mySQL error: Can't open file: 'ibf_sessions.MYI'. (errno: 145)
mySQL error code:
Date: Tuesday 15th of June 2004 09:28:55 AM


So are there anything that I can prevent this from happening?

Pig
6-15-04, 03:06 PM
Try searching their forums to see if anyone else mentions it. I really don't know. You can make a simple page to do it for you, and then either run it by calling the page, or setting up a cron job to do every couple days. I know that's a kludge, but not sure what your other options are.

DreamConcepts
6-15-04, 07:28 PM
Im getting the exact same error message so now I know at least its not just me.

This is my error.
mySQL query error: DELETE FROM ibf_sessions WHERE running_time < 1087333801 or ip_address='70.16.33.126'

mySQL error: Can't open file: 'ibf_sessions.MYI'. (errno: 145)
mySQL error code:
Date: Tuesday 15th of June 2004 03:10:01 PM

B&T
6-15-04, 08:13 PM
I don't use that board, but I assume that is a table of user sessions. Maybe their sessions table is getting overloaded some how (crawlers?). How long does it Keep session data? Try emptying the table (when no one is on the forum) and see if that solves the poblem for a while. But if you try that, take a backup first.

Of take a look in their support forum with those keywords.