Got error 28 from table handler

[johnie]

Hi. I have a script which returns me the error "Got error 28 from table handler ".
I have several sql queries in this script and even if i enter a descriptive text in case each query fails instead of mysql_error(), i still get the error 28 and i don't know which query has the problem.
What is this error about?

My host is using MySQL 3.23.32 (old!!).
I tested it on a host on 3.23.49 and it worked fine.

Thanks

John

[[deleted]]

Searching helps.

error 28 means 'disk full'

[johnie]

The script is doing "SELECTs" and not inserts. Does SELECT have to do with full disk?

John

[[deleted]]

Apparently. 🙂

[johnie]

The script is divided into sections according to the request. Most requests behave normally except one that gets me the error 28. Almost the whole site behaves normally except 2-3 requests. And i'm doing inserts without any problems.
When i run all the queries i have in MySQL Front i got all the results without any errors.
It just doesn't make any sense to me

john

[[deleted]]

well, mysql's "perror" says that error 28 means 'disk full'

You may want to repear your tables using myisamchk, mysql has a reputation of f*cking up it's datafiles giving weird behaviour.

[johnie]

Nothing works vincente 🙂
For sure it's not the version cause the queries work in the GUI.

John

[[deleted]]

Did you fix the datafiles?

[johnie]

Yes

[[deleted]]

My guess is you need to try a few different parameters. If the inserts are working then it can't be a disk-full, so the datafiles must be corrupted.