[TYPO3-dam] bug ext_tables.sql?

[Dan Osipov]

The fact that it works on 5.0, but not 5.1 is telling me something is 
wrong with DAM on 5.1... It could be that 5.1 is more syntax strict than 
5.0.

Dan Osipov
Calkins Media
http://danosipov.com/blog/

Jigal van Hemert wrote:
> Dan Osipov wrote:
>>> I think I found a bug in the sql file
>>>  KEY file_name (file_name),
>>> );
>> the last , before ); is wrong
>>> and after correcting this.
>>> i have the next error with createing of the tx_dam table.
>>>
>>> "#1170 - BLOB/TEXT column 'file_name' used in key specification without
>>> a key length"
>> This is most likely due to the MySQL version. Can you file a bug:
>> http://bugs.typo3.org/
> 
> The fact that the last 'create_definition' item in a CREATE TABLE may 
> not be followed by a comma is normal MySQL syntax.
> An index on a BLOB/TEXT column *must* have a key length specification. 
> This is case in MySQL 3.23, 4.0, 4.1, 5.0, 5.1, 5.4 and 6.0 (see [1]; 
> use menu on the left to select the page for a specific MySQL version).
> 
> I can't see anything specific for a MySQL version here!?
> 
> [1] http://dev.mysql.com/doc/refman/5.1/en/indexes.html
> 
> Regards,
>