Database Error..

[Chalz]

This was a fresh install 3.7.1. No hacks no mods no template edits.


I get this error while trying to view some users profiles. Some work, some get this error.

Database error in vBulletin 3.7.1:

Invalid SQL:

                SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb
                    
                FROM userlist AS userlist
                INNER JOIN user AS user ON (user.userid = userlist.relationid)
                LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
                LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) 
                
                WHERE userlist.userid = 1
                    AND userlist.type = 'buddy'
                    AND userlist.friend = 'yes'
                    
                ORDER BY RAND()
                LIMIT 0, 5;

MySQL Error   : Can't create/write to file '/tmp/#sql_966_0.MYI' (Errcode: 13)
Error Number  : 1
Request Date  : Saturday, May 31st 2008 @ 09:32:03 PM
Error Date    : Saturday, May 31st 2008 @ 09:32:03 PM
Script        : http://*****.com/forum/member.php?u=1
Referrer      : http://*****.com/forum/index.php
IP Address    : *.*.*.*
Username      : *******
Classname     : vb_database
MySQL Version : 5.0.51a-log

I also get this DB error when in admincp when I click "vbulletin options"

Database error in vBulletin 3.7.1:

Invalid SQL:

        SELECT setting.*, settinggroup.grouptitle
        FROM settinggroup AS settinggroup
        LEFT JOIN setting AS setting USING(grouptitle)
        WHERE settinggroup.displayorder <> 0
        ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error   : Can't create/write to file '/tmp/#sql_966_1.MYI' (Errcode: 13)
Error Number  : 1
Request Date  : Saturday, May 31st 2008 @ 09:28:18 PM
Error Date    : Saturday, May 31st 2008 @ 09:28:19 PM
Script        : http://*****.com/forum/admincp/options.php?null=0
Referrer      : http://*****.com/forum/admincp/index.php?do=nav
IP Address    : *****
Username      : *****
Classname     : vb_database
MySQL Version : 5.0.51a-log

Any ideas what is causing this?

Note: everything was working fine for a few days. then this started.

Thanks
Charles

[Steve Machol]

OS error code 13: Permission denied

This means that either there is no root /tmp directory on this server and/or it is not chmod'd to 1777. You need to contact your host about this.