Announcement

Collapse
No announcement yet.

Mysql eror!

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

  • Mysql eror!

    so confusing! what can cause this?
    I get this when I try to view threads:

    Code:
    Database error in vBulletin 3.6.8:
    
    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 = 21 AND postparsed.languageid = 2)
    		LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 21 AND sigparsed.languageid = 2)
    		LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
    			
    		WHERE post.postid IN (0,15671,15696,15700,15726,15727,15728)
    		ORDER BY post.dateline;
    
    MySQL Error  : Can't open file: 'postparsed.MYI'. (errno: 145)
    Error Number : 1016
    Date         : Tuesday, September 4th 2007 @ 10:50:01 AM
    Script       : http://balhbalh/showthread.php?p=15728
    Referrer     : http://blahblah/
    IP Address   : 89.***.***.***
    Username     : kaambiz
    Classname    : vB_Database

  • #2
    MySQL error: 145 = Table was marked as crashed and should be repaired

    This error means that table has crashed. To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot open your Admin CP then you can repair tables with phpMyAdmin.
    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


    • #3
      Originally posted by Steve Machol View Post
      MySQL error: 145 = Table was marked as crashed and should be repaired

      This error means that table has crashed. To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

      Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue

      If you cannot open your Admin CP then you can repair tables with phpMyAdmin.
      Thanks a lot Steve.

      Comment

      Loading...
      Working...
      X