vBulletin error Help

[cyberloads]

Hi

I am getting this error i when i go to my private messages. Does anyone know how to fix it

Database error in vBulletin 4.0.2:

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_54a6_0.MYI' (Errcode: 13)
Error Number  : 1
Request Date  : Wednesday, April 7th 2010 @ 06:34:31 AM
Error Date    : Wednesday, April 7th 2010 @ 06:34:32 AM
Script        : http://www.cyberloads.info/forum/private.php
Referrer      : http://www.cyberloads.info/forum/forum.php
IP Address    : 82.2.15.190
Username      : OBX
Classname     : vB_Database
MySQL Version : 5.0.89-community

If you do please add me on cyberloads@hotmail.co.uk

cyberloads Reviewed by cyberloads on 7th Apr 2010. vBulletin error Help Hi I am getting this error i when i go to my private messages. Does anyone know how to fix it Database error in vBulletin 4.0.2: Invalid SQL: SELECT pm.*, pmtext.* , icon.title AS icontitle, icon.iconpath Rating: 5

[ProtoWorker]

Reconnect to database with a new user

[Profit]

Still having problems with this?

[Baraka]

Hi

I am getting this error i when i go to my private messages. Does anyone know how to fix it

Database error in vBulletin 4.0.2:

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_54a6_0.MYI' (Errcode: 13)
Error Number  : 1
Request Date  : Wednesday, April 7th 2010 @ 06:34:31 AM
Error Date    : Wednesday, April 7th 2010 @ 06:34:32 AM
Script        : http://www.cyberloads.info/forum/private.php
Referrer      : http://www.cyberloads.info/forum/forum.php
IP Address    : 82.2.15.190
Username      : OBX
Classname     : vB_Database
MySQL Version : 5.0.89-community

If you do please add me on cyberloads@hotmail.co.uk

Expand

"MySQL Error : Can't create/write to file '/tmp/#sql_54a6_0.MYI' (Errcode: 13)"

that is a server issue with the MySQL socket which needs to be fixed by user host unless your on a vps or dedi you can fix it ," tmp" folder can as be chmod to 666 i do hope this help ya (worked for me when i had this issue

[EsotorisK]

Just repair your database then.
It happened to me too and a friend helped me in rectifying the error.
And then goto admincp and then AdminCP > Maintainance > Repair / Optimize Tables