Announcement

Collapse
No announcement yet.

Database error *.frm

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

  • Database error *.frm

    HI

    every 1 or 2 day my forums send email to me

    this is the error

    Database error in vBulletin 3.8.5:

    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(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid


    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 = 3 AND postparsed.languageid = 2)
    LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 3 AND sigparsed.languageid = 2)
    LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

    WHERE post.postid IN (0,712020,712067,732234,1079611,1079676)
    ORDER BY post.dateline;

    MySQL Error : Can't open file: './XXX_vb/avatar.frm' (errno: 24)
    Error Number : 1016
    Request Date : Monday, April 12th 2010 @ 04:10:56 AM
    Error Date : Monday, April 12th 2010 @ 04:14:08 AM
    Script : http://www.m7shsh.com/vb/46683.html
    Referrer : http://www.google.com.sa/search?hl=a...=&oq=&gs_rfai=
    IP Address : xxxxxx
    Username : xxxxx
    Classname : vB_Database
    MySQL Version :
    or
    MySQL Error : Can't open file: './XXX_vb/post.frm' (errno: 24)
    MySQL Error : Can't open file: './XXX_vb/sigpic.frm' (errno: 24)


    i did not know from what this problem

    can you help me

  • #2
    Try running repair/optimze on your avatar table until it says OK - maintenance > repair/optimize tables

    Although:
    error code 24: Too many open files
    You may have to talk to your host about this.

    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 vbulletin.org
    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

    Comment


    • #3
      thanks lynne for your reply

      i do the repair/optimze

      but seam problem

      and i have Dedicated server for my site is their any idea to sloved this problems by ssh or whm
      Originally posted by Lynne View Post
      Try running repair/optimze on your avatar table until it says OK - maintenance > repair/optimize tables

      Although:
      error code 24: Too many open files
      You may have to talk to your host about this.

      Comment

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