One of my users uploaded a photo with the filename of "8 X 2.5 Table.JPG". It shows up in the directory as "8\ X 2.5\ Table.JPG" and this is the filename ZenPhoto assumes it to have, but it doesn't show a thumbnail and when I click on delete, it won't delete it. The file is owned by apache, I can delete other photos with the same permissions in this directory, so I'm guessing it has trouble with this file name.
What tables will I need to write a query to in order to delete this properly from the database and is there a module for Zen Photo that I can add to make sure people don't upload files that don't fit within a filename structure ZP expects?
Thank you in advance for your time.
If you use FTP to delete the image from the albums folders you can then use the refresh database button to get rid of any database record. With the 1.1.5 release there will is a function that sanitizes the names of files uploaded by zenphoto. But, of course, it is unable to do anything about files uploaded by FTP.
If you want to purge the record yourself, it is in the images table of the database. But first you must delete it from the file system or it will just come back into the database.