typo3typo3-8.7.x

Typo3 Upgrade 7.6.31 to 8.7.19 / Database Analyzer fails


during the upgrade process from 7.6 to 8.7 the database Analyzer fails in the following statement: enter image description here

Error:

Database update failed

Error: Specified key was too long; max key length is 1000 bytes

can you help?


Solution

  • i found the solution.

     drop index lookup_string on sys_refindex;
    

    then you can run database analyzer in to steps:

    1. ALTER TABLE ....
    2. CREATE INDEX .... but this is done by database analyzer in upgrade wizard