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

  • #16
    we do that but now in install/upgrade.php i get blank page .

    Comment


    • #17
      If everything was uploaded correct, then you should not get a blank page. Please verify all is uploaded correctly.

      If that doesn't help, please open a support ticket with all relevant details.
      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


      • #18
        now is open install page from where i beging ?

        re install only upgrade.php or upgrade_303.php ?

        Comment


        • #19
          After the first time you should never need to run install.php again.

          Also you only need to run upgrade.php, you never run any of the other upgrade scripts directly.
          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


          • #20
            also same promlem

            when i click to any forum i get

            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,28419,27968,26624,21562,23340,27345,26669,28032,22729,19065,28339,28278,28030,12804,281 14,25274,25275,28150,28149,27894,14374,20302)
            ORDER BY sticky DESC, lastpost DESC;
            MySQL Error : Unknown column 'hiddencount' in 'field list'
            Error Number : 1054
            Last edited by Q8vbhacks; Wed 8 Nov '06, 2:43am.

            Comment


            • #21
              Did you run upgrade.php again, and did you get any messages while running it?
              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


              • #22
                only i get above message and when i click to any user i get :
                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


                • #23
                  Originally posted by Marco van Herwaarden View Post
                  Did you run upgrade.php again, and did you get any messages while running it?

                  yes and i did not get any error mesaages in 3.6.2 upgrade .

                  thanks

                  Comment


                  • #24
                    Seems you have missed one or more upgrade steps. Try running the following query:

                    Code:
                    ALTER TABLE customavatar ADD COLUMN `width` smallint(5) unsigned NOT NULL default '0';
                    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


                    • #25
                      Originally posted by Marco van Herwaarden View Post
                      Seems you have missed one or more upgrade steps. Try running the following query:

                      Code:
                      ALTER TABLE customavatar ADD COLUMN `width` smallint(5) unsigned NOT NULL default '0';

                      thanks now this error :

                      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,
                      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 = 1 AND postparsed.languageid = 2)
                      LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 2)
                      LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

                      WHERE post.postid IN (0,159420,159423,165821,165949,168089,168156)
                      ORDER BY post.dateline;
                      MySQL Error : Unknown column 'customavatar.height' in 'field list'
                      Error Number : 1054
                      Date : Tuesday, November 14th 2006 @ 10:43:03 AM

                      Comment


                      • #26
                        also when click to any user this error :

                        Unknown column 'customprofilepic.width' in 'field list'

                        Comment


                        • #27
                          now everthing ok but in admincp when click to edit user i get this error :

                          Database error in vBulletin 3.6.3:
                          Invalid SQL:
                          SELECT * FROM subscription ORDER BY displayorder;
                          MySQL Error : Unknown column 'displayorder' in 'order clause'
                          Error Number : 1054
                          Date : Tuesday, November 14th 2006 @ 11:54:47 AM

                          Comment


                          • #28
                            Run the following query:
                            Code:
                            ALTER TABLE subscription ADD COLUMN `displayorder` smallint(5) unsigned NOT NULL default '1';
                            And you will probably run into an error about a missing adminoptions column. If that happens, also run the following:
                            Code:
                            ALTER TABLE subscription ADD COLUMN `adminoptions` int(10) unsigned NOT NULL default '0';
                            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


                            • #29
                              thank u very much now all is ok great support

                              Comment

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