[TYPO3-dam-devel] RFC: file_path dam/ext_tables.sql

[Michael Stucki]

Write an update function that checks if the key exists and if so, removes it
silently.

- michael

Peter Kuehn [wmdb] wrote:

> Hi yall,
> 
> the repository version defines the field tx_dam.file_path as
> 
>    file_path varchar(255) DEFAULT '' NOT NULL,
>    [...]
>    KEY file_path (file_path)
> 
> somewhere in the process weve decided to change the fielddefinition to
> 
>    file_path text NOT NULL,
> 
> and to *remove* the KEY same time.
> 
> if you now upgrade from 1.0.11 to latest sources the
>    ALTER TABLE tx_dam CHANGE file_path file_path text NOT NULL;
> statement in the extension manager is not executed due to an
>    BLOB/TEXT column 'file_path' used in key specification
>    without a key length
> error *without any notice or message*.
> 
> I think mostly noone will recognise the change that way.
> 
> please discuss how to fix this:
> - keep the old field definition or
> - keep the key
> 
> gRTz
> pekue

-- 
Use a newsreader! Check out
http://typo3.org/community/mailing-lists/use-a-news-reader/