Member
I'm having some very wierd issues with doubles of photos suddenly appearing, and a lot of (new) photos not getting a title (or any other data) in the DB. It's probably something wrong with my specific install (zenphoto version 1.1.6 [1567]), but I'm hoping that someone can help me fix the situation and clean the DB up.
Here's a shot of PHPMyAdmin, showing loads of images with NULL-entries for title/width/height etc. I've run "refresh" from the ZP-admin, but it's not (re-)created. Is there any way to get zenphoto to run through the tables and set this data for me?
The implication of not having this data is stuff like this. Notice how a bunch of photos in that album have no titles...
As for doubles, that's really strange. Here's the thumbnail view of an album showing of the same image twice. In this particular case, on of the images is .JPG and the other it .jpg, but I only ever uploaded it once. Either zenphoto somehow created a copy of the original image, or something happened on the server that put a copy of that image in the directory.
Sometimes the doubles really are identical though. Take a look at this, showing the same image with two different ID's and rows in the table. One with data, the other with NULL-fields.
I've only just noticed this behaviour, but nothing has to my knowledge changed. Do you know of any bugs that might cause these effects?
Here's a shot of PHPMyAdmin, showing loads of images with NULL-entries for title/width/height etc. I've run "refresh" from the ZP-admin, but it's not (re-)created. Is there any way to get zenphoto to run through the tables and set this data for me?
The implication of not having this data is stuff like this. Notice how a bunch of photos in that album have no titles...
As for doubles, that's really strange. Here's the thumbnail view of an album showing of the same image twice. In this particular case, on of the images is .JPG and the other it .jpg, but I only ever uploaded it once. Either zenphoto somehow created a copy of the original image, or something happened on the server that put a copy of that image in the directory.
Sometimes the doubles really are identical though. Take a look at this, showing the same image with two different ID's and rows in the table. One with data, the other with NULL-fields.
I've only just noticed this behaviour, but nothing has to my knowledge changed. Do you know of any bugs that might cause these effects?
Administrator
Actually zenphoto is filesystem based, so it should clean the database with the "refresh" button on admin overview.
Are that newly uploaded photos? I am not sure and not an expert for EXIF data, but I could think that your images maybe have wrong EXIF data attached to them or maybe your camera model is not completly supported by Zenphoto. Since zenphoto tries to use EXIF data to set the title if available, it could be that there is a NULL available and zenphoto uses it.
Could you please check with another program what EXIF data is attached to those images?
Are that newly uploaded photos? I am not sure and not an expert for EXIF data, but I could think that your images maybe have wrong EXIF data attached to them or maybe your camera model is not completly supported by Zenphoto. Since zenphoto tries to use EXIF data to set the title if available, it could be that there is a NULL available and zenphoto uses it.
Could you please check with another program what EXIF data is attached to those images?
Member
The camera is the same Sony DSC-P200 I've used for the past four years. It's never been an issue before.
However, since they've all been through Photoshop I went ahead and double-checked. The metadata of a "working" file is basically the same as the ones not working properly. So yeah, camera/files are not the issue. :/
However, since they've all been through Photoshop I went ahead and double-checked. The metadata of a "working" file is basically the same as the ones not working properly. So yeah, camera/files are not the issue. :/
Member
Member
(Welcome back from the vacation Stephen!)
No I didn't save-for-web. Even if there was no metadata Zenphoto has always produced a title from the filename (see my many screenshots for instance).
I whish there was a method akin to the "refresh", that would analyze rows with missing data (perhaps check for double entries and other anomolies too), double check the files with whatever methods are avaliable (reading exif, asking imagemagick, using the filesystem) and filling in those blanks that are relatively safe to alter.
Of course, I wouldn't want to loose any comments, captions or anything that a human has filled in.
What do you guys suggest I do?
No I didn't save-for-web. Even if there was no metadata Zenphoto has always produced a title from the filename (see my many screenshots for instance).
I whish there was a method akin to the "refresh", that would analyze rows with missing data (perhaps check for double entries and other anomolies too), double check the files with whatever methods are avaliable (reading exif, asking imagemagick, using the filesystem) and filling in those blanks that are relatively safe to alter.
Of course, I wouldn't want to loose any comments, captions or anything that a human has filled in.
What do you guys suggest I do?