Announcement

Collapse
No announcement yet.

Beta 7 to gamma...DB error on step 2

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

  • Beta 7 to gamma...DB error on step 2

    Hi guys, trying to upgrade from VB3 Beta 7 to VB3 gamma. Keep getting this error on step 2 though. I ran the table repair in the AdminCP and it said all was fine. Any ideas??
    thanks


    *Dropping index on template table


    There seems to have been a slight problem with the Wrangler-Forums.net Bulletin Board database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.

  • #2
    I got the same error

    Comment


    • #3
      Same here
      Rack Blast - Web hosting that is So fast, its a blast!

      Comment


      • #4
        glad I'm not the only one lol

        Comment


        • #5
          Actually, here is the db error I am getting:

          Database error in vBulletin 3.0.0 Beta 7:

          Invalid SQL: ALTER TABLE template ADD UNIQUE title (title, styleid)
          mysql error: Duplicate entry 'header-1' for key 2
          mysql error number: 1062
          Rack Blast - Web hosting that is So fast, its a blast!

          Comment


          • #6
            Interesting, now I'm getting this error on step 1
            Database error in vBulletin 3.0.0 Beta 7:

            Invalid SQL: ALTER TABLE template DROP INDEX title
            mysql error: Can't DROP 'title'. Check that column/key exists

            mysql error number: 1091

            Date: Friday 05th of December 2003 12:00:47 AM

            Comment


            • #7
              go through phpMyAdmin and add "title" as an index, then rerun the upgrade
              ManagerJosh, Owner of 4 XenForo Licenses, 1 vBulletin Legacy License, 1 Internet Brands Suite License
              Director, WorldSims.org | Gaming Hosting Administrator, SimGames.net, Urban Online Entertainment

              Comment


              • #8
                Originally posted by ManagerJosh
                go through phpMyAdmin and add "title" as an index, then rerun the upgrade
                Right, I did that and now get
                Database error in vBulletin 3.0.0 Beta 7:

                Invalid SQL: ALTER TABLE template ADD UNIQUE title (title, styleid)
                mysql error: Duplicate entry 'footer-1' for key 2

                mysql error number: 1062

                Date: Friday 05th of December 2003 12:55:04 AM

                Comment


                • #9
                  See Mike Sullivan's post in the Announcement Forum.

                  ManagerJosh, Owner of 4 XenForo Licenses, 1 vBulletin Legacy License, 1 Internet Brands Suite License
                  Director, WorldSims.org | Gaming Hosting Administrator, SimGames.net, Urban Online Entertainment

                  Comment


                  • #10
                    Originally posted by ManagerJosh
                    See Mike Sullivan's post in the Announcement Forum.

                    Yea I did, I just wanted to answer your response

                    Can't wait to get the "fixed" script

                    Comment


                    • #11
                      Fixed scripts are available in that thread now. Let me know how they work for you.

                      Comment


                      • #12
                        New Files: http://www.vbulletin.com/forum/showp...18&postcount=5
                        ManagerJosh, Owner of 4 XenForo Licenses, 1 vBulletin Legacy License, 1 Internet Brands Suite License
                        Director, WorldSims.org | Gaming Hosting Administrator, SimGames.net, Urban Online Entertainment

                        Comment


                        • #13
                          excellent, your the man Mike. About to try the fix right now

                          Comment


                          • #14
                            wooooohoooooo
                            Great job!
                            Works like a charm!!!
                            Even my styles/hacks are working like normal.

                            Keep up the great work guys

                            Comment


                            • #15
                              Good to hear! Have fun! (Thanks for the help too, BTW.)

                              Comment

                              Related Topics

                              Collapse

                              Working...
                              X