SQL-Errors while Upgrading the database with Upgrade Wizard
i'm trying to update a TYPO3 6.1.7 to TYPO3 6.2.0beta7 with the Install Tool and the Upgrade Wizard. While performing the needed Database-Updates i get this error "SQL-ERROR: Specified key was too long; max key length is 1000 bytes" by executing the sql-command: "ALTER TABLE sys_file_processedfile CHANGE identifier identifier varchar(512) default ''; "
I also had a problem while the Upgrade Wizard want's to alter the table sys_file_processedfile and it's coloumn "identifier" which was set to 200. This Command was used: ALTER TABLE sys_file_processedfile ADD KEY identifier (storage,identifier(249)); . This is what i got: "Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys"
I manually changed the lenght of the coloumn to 249 and it worked for me. But i guess theire is no need to check the lenght of the field in the alter command.
I guess here are some fixes needed.
[BUGFIX] Reduce length of identifier key in sys_file_processedfile
To support a smooth upgrade from a 6.0 or 6.1 system, we have to reduce
the length if the identifier field for the key "identifier".
#3 Updated by Thorsten Bringewatt over 5 years ago
I get the same error when trying to update a 4.5.32 TYPO3 installation to 6.2.0beta7.
I changed the symlink, went to the upgrade wizard and executed the step "Update database schema: Create tables and fields".
SQL-ERROR: Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
ALTER TABLE sys_file_processedfile ADD KEY identifier (storage,identifier(249));
#7 Updated by Sammy Baghdadi over 5 years ago
The issue is on Line 371 in the file /typo3/sysext/core/ext_tables.sql. It is still present in the final TYPO3 6.2. I fixed it manually by changing the line from
identifier varchar(512) DEFAULT '' NOT NULL,
identifier varchar(256) DEFAULT '' NOT NULL,
Now it works for me.