Announcement

Collapse
No announcement yet.

Database Error

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

  • Database Error

    I was on my forum on day and i tried installing Zenith Picture Gallery and it just said database error

    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,
       level,
       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 reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
       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,5360,5362,5367,5370,5376,5379,5382,5398,5400,5402)
      ORDER BY post.dateline;
    MySQL Error  : Table 'jet.post_parsed' doesn't exist
    Error Number : 1146
    Date         : Friday, November 10th 2006 @ 09:22:26 AM
    Script       : http://jet.addr.com/Forum/showthread.php?p=5382
    Referrer     : http://jet.addr.com/Forum/index.php
    IP Address   : 72.73.40.252
    Username     : Taylor 21
    Classname    : vB_Database
    and idk wat to do does anyone this they have the knowledge to fix this or wat i should do

  • #2
    The post_parsed table has been renamed to postparsed in vBulletin 3.6. I would suggest this addon was written for an older version.
    Lats...

    Comment


    • #3
      oh alright thanks i will try to fix it and if i can't then idk

      Comment


      • #4
        Chances are if you're installing a hack for the wrong version of vB, you're just going to run into more problems. There are a lot of galleries out there for 3.6, have a look at vbulletin.org.

        Comment

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