Bug #57805
SQL-ERROR: Specified key was too long
| Status: | Resolved | Start date: | 2014-04-10 | |
|---|---|---|---|---|
| Priority: | Must have | Due date: | ||
| Assigned To: | - | % Done: | 0% |
|
| Category: | Install Tool | Spent time: | - | |
| Target version: | next-patchlevel | |||
| TYPO3 Version: | 6.2 | Is Regression: | No | |
| PHP Version: | Sprint Focus: | |||
| Complexity: |
Description
In the upgrade process from 6.0 to 6.2 I get this error
Update failed! SQL-ERROR: Specified key was too long; max key length is 1000 bytes Update database schema: Modify tables and fields ALTER TABLE sys_file_processedfile CHANGE identifier identifier varchar(512) default '';
Related issues
History
#1 Updated by Markus Klein over 1 year ago
- Category set to Install Tool
- Status changed from New to Accepted
- Priority changed from Should have to Must have
- Target version set to next-patchlevel
Happens on upgrading from 6.x.
#2 Updated by Markus Klein over 1 year ago
In 6.0 the identifier field has varchar(200).
The wizard tries to extend the field to varchar(512) which fails somehow.
I suspect the reason is the associated index with the same name.
Maybe it helps to remove the index first (manually in the DB) and let the wizard try the step again. It should then be able to extend the field and re-create the index automatically.
#3 Updated by Oliver Hader over 1 year ago
- File forge_57805.png added
The reason seems to be the processing order and the fact the the existing index is not limited. Thus, it should be:
- drop index (DROP KEY identifier)
- modify field (CHANGE identifier)
- create index (ADD KEY identifier)
#4 Updated by Markus Klein over 1 year ago
That's what I wrote above. But do we have a chance to do that automatically?
#5 Updated by Nicole Cordes over 1 year ago
- Status changed from Accepted to Resolved
This issue was solved with patch for http://forge.typo3.org/issues/57421