Announcement

Collapse
No announcement yet.

Error upgrading from 26 to 27

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

  • 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)


  • #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


    • #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


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

        Comment


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

          Comment


          • #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


            • #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


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

                Comment


                • #9
                  unzipped locally and uploaded per instructions

                  Comment


                  • #10
                    hmmmmmm

                    Comment


                    • #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


                      • #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


                        • #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


                          • #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

                            Related Topics

                            Collapse

                            Working...
                            X