Announcement

Collapse
No announcement yet.

Database Problems ?

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

  • Database Problems ?

    hi,
    DB giving this error now:


    Code:
     
    Database error in vBulletin 3.6.2:
    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,
    deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
    editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
    editlog.reason AS edit_reason,
    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 deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
    LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
    LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 56 AND postparsed.languageid = 2)
    LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 56 AND sigparsed.languageid = 2)
    LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
     
    WHERE post.postid IN (0,378403,378404,378405,378406,378407,378408,378409,378410,378411,378603)
    ORDER BY post.dateline;
     
    MySQL Error : File './vbb/sigparsed.MYD' not found (Errcode: 13)
    Error Number : 1105
    Date : Friday, April 27th 2007 @ 06:58:19 PM
    Script : [URL="https://www.vbulletin.com/link.php?u=http%3A%2F%2Fwww.maxicep.com%2Fforums%2Fshowthread.php%3Ft%3D34136"]http://www.maxicep.com/forums/showthread.php?t=34136[/URL]
    Referrer : [URL="https://www.vbulletin.com/link.php?u=http%3A%2F%2Fwww.maxicep.com%2Fforums%2Fhome.php"]http://www.maxicep.com/forums/home.php[/URL]
    Classname : vb_database

  • #2
    This error means:

    System error: 13 = Permission denied

    That file either does not exist, or it does not have the appropriate permissions. You will need to ask your host to check this database file for you.

    Note: This is a known problem with MySQL version 4.1.21. If your host is running that version then
    ask them to upgrade.
    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.


    Comment

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