Page 1 of 1

Long filename-extensions get cut off

Posted: Thu Sep 22, 2005 7:12 pm
by g00dman
Hi.

I'm trying to put a torrent-File into the Media-Database (german: Mediendatenbank).
Uploading a file called "test.torrent" will result in a file named "test.torrent" on the webserver, but in the DB the filename is just "test.torre". That way I'm not able to use this file directly. I could add a link to a new entry using the Mediadatabase, but the link created by this function also calls "test.torre", which of course doesn't work. Also deleting this entry from the Mediadatabase just leads to a message, that test.torre couldn't be deleted, because the file doesn't exists, leaving the test.torre-file on the Webserver for me to manually remove.

Re: Long filename-extensions get cut off

Posted: Thu Sep 22, 2005 10:35 pm
by garvinhicking
Yes, the database column for "file extension" is only varchar(5), so you cannot store file extensions with more than 5 characters.

You can change the varchar(5) to varchar(100) on your system to bypass this behaviour. Use phpMyAdmin or a similar tool to change the DB setting...

Regards,
Garvin