Issue Bug Closed

#33580prepending "zzz_deleted_" might exceed the maximal lenght for column names

Tolleiv Nietsch 02/01/12, 10:23 updated 10/24/17, 20:19

Description

I found that renaming a column to “zzz_deleted_tx_powermail_tellAFriendForm_receiverEmailContentField” didn’t work because if it’s size of 66 characters. MySQL allows only 64 – therefore I suggest to add that limitation also to t3lib_install_sql.

At the same time the patch has to make sure that the shortened names don’t create collisions – therefore the field names are cut of from the beginning of the name because it’s less likely to create collision this way.

See MySQL documentation: http://dev.mysql.com/doc/refman/5.5/en/identifiers.html

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.