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.
Comments
If you want to purge the record yourself, it is in the <prefix>images table of the database. But first you must delete it from the file system or it will just come back into the database.