3.5.3 to 3.6.4 problem please help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mojahudba
    Member
    • Oct 2005
    • 32
    • 3.6.x

    3.5.3 to 3.6.4 problem please help

    i did upgrade like in manual but when i run upgrade script i get this error

    Code:
     
    Database error in vBulletin 3.6.0 Beta 1:
    Invalid SQL:
    ALTER TABLE adminlog ADD  INDEX script_action (script,action);
    MySQL Error  : Key column 'script' doesn't exist in table
    Error Number : -1
    Date         : Wednesday, November 29th 2006 @ 07:14:57 PM
    Script       : [URL]http://www.mojahudba.com/forums/install/upgrade_360b2.php?step=1[/URL]
    Referrer     : [URL]http://www.mojahudba.com/forums/install/upgrade_360b2.php[/URL]
    IP Address   : xxxxxxxx
    Username     : 
    Classname    : vb_database

    can anyone help me whats is wrong ?
  • mojahudba
    Member
    • Oct 2005
    • 32
    • 3.6.x

    #2
    Code:
     
    Database error in vBulletin 3.6.4:
    Invalid SQL:
     SELECT adminmessage.adminmessageid
     FROM adminmessage AS adminmessage
     INNER JOIN adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
     WHERE adminmessage.status = 'undone'
      AND adminmessage.script <> ''
      AND adminlog.dateline > adminmessage.dateline
     GROUP BY adminmessage.adminmessageid;
    MySQL Error  : Unknown column 'adminlog.dateline' in 'where clause'
    Error Number : 1054
    Date         : Wednesday, November 29th 2006 @ 07:20:49 PM
    Script       : [URL]http://www.mojahudba.com/forums/admincp/index.php?do=home[/URL]
    Referrer     : [URL]http://www.mojahudba.com/forums/admincp/index.php[/URL]
    IP Address   : xxxxxxxxx
    Username     : Jeinko©
    Classname    : vb_database

    Comment

    • Steve Machol
      Former Customer Support Manager
      • Jul 2000
      • 154488

      #3
      It looks like you skipped one or more upgrade steps. Run this query to add that column:

      ALTER TABLE adminlog ADD dateline INT UNSIGNED NOT NULL DEFAULT '0'

      or possibly this:

      ALTER TABLE adminmessage ADD dateline INT UNSIGNED NOT NULL DEFAULT '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

      • mojahudba
        Member
        • Oct 2005
        • 32
        • 3.6.x

        #4
        thanks even dont know what u mean also editing for posts dont work anymore

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #5
          You can run those queries in the SQL tab in phpMyAdmin, Or to run queries from the Admin CP:

          Admin CP -> Maintenance -> Execute SQL Query -> Manual Query

          Then enter your query in the Manual Query box and click on 'Continue'.

          To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

          // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
          // The users specified here will be allowed to run queries from the control panel.
          // See the above entries for more information on the format.
          // Please note that the ability to run queries is quite powerful. You may wish
          // to remove all user IDs from this list for security reasons.
          $canrunqueries = 'x';

          ...with x being your userid number.
          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

          • mojahudba
            Member
            • Oct 2005
            • 32
            • 3.6.x

            #6
            An error occurred while attempting to execute your query. The following information was returned.
            error number: 1060
            error desc: Duplicate column name 'dateline'

            Comment

            • Steve Machol
              Former Customer Support Manager
              • Jul 2000
              • 154488

              #7
              Then do the other query.
              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

              • mojahudba
                Member
                • Oct 2005
                • 32
                • 3.6.x

                #8
                well that first works

                but its still didnt remove this :
                Code:
                 
                Database error in vBulletin 3.6.4:
                Invalid SQL:
                 SELECT adminmessage.adminmessageid
                 FROM adminmessage AS adminmessage
                 INNER JOIN adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
                 WHERE adminmessage.status = 'undone'
                  AND adminmessage.script <> ''
                  AND adminlog.dateline > adminmessage.dateline
                 GROUP BY adminmessage.adminmessageid;
                MySQL Error  : Unknown column 'adminlog.script' in 'on clause'
                Error Number : 1054
                Date         : Wednesday, November 29th 2006 @ 08:34:14 PM
                Script       : [URL]http://www.mojahudba.com/forums/admincp/index.php?do=home[/URL]
                Referrer     : [URL]http://www.mojahudba.com/forums/admincp/index.php[/URL]
                IP Address   : xxxxxxxx
                Username     : Jeinko©
                Classname    : vb_database

                canu help me with this error as well please ?

                Comment

                • Steve Machol
                  Former Customer Support Manager
                  • Jul 2000
                  • 154488

                  #9
                  Run this query:

                  ALTER TABLE adminmessage ADD script varchar(50) NOT NULL DEFAULT ''
                  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

                  • mojahudba
                    Member
                    • Oct 2005
                    • 32
                    • 3.6.x

                    #10
                    An error occurred while attempting to execute your query. The following information was returned.
                    error number: 1064
                    error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1


                    Comment

                    • Steve Machol
                      Former Customer Support Manager
                      • Jul 2000
                      • 154488

                      #11
                      You are using a double-quote instead of 2 single quotes. Make sure you copy-n-paste that query exactly as I wrote it.
                      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

                      • mojahudba
                        Member
                        • Oct 2005
                        • 32
                        • 3.6.x

                        #12
                        i did but nothing change

                        Comment

                        • Steve Machol
                          Former Customer Support Manager
                          • Jul 2000
                          • 154488

                          #13
                          Hmmm...there is nothing wronfg with that query I posted. I tested this out and it worked fine for me. Not sure why you are having this problem.

                          Try copy-n-pasting it again.
                          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

                          • mojahudba
                            Member
                            • Oct 2005
                            • 32
                            • 3.6.x

                            #14
                            well i tryed at least 20 times and nothin works is there anything else what can i do ?

                            Comment

                            • Steve Machol
                              Former Customer Support Manager
                              • Jul 2000
                              • 154488

                              #15
                              Fill out a support ticket at:



                              Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.
                              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...