[TYPO3-dam-devel] RFC: Bugfix: 6342: Length of the DB fields "file_name" and "file_path" in DB table "tx_dam" are too short

[Michiel Roos]

This is a svn patch request.

Type: bugfix, no-brainer

Description:
Because the fields are to short, files with longer path or file names 
are indexed wrong. At the moment in this case there will be invalid db 
records created after every indexing, which leeds to a lot of problem 
like missing files and 10 time the same file in a directory...

The field file_path is only varchar(255), which is very short for big 
websites with a lot of sub directories in dam.

Solution:
Change tca.php and ext_tables.sql as described in the diff.

Discuss:
What is a reasonable lenght for the file_path? It is now set to 10000, 
is this too short or just about right?

Branches:
Head

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

Kind regards,


Michiel Roos

-- 
Netcreators BV :: creation and innovation
www.netcreators.com

Interesse in werken bij Netcreators?
http://www.netcreators.com/bedrijf/vacatures/


-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: bug_6342.diff
Url: http://lists.netfielders.de/pipermail/typo3-team-dam/attachments/20071028/664b5e46/attachment.txt 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: michiel.vcf
Type: text/x-vcard
Size: 292 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-dam/attachments/20071028/664b5e46/attachment.vcf