Hundreds of error 28 messages

[Frank Woolf]

My hosting company recently updated my vBulletin to the latest version. I tried accessing vBulletin options in the Admin panel and got this error:
Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder 0
ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error : Got error 28 from table handler
Error Number : 1030
Date : Sunday, November 27th 2005 @ 11:35:45 PM
Script : http://motorcyclephilippines.com/forums/admincp/options.php?null=0
Referrer : http://motorcyclephilippines.com/forums/admincp/forum.php?do=modify
IP Address : 210.213.196.141
Username : Frank Woolf
Classname : vb_database


Then I started getting hundreds of error messages and nobody can add attachments to posts.
I am using an SQL manager to try to repair the database but have been waithing for it to finish for hours.

One of the error messages:

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=9247 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;

MySQL Error : Got error 28 from table handler
Error Number : 1030
Date : Monday, November 28th 2005 @ 03:34:31 AM
Script : http://motorcyclephilippines.com/forums/private.php
Referrer : http://motorcyclephilippines.com/forums/private.php
IP Address : 210.213.145.155
Username : raptor_1108
Classname : vb_database

Can anyone tell me, in simple terms, what I should do? Many thanks

[Boofo]

Try to REPAIR the tables.

[Frank Woolf]

Thanks, I hate to be so ignorant but while I vaguely know what chmod is I don't think I have it. I do have a file manager in the site control manager that allows me to change permissions. Can I use that?

Can you be more specific on what tables need to be made executable by anyone (or how I see from the error messages which need to be changed) and maybe where they are?

Thanks again

[Boofo]

REPAIR the tables in your Admin CP under Maintenance > Optimize/Repair tables. ;)

[calorie]

Error code 28: No space left on device

[Boofo]

Error code 28: No space left on device

Right, and repairing the tables should fix that. ;)

[Frank Woolf]

Thank you guys. I should have asked hours ago instead of struggling and getting my brain fried trying to fix it.

I checked my server and a disk was 100% full. I asked the Hosting Co to fix it and as they made space on the disk everything started working again.

I am now repairing/optimizing all the tables.

Thank you again.

[calorie]

Right, and repairing the tables should fix that. ;)

http://dev.mysql.com/doc/refman/5.0/en/full-disk.html

http://www.vbulletin.com/forum/showpost.php?p=1018209&postcount=10

;)

[Frank Woolf]

My problem is that I work such very long hours on the site I never have time to learn the server side stuff and I have nobody here to ask for advice. I guess you know how it feels to have a big problem but don't know how to fix it and have nobody to help.

In the last few weeks my sites have been hacked, the hosting company changed ownership and now want to triple the hosting charges while giving far worse service, The hosting company lost ten thousnad images from my members galleries when they moved the site to their new servers, I am trying to move to a new hosting company before I am forced pay extortionate fees for next month and the new hosting company are taking days to get things set up.

It has been a very difficult time. I tell you this because it will help you see how really gratefull I am for your help.

Thanks again.

[Paul M]

Right, and repairing the tables should fix that. ;)Hmm, are you sure about that ?

[Boofo]

And I quote. ;)

mysql error number: 1030 = The partition on which the MySQL data is stored is full.
Possible cause: MySQL-Tempfile reached its maximum size.
Recommendation: Shut down the forums and contact your host immediately!

From Xenon:
Tablehandler errors can sometimes be other problems, too.
Try to REPAIR the tables.
If that doesn't work, maybe this trick will: In phpmyadmin add a field to the table, and after that delete the field again. Last time I could solve the error this way.

[Marco van Herwaarden]

Tablehandler errors, can come because a variety of reasons, some can be fixed with a repair.

Error 28 is simply no space left, and should be solved by making free space (followed by a repair).

[Boofo]

Right. I never said it WOULD fix it but was only showing a place to start from. ;)