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.