[Forum] database error

[IncubuRs]

Database error in vBulletin 4.0.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=189 AND pm.folderid=0
            
            ORDER BY pmtext.dateline DESC
            LIMIT 0, 50;

MySQL Error   : Incorrect key file for table '/tmp/#sql_142e_0.MYI'; try to repair it
Error Number  : 126 

when I repair it it gives me error 28 storage engine error instead of this error

[IncubuRs]

and something else .. it says my searchcore_text table is crashed when I try to repair it :|

[Dody]

Did you try repairing it using phpMyAdmin?

[George L]

perror 28 = no space left on device meaning either one or more of your server's disk partitions are full or your /tmp doesn't have enough free disk space for repairing a table. You'd need at least 2x to 3x times amount of free disk space in /tmp as the size of the mysql table(s) you're repairing.

[IncubuRs]

perror 28 = no space left on device meaning either one or more of your server's disk partitions are full or your /tmp doesn't have enough free disk space for repairing a table. You'd need at least 2x to 3x times amount of free disk space in /tmp as the size of the mysql table(s) you're repairing.

You are great !!


to document the solution ...

1- Stop all services from command line
2- unmount /tmp
3- make a new /tmp
4- specify the size x3 was 1.5 giga bytes in my case as my database is 1.2 giga already
5- mount /tmp
6- do a repair then it is solved

[George L]

You're welcome