Announcement

Collapse
No announcement yet.

Database error after upgrade to 4.2.1

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

  • [Forum] Database error after upgrade to 4.2.1

    Hello,

    i have database error when opening any section of my forum, check please:

    http://www.imspot.org/seo-forum/

    How to fix this?

  • #2
    What is the error details ? if you log as administrator you can view it from
    Right click > View Source , Also the copy of database error details sent to your mail box

    Former vBulletin Support Staff
    Need Help?, Or P.M. Me

    Comment


    • #3
      This is the error:

      Database error in vBulletin 4.2.1:

      Invalid SQL:

      SELECT
      IF(votenum >= 1, votenum, 0) AS votenum,
      IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
      post.pagetext AS preview,
      thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
      thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
      thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount, user.userid,
      user.membergroupids, user.infractiongroupids, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
      user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible

      Comment


      • #4
        And this is what i got in email:
        [QUOTE]Database error in vBulletin 4.2.1:

        Invalid SQL:

        SELECT
        IF(votenum >= 1, votenum, 0) AS votenum,
        IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
        post.pagetext AS preview,
        thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
        thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
        thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount, user.userid,
        user.membergroupids, user.infractiongroupids, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
        user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible


        , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
        , threadread.readtime AS threadread
        , threadredirect.expires
        , user_starter.avatarrevision, NOT ISNULL(customavatar_dpta.userid) AS hascustomavatar, customavatar_dpta.dateline AS avatardateline, customavatar_dpta.width, customavatar_dpta.height , thread.bop_global
        FROM thread AS thread
        LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
        LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)

        LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')

        LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
        LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

        LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
        LEFT JOIN user AS user_starter ON (user_starter.userid = thread.postuserid) LEFT JOIN customavatar AS customavatar_dpta ON(customavatar_dpta.userid = user_starter.userid)
        WHERE thread.threadid IN (0,4,3443,3342,3413,3396,3441,2088,3436,2807,2513,3402,3438,3437,3414,3422,3432,3430,3434, 3401,3191

        Comment


        • #5
          Please disable all products and plugins first, then try again.
          No private support, only PM me when I ask for it. Support in the forums only.

          Comment


          • #6
            Yes its a plugin but which one?

            Comment


            • #7
              You would have to find out. Disable all of them, then enable one by one until you found the plugin which breaks the query.
              No private support, only PM me when I ask for it. Support in the forums only.

              Comment


              • #8
                Found it! Thanks for helping me

                Comment


                • #9
                  You're welcome.
                  No private support, only PM me when I ask for it. Support in the forums only.

                  Comment

                  Loading...
                  Working...
                  X