Step 6 Upgrade problem from beta 4 to 5

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dSpots
    New Member
    • Dec 2002
    • 18

    Step 6 Upgrade problem from beta 4 to 5

    I was trying to upgrade from beta 4 to beta 5 and was on step 6 of the upgrade when it froze. When I refreshed it, it gave the following message:
    --------------------
    Database error in vBulletin 3.0.0 Beta 4:

    Invalid SQL: UPDATE template SET styleid = -10 WHERE styleid = -1
    mysql error: Duplicate entry '.alt1, .alt1Active--10' for key 2

    mysql error number: 1062

    Date: Friday 08th of August 2003 03:14:53 PM
    Script: http://www.dspotter.com/bavspeed/ins...de3.php?step=6
    Referer: http://www.dspotter.com/bavspeed/ins...de3.php?step=5

    ---------------------

    How do I go about to continue this upgrade?

    Thanks,

    Derrick
  • Mike Sullivan
    Former vBulletin Developer
    • Apr 2000
    • 13327
    • 3.6.x

    #2
    Backup your template table (at least), then run this query:

    DELETE FROM template WHERE styleid = -10;

    Now retry the upgrade.

    Comment

    • dSpots
      New Member
      • Dec 2002
      • 18

      #3
      Originally posted by Mike Sullivan
      Backup your template table (at least), then run this query:

      DELETE FROM template WHERE styleid = -10;

      Now retry the upgrade.
      Thanks, I don't get that error message anymore and it went straight to step 6 when I retried it.

      Is step 6 supposed to take a long time? It's been an hour already...hopefully it won't freeze again.


      Derrick Lane

      Comment

      • Mike Sullivan
        Former vBulletin Developer
        • Apr 2000
        • 13327
        • 3.6.x

        #4
        I would say that step 6 normally shouldn't take more than 10 seconds. Do you have a lot of templates?

        Comment

        • dSpots
          New Member
          • Dec 2002
          • 18

          #5
          Originally posted by Mike Sullivan
          I would say that step 6 normally shouldn't take more than 10 seconds. Do you have a lot of templates?
          Oh ok I see, I have some templates.

          Since I'm upgrading only a test forum for right now, just going to do a fresh install. Should hopefully be easier.

          Thanks for your help!

          Derrick

          Comment

          Related Topics

          Collapse

          Working...