Issue Bug Closed

#57002SQL-Errors while Upgrading the database with Upgrade Wizard

Sammy Baghdadi 03/17/14, 17:29 updated 10/02/18, 11:58

Description

Hi,

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.

Reviews 1