[TYPO3-dam] bug ext_tables.sql?

Jigal van Hemert jigal at xs4all.nl
Sun Jul 19 09:30:07 CEST 2009


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,

-- 
Jigal van Hemert.


More information about the TYPO3-project-dam mailing list