Announcement

Collapse
No announcement yet.

Please help with Upgrade

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

  • Please help with Upgrade

    Was doing newest upgrade and have run across a problem. Got this:

    Step 2) Import latest admin help
    Importing vbulletin-adminhelp.xml
    http://www.yourname.com/forums/image.php?type=dberror Database error

    Database error in vBulletin 3.6.6:

    Invalid SQL:

    INSERT INTO adminhelp
    (script, action, optionname, displayorder, volatile, product)
    VALUES

    ('index',
    'home',
    '',
    1,
    1,
    'vbulletin');

    MySQL Error : Duplicate entry 'index-home-' for key 2
    Error Number : 1062



    Can anyone help me please? I have never had a problem doing an upgrade before. Thanks
    Last edited by bluidkiti; Fri 11th May '07, 3:46pm.

  • #2
    I have this issue too. I put in a support ticket about 5 hours ago and nothing. Did you get it fixed?
    Thanks
    Lisa
    Lisa

    Comment


    • #3
      No, don't have it fixed yet and as you can see no one has replied to this.

      If you find out anything would you let me know please? Thanks.

      Comment


      • #4
        There might be a small delay in handling support tickets today, as we have a rush on the system since the release of 3.6.6.

        There have been a few tickets with the same symptoms as above, but until now there has not been a solution.

        I will post an update here when we have found a solution.
        Want to take your board beyond the standard vBulletin features?
        Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

        Comment


        • #5
          In the mean time while we are still looking into this issue, could you please post the following information if you encountered this problem:

          - The hosting company wher your board is running
          - The PHP and MySQL version
          Want to take your board beyond the standard vBulletin features?
          Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

          Comment


          • #6
            any help please to resolve this database error received while upgrading to vb3.6.6


            Step 1) Misc Table Alterations
            • Altering avatar Table (1 of 1)
            • Altering ranks Table (1 of 1)
            • Altering usertitle Table (1 of 1)
            • Altering calendar Table (1 of 1)
            • Altering forum Table (1 of 2)
            • Altering forum Table (2 of 2)
            • Altering datastore Table (1 of 1)
            • Creating userlist table
            • Creating profilefieldcategory table
            • Altering profilefield Table (1 of 2)
            • Altering profilefield Table (2 of 2)
            • Altering externalcache Table (1 of 2)
            • Altering externalcache Table (2 of 2)
            • Altering template Table (1 of 2)
            • Altering template Table (2 of 2)

            Database error in vBulletin 3.6.5:
            Invalid SQL:
            ALTER TABLE template ADD UNIQUE INDEX title (title,styleid,templatetype);
            MySQL Error : Duplicate entry 'header-94-template' for key 2
            Error Number : -1
            Date : Saturday, May 12th 2007 @ 10:27:29 PM
            Script : http://www.domain.com/forum/install/...366.php?step=1
            Referrer : http://www.domain.com/forum/install/...6.php?rand=559
            IP Address : xx.xx.xx.xxx
            Username :
            Classname : vb_database

            Comment


            • #7
              This is odd. I never had any problems upgrading. The only thing I did was overwrite all of the files then go to the install folder then install the thing. Try to turn your plugin system off before doing an upgrade.

              Comment


              • #8
                Thats Why i dont upgrade the same week of releasing the new versions,

                Comment


                • #9
                  Originally posted by grabacontroller View Post
                  This is odd. I never had any problems upgrading. The only thing I did was overwrite all of the files then go to the install folder then install the thing. Try to turn your plugin system off before doing an upgrade.

                  Thanks, but the upgrading was with plugins system turned off.

                  Comment


                  • #10
                    I had this same problem on a site, just changed the url from step=2 to step=3 and went on with the update like nothing happen.

                    cheers
                    -Brandon
                    -- Web Developer for hire
                    ---Online Marketing Tools and Articles

                    Comment


                    • #11
                      Problem solved and upgrade went fine by inserting the following in the second line of the config.php

                      Code:
                      define('DISABLE_HOOKS', true);
                      skipping any of the steps in the upgrade process is not recommended.
                      Last edited by pupil; Sun 13th May '07, 8:38am.

                      Comment


                      • #12
                        Had the same problem but, I forgot to update my config.php file with the database info...And then the upgrade went fine..

                        Comment

                        Loading...
                        Working...
                        X