Error upgrading from 26 to 27

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kingcruisers
    New Member
    • Jan 2013
    • 29
    • 4.2.X

    Error upgrading from 26 to 27

    I am getting the following error when attempting to upgrade from 26 to 27. This error happens after entering customer number at upgrade.php.
    Upgrade Progress
    • Upgrading to 5.0.0 Beta 27
    • Step 1 - Mapping customized stylevars to new stylevars
    • Step 2 - Altering video Table (1 of 3)
    • Altering video Table (2 of 3)
    • Altering video Table (3 of 3)
    • Step 3 - Altering permission Table (1 of 1)
    • Altering messagefolder Table (1 of 1)
    • An error has occurred with your database. Please contact vBulletin Support for assistance.
      Module: 500b27, Step 4 Database Error:-1
      Specified key was too long; max key length is 767 bytes
      Query:

      ### vBulletin Database Alter ### ALTER TABLE messagefolder ADD UNIQUE INDEX userid_title_titlephrase (userid,title,titlephrase)

  • DivisionByZero
    Member
    • Jan 2003
    • 81
    • 4.2.x

    #2
    same here... it's an innodb thing, nothing to do really but reduce the size of the column.
    Last edited by DivisionByZero; Tue 29 Jan '13, 4:48pm.

    Comment

    • kingcruisers
      New Member
      • Jan 2013
      • 29
      • 4.2.X

      #3
      So at first I thought it could be the user titles being too long. I went through and shortened them all but that didn't work. Any suggestions?

      Comment

      • DivisionByZero
        Member
        • Jan 2003
        • 81
        • 4.2.x

        #4
        im looking through the install files now, i'll post or PM you a fix

        Comment

        • kingcruisers
          New Member
          • Jan 2013
          • 29
          • 4.2.X

          #5
          Is reducing the column size the solution that worked for you? If so, how is that done?

          Comment

          • DivisionByZero
            Member
            • Jan 2003
            • 81
            • 4.2.x

            #6
            the code is fine, its the size of the columns, which are WAY too big. in the table messagefolder, change title and titlephrase to varchar(60) and rerun the installer. that should do it. There's no WAY those columns need to be that big!

            do you have PHPmyADMIN access? that's the best way? if not, i can walk you through doing it on the shell if you have SSH access. you COULD have done it in your admnicp, but i'm guessing your install is still broken

            Comment

            • kingcruisers
              New Member
              • Jan 2013
              • 29
              • 4.2.X

              #7
              Fixed that...thanks for the instructions, however I got this error:
              Action Required
              Unexpected Text:
              <?xml version="1.0" encoding="windows-1252"?>Specified key was too long; max key length is 767 bytes

              Comment

              • DivisionByZero
                Member
                • Jan 2003
                • 81
                • 4.2.x

                #8
                how did you upload the files to the server? did you unzip it on the server, or upload them individually?

                Comment

                • kingcruisers
                  New Member
                  • Jan 2013
                  • 29
                  • 4.2.X

                  #9
                  unzipped locally and uploaded per instructions

                  Comment

                  • DivisionByZero
                    Member
                    • Jan 2003
                    • 81
                    • 4.2.x

                    #10
                    hmmmmmm

                    Comment

                    • kingcruisers
                      New Member
                      • Jan 2013
                      • 29
                      • 4.2.X

                      #11
                      I am having no luck with this upgrade to 27. I have tried many of the suggestions found on various threads with similar issues and still no luck.

                      Comment

                      • kleinergeist191
                        New Member
                        • Feb 2007
                        • 2

                        #12
                        same at me:

                        • Upgrading to 5.0.0 Beta 27
                        • Step 4 - Altering messagefolder Table (1 of 1)
                        • An error has occurred with your database. Please contact vBulletin Support for assistance.
                          Module: 500b27, Step 4 Database Error:-1
                          Specified key was too long; max key length is 767 bytes
                          Query:

                          ### vBulletin Database Alter ### ALTER TABLE messagefolder ADD UNIQUE INDEX userid_title_titlephrase (userid,title,titlephrase)

                        Comment

                        • BulliM
                          Senior Member
                          • Oct 2012
                          • 497

                          #13
                          I have the same error! Difference is 1000 instead of 767 bytes.

                          An error has occurred with your database. Please contact vBulletin Support for assistance.
                          Module: 500b27, Step 4 Database Error:-1
                          Specified key was too long; max key length is 1000 bytes
                          Query:

                          ### vBulletin Database Alter ### ALTER TABLE messagefolder ADD UNIQUE INDEX userid_title_titlephrase (userid,title,titlephrase)
                          Last edited by BulliM; Tue 29 Jan '13, 11:07pm.

                          Comment

                          • beishe8
                            Senior Member
                            • Oct 2005
                            • 6782
                            • 4.2.X

                            #14
                            Action Required
                            An error has occurred with your database. Please contact vBulletin Support for assistance.
                            Module: 500b27, Step 4 Database Error:-1
                            Specified key was too long; max key length is 1000 bytes


                            vB5 is unequivocally the best forum software, but not yet...

                            Comment

                            • Trevor Hannant
                              vBulletin Support
                              • Aug 2002
                              • 24325
                              • 5.7.X

                              #15
                              I've confirmed the Bug report here:

                              Vote for:

                              - Admin Settable Paid Subscription Reminder Timeframe (vB6)
                              - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

                              Comment

                              Related Topics

                              Collapse

                              Working...