Announcement

Collapse
No announcement yet.

Database Error..

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Error..

    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.

    Code:
    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"

    Code:
    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

  • #2
    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.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X