Announcement

Collapse
No announcement yet.

3.5.4 to 3.6, post error

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

  • 3.5.4 to 3.6, post error

    I recieve this error when I try to view posts:

    Please help!

    Database error in vBulletin 3.6.0:

    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,
    post_parsed.pagetext_html, post_parsed.hasimages,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid


    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 type = 'post')
    LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
    LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)

    WHERE post.postid IN (0,2529)
    ORDER BY post.dateline;

    MySQL Error : Table 'sfftnet_vb.post_parsed' doesn't exist
    Error Number : 1146
    Date : Saturday, August 12th 2006 @ 03:40:37 PM
    Script : http://sfftnet.com/forums/showthread.php?t=330
    Referrer : http://sfftnet.com/forums/forumdisplay.php?f=9
    IP Address : *******
    Username : Brandon
    Classname : vB_Database
    I have run repair/optimize tables a few times, nothing.
    Last edited by bld444; Sat 12 Aug '06, 11:45am.

  • #2
    To fix this reupload the original vB 3.6.0 files. That table is renamed to 'postparsed' in 3.6.0.
    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
      Fixed. Thank you!

      Comment


      • #4
        I have the same issue...

        I have upgraded from 3.5.3 to 3.6.0, and I have the table postparsed, and not post_parsed. So I get this error when I click on a post:

        Code:
        Database error in vBulletin 3.6.0:
        
        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,
        			post_parsed.pagetext_html, post_parsed.hasimages,
        			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
        			
        			
        		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 type = 'post')
        		LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
        		LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)
        			
        		WHERE post.postid IN (0,14303,14343,14341,14344,14345)
        		ORDER BY post.dateline;
        
        MySQL Error  : Table 'blackholedb.post_parsed' doesn't exist
        Error Number : 1146
        Date         : Monday, August 28th 2006 @ 11:04:38 AM
        Script       : http://www.theblackhole.us/forum/showthread.php?p=14345
        Referrer     : http://www.theblackhole.us/forum/index.php
        IP Address   : 24.98.89.233
        Username     : Optical Serenity
        Classname    : vb_database

        Comment


        • #5
          Recontech, please start your own thread with all the relevant details. Thank you.
          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