[Neos] Migrations: Specified key was too long; max key length is 767 bytes

[Martin Keck]

Hi Simon,

just edit the the migration Version20131129110302 in TYPO3.TYPO3CR like described by Nick here:
http://forum.typo3.org/index.php?t=msg&th=200717&goto=700840&#msg_700840

Change the mentioned line to:
$this->addSql("CREATE INDEX path_workspace ON typo3_typo3cr_domain_model_nodedata (path(255), workspace(255))");

This did it for me on my Macbook (10.8.5) with MySQL 5.6.13.

Greetings
Martin



Am 23.12.2013 um 21:26 schrieb Simon Schaufelberger (Schaufi) <simonschaufi at guugelmail.com>:

> whats the solution here as i halso have the problem on my macbook?
> 
> Am 19.12.13 11:19, schrieb Bastian Waidelich:
>> Christian Müller wrote:
>> 
>> Hi Christian,
>> 
>>> I now got the info from two persons that the migrations of Neos didn't
>>> work for them and stopped with the error
>>> "Specified key was too long; max key length is 767 bytes". [...]
>> 
>>> Now for this specific index I really would suggest we remove it from the
>>> migrations, as currently it is created and removed again. It wouldn't be
>>> breaking in any case. Even if you are on Version20131129110302 it just
>>> means you have an unnecessary index that you should drop. What do you
>>> think?
>> 
>> +1 that's what I also suggested in a thread some days ago[1]. But we
>> need to make sure that the DROP statement is only executed if the index
>> exists (there is no "IF EXISTS" modifier for indexes unfortunately)
>> 
>> 
>>> I got another report [...]
>>> This normally isn't a problem unless the charset is utf8mb4
>> 
>> Do you know whether the Setup tool warns you if you choose a DB with
>> utf8mb4 charset?
>> 
>> 
>> [1]
>> http://forum.typo3.org/index.php?t=msg&th=200717&goto=700840&#msg_700840
>> 
> 
> -- 
> Regards, Schaufi
> _______________________________________________
> Neos mailing list
> Neos at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/neos



Bloom ist Branchensieger im „Jahr der Werbung" 2013. In der Kategorie
„Alkoholische Getränke“ (B2C) landete Bloom auf dem ersten Platz. Alle Infos
auf http://www.bloomproject.de/arbeiten/show/lederer-markenpositionierung/