Announcement

Collapse
No announcement yet.

Database error when clicking on profiles, etc.

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

  • [Forum] Database error when clicking on profiles, etc.

    Database error in vBulletin 4.2.0:


    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 = 195777
    AND userlist.type = 'buddy'
    AND userlist.friend = 'yes'

    ORDER BY RAND()
    LIMIT 0, 6;


    MySQL Error : Can't create/write to file '/ramcache/tmp/#sql_5259_0.MYI' (Errcode: 2)
    Error Number : 1
    Request Date : Tuesday, July 17th 2012 @ 12:13:23 AM
    Error Date : Tuesday, July 17th 2012 @ 12:13:23 AM
    Script : http://www.mydomain.com/forums/membe...95777-username
    Referrer : http://www.mydomain.com/forums/private.php
    IP Address : <myip>
    Username : Adminstrator
    Classname : vB_Database
    MySQL Version : 5.1.63-cll

  • #2
    This is a permission issue. It is something that you will have to talk to your host about. Or do you have your own dedicated box?

    Comment

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