Database error in PM's

[newmasalaboard]

Hello,

Actually whenever we open inbox or something related to private messaging the we are facing a DB error.Its says :

Database error in vBulletin 3.7.0:

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 : Can't create/write to file '/tmp/#sql_c72_0.MYI' (Errcode: 30)
Error Number : 1
Request Date : Tuesday, August 12th 2008 @ 05:20:22 AM
Error Date : Tuesday, August 12th 2008 @ 05:20:22 AM
Script : http://www.newmasalaboard.info/private.php
Referrer : http://www.newmasalaboard.info/private.php
IP Address : XXXXXXXXX
Username : XXXXXXXXX
Classname : vB_Database
MySQL Version : 5.0.51a-community

Please help me to solve the problem !!

[Marco van Herwaarden]

Most likely your /tmp directory is full. Please contact your host to resolve this problem.

PS Sometimes a reboot of the server will solve this issue.

[newmasalaboard]

Now the whole forum is giving database errors :(

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1218675414 AND open <> 10, 1, 0)) AS newthread

FROM thread AS thread


WHERE forumid = 2
AND sticky = 0

AND visible IN (0,1,2);

MySQL Error : Table 'thread' is marked as crashed and should be repaired
Error Number : 1194
Request Date : Wednesday, August 13th 2008 @ 10:53:58 PM
Error Date : Wednesday, August 13th 2008 @ 10:53:58 PM
Script : http://www.newmasalaboard.info/forumdisplay.php?f=2
Referrer :
IP Address : XXXXXXXXXXX
Username : XXXXXXXXXX
Classname : vB_Database
MySQL Version : 5.0.51a-community

[Opserty]

AdminCP > Maintenance > Repair/Optimize table. Repair the "thread" table.

If you can't access the AdminCP, you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

[newmasalaboard]

I tried to repair but its giving following error even after repeating it couple of times :(

[Marco van Herwaarden]

Please contact your host.