Mysql error.

[DannyMilner]

After some server downtime I have now got a few mysql errors on my vb forum.

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=1 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;

This is when some members click on the private messages (private.php)

How can I repair it? tools.php?

And what do I need to tick to repair it

[Xenon]

please post the full errormessage, so we can see what exactly is wrong!

[DannyMilner]

Database error in vBulletin 3.5.3:

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=1 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, January 30th 2006 @ 04:59:05 PM
Script : http://mydomain.net/private.php
Referrer : http://mydomain.net/showthread.php?p=17236&posted=1
IP Address : removed
Username : Danny
Classname : vb_database

Thanks :)

[Zachery]

Database error in vBulletin 3.5.3:

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=1 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, January 30th 2006 @ 04:59:05 PM
Script : http://mydomain.net/private.php
Referrer : http://mydomain.net/showthread.php?p=17236&posted=1
IP Address : removed
Username : Danny
Classname : vb_database

Thanks :)

Error code 28: No space left on device

One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

[DannyMilner]

Error code 28: No space left on device

One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

It worked! Thanks Zachery