Announcement

Collapse
No announcement yet.

Strange DB error

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

  • [Forum] Strange DB error

    Hi all, i have received this error from my database :
    Code:
      Database error in vBulletin 4.1.11:
       
      Invalid SQL:
       
                                     SELECT
                                                     post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
                                                     user.*, userfield.*, usertextfield.*,
                                                     icon.title as icontitle, icon.iconpath,
                                                     avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
                                                     
                                                     
                                                     
                                                     editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
                                                     editlog.reason AS edit_reason, editlog.hashistory,
                                                     postparsed.pagetext_html, postparsed.hasimages,
                                                     sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
                                                     sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
                                                     IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
                                                     
                                                     ,blog_user.entries
                                     FROM post AS post
                                     LEFT JOIN user AS user ON(user.userid = post.userid)
                                     LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
                                     LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
                                     LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
                                     LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
                                     
                                                     
                                     LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
                                     LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 61 AND postparsed.languageid = 6)
                                     LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 61 AND sigparsed.languageid = 6)
                                     LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
                                     
                                                     LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = post.userid)
                                     WHERE post.postid IN (01096)
                                     ORDER BY post.dateline;
       
      MySQL Error   : Out of resources when opening file './site_vbd/editlog.MYD' (Errcode: 24)
    
      Error Number  : 23
      Request Date  : Wednesday, May 9th 2012 @ 02:05:29 PM
      Error Date    : Wednesday, May 9th 2012 @ 02:05:29 PM
      Script        : http://www.myforum.net/forum/f72/title3D/index3.html
    
      Referrer      : 
      IP Address    : 66.***.7*.231
    
      Username      : Non Registrato
      Classname     : vB_Database_MySQLi
      MySQL Version : 5.5.22-cll
    What is saying ?

  • #2
    "MySQL Error : Out of resources when opening file"

    You should speak to your host regarding this
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - Highlight the correct navigation tab when you are on a custom page
    - "Quick Route" Interface...
    - Allow to use custom icons for individual forums

    Comment


    • #3
      Hi, can you explain me wha is this?

      Comment


      • #4
        Originally posted by Sworm1 View Post
        Hi, can you explain me wha is this?
        Basically... you don't have what you need for this to run properly, more info here about this issue - http://dev.mysql.com/doc/refman/5.1/en/not-enough-file-handles.html

        Edit: I would also include the above link when contacting your host.


        Former vBulletin Support Staff
        Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
        Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!
        Need a Host? - I recommend URLJet

        Comment

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