Project

General

Profile

Actions

Bug #57002

closed

SQL-Errors while Upgrading the database with Upgrade Wizard

Added by Sammy Baghdadi about 10 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2014-03-17
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
5.3
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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.


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Bug #57805: SQL-ERROR: Specified key was too longClosed2014-04-10

Actions
Is duplicate of TYPO3 Core - Bug #56786: Index on sys_file_processedfile is too largeClosedErnesto Baschny2014-03-11

Actions
Actions

Also available in: Atom PDF