No announcement yet.

New DB error after upgrade...?

  • Filter
  • Time
  • Show
Clear All
new posts

  • New DB error after upgrade...?

    I upgraded last week, and now I started getting this error today:

    Database error in vBulletin 3.8.4:
    Invalid SQL:
      SELECT albumpicture.*, album.*, user.username, user.usergroupid, picture.caption,
      IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
      FROM albumpicture AS albumpicture
      LEFT JOIN album AS album ON(album.albumid = albumpicture.albumid)
      LEFT JOIN user AS user ON(user.userid = album.userid)
      LEFT JOIN picture AS picture ON(albumpicture.pictureid = picture.pictureid)
      WHERE album.state = 'public'
      ORDER BY rand(NOW()) DESC LIMIT 0, 3;
    MySQL Error   : Can't create/write to file '/var/lib/mysql/#sql_3f06_0.MYI' (Errcode: 24)
    Error Number  : 1
    Request Date  : Monday, October 12th 2009 @ 04:54:56 PM
    Error Date    : Monday, October 12th 2009 @ 04:55:44 PM
    Script        :
    Referrer      :
    IP Address    :
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
    Thank You...Mick Knutson

    BLiNC Magazine Forums: "Everything you ever wanted to know about BASE-Jumping, but didn't know whom to ask."

  • #2
    OS error code 24: Too many open files

    This is a server issues. You need to contact your host about this. They will likely need to reboot the server.
    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.


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