during the upgrade process from 7.6 to 8.7 the database Analyzer fails in the following statement:
Error:
Database update failed
Error: Specified key was too long; max key length is 1000 bytes
can you help?
Asked
Active
Viewed 485 times
0
Leo
- 101
- 12
-
Possible duplicate of [Mysql::Error: Specified key was too long; max key length is 1000 bytes](https://stackoverflow.com/questions/3489041/mysqlerror-specified-key-was-too-long-max-key-length-is-1000-bytes) – Thomas Löffler Oct 04 '18 at 19:23
-
seems you are right: ..... VARCHAR(333) ... works. but I think typo3 needs 1024 .. or? is this an typo3 bug, or how can I solve this? – Leo Oct 04 '18 at 19:40
-
Which mysql version are you using? – Thomas Löffler Oct 04 '18 at 19:54
-
mysql-server-5.7 – Leo Oct 04 '18 at 20:07
1 Answers
-2
i found the solution.
drop index lookup_string on sys_refindex;
then you can run database analyzer in to steps:
- ALTER TABLE ....
- CREATE INDEX .... but this is done by database analyzer in upgrade wizard
Leo
- 101
- 12