Announcement

Collapse
No announcement yet.

3.0.2 Upgrade Datbase Error

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

  • 3.0.2 Upgrade Datbase Error

    Hi all,

    I was upgrading my board to 3.0.2 today (from 3.0.0-->3.0.1-->3.0.2) and during step 4 (miscellaneous table alterations 4/4)
    I received a database error:

    Adding notes field to administrator
    Adding cpsession table
    Altering thread Table (1 of 1)

    Database error in vBulletin 3.0.1:
    Invalid SQL: ALTER TABLE thread ADD INDEX pollid (pollid)
    mysql error: Duplicate key name 'pollid'
    mysql error number: 1061
    Would I just remove "pollid" from teh current dB, and run the script again?

    (And no, I don't have a poll hack or anything like that installed)

    TIA
    Last edited by Vile; Fri 2nd Jul '04, 12:11pm.
    Webmaster / Administrator
    www.MegaGames.com
    www.MGForums.com

  • #2
    I am stuck at this one as well.

    Comment


    • #3
      If you have a pollid index on the thread table then you must have manually added it to your database at some point.

      Yes you can remove the pollid index via phpMyAdmin and then run the upgrade.

      Comment


      • #4
        Yes you can remove the pollid index via phpMyAdmin and then run the upgrade
        i have removed pollid in thred table but now

        Database error in vBulletin 3.0.1:

        Invalid SQL: ALTER TABLE thread ADD INDEX pollid (pollid)
        mysql error: Key column 'pollid' doesn't exist in table

        mysql error number: 1072

        Comment


        • #5
          I would guess you removed the pollid column and not the index, which means you have now lost all polls unless you restore a backup.

          Comment


          • #6
            okays i have restored thread table

            after run

            ALTER TABLE "thread" DROP index "pollid"

            now, work fine

            regards

            Comment


            • #7
              Same error me

              Adding notes field to administrator
              Adding cpsession table
              Altering thread Table (1 of 1)

              Database error in vBulletin 3.0.1:
              Invalid SQL: ALTER TABLE thread ADD INDEX pollid (pollid)
              mysql error: Duplicate key name 'pollid'
              mysql error number: 1061


              What is the sql query this problem ?

              Comment


              • #8
                Your problem is you have run the upgrade script multiple times. You've probably added multiple copies of the same indices also. At this point I think you should submit a support ticket with phpMyAdmin access so someone can check your database against each step of the upgrade.

                Comment


                • #9
                  Originally posted by Freddie Bingham
                  I would guess you removed the pollid column and not the index, which means you have now lost all polls unless you restore a backup.
                  So exactly how should this be done? (I'm assuming it's with PHPMyAdmin, but what's the actual process to remove the pollid index)

                  Thanks.
                  Webmaster / Administrator
                  www.MegaGames.com
                  www.MGForums.com

                  Comment


                  • #10
                    You can run this query

                    ALTER TABLE thread DROP INDEX pollid

                    Comment


                    • #11
                      Originally posted by Freddie Bingham
                      You can run this query

                      ALTER TABLE thread DROP INDEX pollid
                      Thanks.

                      After running this query, I got the following error though:

                      Database error in vBulletin 3.0.1:
                      Invalid SQL: ALTER TABLE administrator ADD notes MEDIUMTEXT NOT NULL
                      mysql error: Duplicate column name 'notes'
                      *edit.

                      Ok, dropped the notes column, reusmed upgrade, and works fine

                      Thanks all.
                      Last edited by Vile; Fri 2nd Jul '04, 7:12pm.
                      Webmaster / Administrator
                      www.MegaGames.com
                      www.MGForums.com

                      Comment


                      • #12
                        did'nt work for me...looking aorund forums now for an answer

                        -M

                        Comment


                        • #13
                          What didn't work for you? I suggest you start a new thread with all the relevant details.
                          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
                            I had the same problem...in that section I had the same errors, and each time I removed the proper thing, and hit refresh, it would stall again..and of course I had to start over from the beginning..its a pain, but it will work....with your first error, remove the key or index in question. then hit refresh, now you have your second error, remove that..BUT, also remove the first error again..because its been readded. Now hit refresh and you get your third error...do the same as before, remove first, second and now third error. Eventually you will get it to move ahead. Tiresome, but not impossible.

                            Comment


                            • #15
                              Originally posted by paolorulez
                              ALTER TABLE "thread" DROP index "pollid"
                              now, work fine
                              Seems like many people have pollid index in thread. I dont remember adding this index at some point, but some hack may did it

                              should there be something to check if some id already exists, then drop and rebuild it?

                              Comment

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