Hello all. I seem to be having a common problem, but I haven't found any existing solutions for my problem. Occasionally, when performing a "Batch add files" operation, duplicate entries for a file will be made in the database, thus displaying the image twice in an the gallery. I say "duplicate entries" and not "duplicate files" because I see there are no extra files in my FTP folder, and the entries in the gallery are pointing to the same files, but they have different IDs, as can be seen in the PHP string. Furthermore, if I choose to delete one entry from the database, the files will be deleted, naturally, but the other entry remains behind, and all references to the image will be broken.
Here is an example:
http://www.sf59fans.com/gallery/thumbnails.php?album=35With the fifth and sixth entries you can see an example of the duplicate entry, and the seventh entry is an example of a broken entry left after deleting one duplicate.
I've performed the upload troubleshooting with HTTP upload, and there are no problems there (no error messages; no duplicates). I do not upload a crazy-large amount of files per folder; I'm not sure I've added more than ten at once. The filenames do not contain any funny characters. This issue seems to strike at random--sometimes batch adds will work without a problem, sometimes the add page will say all files were added successfully, but these duplicate entries will be created, and sometimes the add page
will say "DP." Either way, I'm doing the exact same thing on my end each time.
Test account can be used at
http://www.sf59fans.com/gallery/ with username "test" and password "test".
Author
Topic: Duplicate database entries with batch add (Read 3915 times)