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

[Lorenz Ulrich]

Commited to trunk rev. 45027.

Am 28.02.2011 00:20, schrieb Dan Osipov:
> Makes sense to me. I think it was limited size for performance reasons,
> since the paths can get long.
>
> On 2/23/11 7:19 PM, Lorenz Ulrich wrote:
>> 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
>