No announcement yet.

memberlist Error database

  • Filter
  • Time
  • Show
Clear All
new posts

  • memberlist Error database

    Database error in vBulletin 3.8.4:

    Invalid SQL:

    SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

    , lastactivity AS lastvisittime

    FROM user AS user
    LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
    LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)

    WHERE 1=1
    AND (user.usergroupid IN (-1,6,30,28,7,31,5,27,2,34,35,36,3,29,41))

    ORDER BY user.username asc
    LIMIT 0, 30;

    MySQL Error : Error writing file '/tmp/MYsGf6B2' (Errcode: 28)
    Error Number : 3
    Request Date : Thursday, October 22nd 2009 @ 08:45:55 AM
    Error Date : Thursday, October 22nd 2009 @ 08:45:58 AM
    Script :
    Referrer :
    IP Address : ****
    Username : ****
    Classname : vB_Database
    MySQL Version : 5.0.81-community
    Hello everyone, the forum now I do not understand why MySQL failed writing, although all of the source server is running normally have a separate forum is my error above. I tried to remove the whole plugin but not all bugs, I hope you can help me in this matter.

  • #2
    Check your disk space for where the DB server is.

    If you don't fully control that DB server, have your host check the available space.

    Does this error repeat on a constant basis?

    PS: MySQL Error Code 28 = Disk out of space
    To be updated...


    • #3
      Error code 28: No space left on device -
      One or more partitions on your server is out of space or doesn't have enough space to complete this operation. You need to shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on disk space and either add more space or free up some.

      Please don't PM or VM me for support - I only help out in the threads.
      vBulletin Manual & vBulletin 4.0 Code Documentation (API)
      Want help modifying your vbulletin forum? Head on over to
      If I post CSS and you don't know where it goes, throw it into the additional.css template.

      W3Schools <- awesome site for html/css help


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