Announcement

Collapse
No announcement yet.

3.5.3 to 3.6.4 problem please help

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

  • 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       : http://www.mojahudba.com/forums/inst...0b2.php?step=1
    Referrer     : http://www.mojahudba.com/forums/inst...rade_360b2.php
    IP Address   : xxxxxxxx
    Username     : 
    Classname    : vb_database

    can anyone help me whats is wrong ?

  • #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       : http://www.mojahudba.com/forums/admi...ex.php?do=home
    Referrer     : http://www.mojahudba.com/forums/admincp/index.php
    IP Address   : xxxxxxxxx
    Username     : JeinkoŠ
    Classname    : vb_database

    Comment


    • #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


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

        Comment


        • #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


          • #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


            • #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


              • #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       : http://www.mojahudba.com/forums/admi...ex.php?do=home
                Referrer     : http://www.mojahudba.com/forums/admincp/index.php
                IP Address   : xxxxxxxx
                Username     : JeinkoŠ
                Classname    : vb_database

                canu help me with this error as well please ?

                Comment


                • #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


                  • #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


                    • #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


                      • #12
                        i did but nothing change

                        Comment


                        • #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


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

                            Comment


                            • #15
                              Fill out a support ticket at:

                              http://members.vbulletin.com/members...ontactform.php

                              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...
                              X