Announcement

Collapse
No announcement yet.

after upgrade 3.6.2 when click forumdisplay get this error

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

  • after upgrade 3.6.2 when click forumdisplay get this error

    hi all

    after upgrade need help please when click forumdisplay get this error :

    Database error in vBulletin 3.6.2:
    Invalid SQL:
    SELECT
    IF(votenum >= 1, votenum, 0) AS votenum,
    IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,

    thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
    thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
    hiddencount, deletedcount
    , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
    , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

    , threadredirect.expires

    FROM thread AS thread
    LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
    LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)



    LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)

    WHERE thread.threadid IN (0,28424,28409,28338,28384,28376,28391,28362,28060,26234,28232,28294,27895,28043,28368,283 51,28148,28274,28315,25863,28269,14366,14819,21175)
    ORDER BY sticky DESC, lastpost DESC;
    MySQL Error : Unknown column 'hiddencount' in 'field list'
    Error Number : 1054
    Date : Friday, November 3rd 2006 @ 01:19:04 PM

  • #2
    This is very likely caused by a modification you have installed.

    To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
    Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

    define('DISABLE_HOOKS', true);

    If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

    Comment


    • #3
      we but
      define('DISABLE_HOOKS', true);
      in config file and reubload all in ASCII format still this error

      MySQL Error : Unknown column 'hiddencount' in 'field list'
      Error Number : 1054

      Comment


      • #4
        also when click to any user get this error

        Database error in vBulletin 3.6.2:
        Invalid SQL:
        SELECT
        userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight

        FROM user AS user
        LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
        LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN sigpic AS sigpic ON (user.userid = sigpic.userid)

        WHERE user.userid = 14015;
        MySQL Error : Unknown column 'customavatar.width' in 'field list'
        Error Number : 1054

        Comment


        • #5
          Did you receive any errors during upgrade.php?
          Want to take your board beyond the standard vBulletin features?
          Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

          Comment


          • #6
            no

            i but install.php + init.php to upgrade again and go to

            http://www/myforum.com/install/upgrade.php i get blank page ?

            hope fix that problem and i dont have any backup

            Comment


            • #7
              also go to maintenanse to
              Rebuild Thread Information

              i get this error also :

              Database error in vBulletin 3.6.2:
              Invalid SQL:
              UPDATE thread SET
              firstpostid = 4,
              postuserid = 2,
              postusername = 'ÃÈæ ÚÈÏÇáÑÍãä',
              lastpost = 988628802,
              replycount = 0,
              hiddencount = 0,
              deletedcount = 0,
              attach = 0,
              dateline = 988628802,
              lastposter = 'ÃÈæ ÚÈÏÇáÑÍãä',
              lastpostid = 4,
              votenum = 0,
              votetotal = 0
              WHERE threadid = 4;
              MySQL Error : Unknown column 'hiddencount' in 'field list'
              Error Number : 1054

              Comment


              • #8
                To troubleshoot this, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

                Ones all files have been reuploaded, try to run install/upgrade.php again.
                Want to take your board beyond the standard vBulletin features?
                Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

                Comment


                • #9
                  This error is caused by a modification, follow the instructions Marco gave you in his first post.
                  Best Regards
                  Colin Frei

                  Please don't contact me per PM.

                  Comment


                  • #10
                    Originally posted by Colin F View Post
                    This error is caused by a modification, follow the instructions Marco gave you in his first post.

                    thank you for replay

                    but how we do that and where ?

                    Comment


                    • #11
                      With which step are you having problems?
                      Best Regards
                      Colin Frei

                      Please don't contact me per PM.

                      Comment


                      • #12
                        not for step all forum

                        when click to any forum i get this error

                        Database error in vBulletin 3.6.2:
                        Invalid SQL:
                        SELECT
                        IF(votenum >= 1, votenum, 0) AS votenum,
                        IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,

                        thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
                        thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
                        hiddencount, deletedcount
                        , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
                        , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

                        , threadredirect.expires

                        FROM thread AS thread
                        LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
                        LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)



                        LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)

                        WHERE thread.threadid IN (0,22438,22341)
                        ORDER BY sticky DESC, lastpost DESC;
                        MySQL Error : Unknown column 'hiddencount' in 'field list'
                        Error Number : 1054


                        also when i click to any user i get this error :

                        Database error in vBulletin 3.6.2:
                        Invalid SQL:
                        SELECT
                        userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight

                        FROM user AS user
                        LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
                        LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN sigpic AS sigpic ON (user.userid = sigpic.userid)

                        WHERE user.userid = 1;
                        MySQL Error : Unknown column 'customavatar.width' in 'field list'
                        Error Number : 1054

                        when i Rebuild Thread Information

                        i get this error also :

                        Database error in vBulletin 3.6.2:
                        Invalid SQL:
                        UPDATE thread SET
                        firstpostid = 4,
                        postuserid = 2,
                        postusername = 'ÃÈæ ÚÈÏÇáÑÍãä',
                        lastpost = 988628802,
                        replycount = 0,
                        hiddencount = 0,
                        deletedcount = 0,
                        attach = 0,
                        dateline = 988628802,
                        lastposter = 'ÃÈæ ÚÈÏÇáÑÍãä',
                        lastpostid = 4,
                        votenum = 0,
                        votetotal = 0
                        WHERE threadid = 4;
                        MySQL Error : Unknown column 'hiddencount' in 'field list'
                        Error Number : 1054

                        Comment


                        • #13
                          What is the version you upgraded from?
                          Want to take your board beyond the standard vBulletin features?
                          Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

                          Comment


                          • #14
                            from 3.0.3

                            Comment


                            • #15
                              Did you follow my instruction in post http://www.vbulletin.com/forum/showp...85&postcount=8

                              And what was the result of that?
                              Want to take your board beyond the standard vBulletin features?
                              Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

                              Comment

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