Assembla home | Assembla project page
 

Ticket #79 (new Bug Report)

Opened 1 year ago

Last modified 2 months ago

Album/Film art files routine is case insensitive

Reported by: swiss Assigned to:
Priority: High Milestone: 1.22
Component: Core Functionality Version: 1.15.4
Keywords: Cc:

Description

From the forums:

The "Add a filename" won't let you add "Folder.jpg" if "folder.jpg" already exists. On case sensitive systems (like linux or Windows NTFS configured as case sensitive), the two are not the same, and a check for folder.jpg will not return anything if Folder.jpg exists. Thus, the user should be able to add both.

Change History

05/27/07 17:22:48 changed by Pernod

This is actually an issue with MySQL, the filename is the primary key and MySQL is not distinguishing the difference in case resulting in a ‘Duplicate entry’ error.

I’d recommend adding a new field art_id (INTEGER with AUTO_INCREMENT) to the art_files table and use this as the primary key instead of the filename field.

05/27/07 17:54:48 changed by anonymous

Doesn't make any difference ;)

If you had a primary key, you'd still SELECT count(*) FROM artfiles WHERE filename = ':1' to test if the user had already entered that filename or not. The simple answer is just to remove the check - do we really care if the user adds a filename multiple times?

06/23/08 22:09:26 changed by Pernod

  • milestone changed from Undecided to 1.22.