[TYPO3-dam-devel] FYI72 #17583: ALTER TABLE fails during update of tx_dam

[Lorenz Ulrich]

Hi folks,

this is an SVN patch request.

Type: Bugfix, no-brainer

Bugtracker reference: http://bugs.typo3.org/view.php?id=17583

Branches: trunk

Problem:
The table setup for DAM contains a key for file_name with a limited lenght:

KEY file_name (file_name(32))

This was introduced in <http://bugs.typo3.org/view.php?id=14434> because 
this field had type TEXT in ancient times and if a TEXT type field is 
used in key a lenght needs to be specified.

For DBAL compatibility the field was changed to VARCHAR in 
<http://bugs.typo3.org/view.php?id=12525>.

Now that they're VARCHAR (and so there's no need to limit key lenght) 
and DBAL is unable to handle keys with limited lenght (according to 
Xavier Perseguers):

Solution:
Remove key lenght.



Report and patch is from Tobias Schaefer. I will commit this as a 
no-brainer if there are no objections within 72 hours.



Best regards,


Lorenz