Export contains multiple incorrect images

I have turned off mod_security and mod_pagespeed and the problem persists. I’m not getting any errors. There are no permission problems in the uploads directory. In a directory with 137 exported jpg files, there are 5 groups of duplicates with components ranging from 2 to 16. Fortunately, the stored jpg files in the uploads directory are correct.

fdupes -1 .
./3478.jpg ./3480.jpg
./3470.jpg ./3471.jpg ./3472.jpg ./3473.jpg ./3474.jpg ./3475.jpg ./3476.jpg ./3477.jpg ./3479.jpg ./3481.jpg ./3482.jpg ./3483.jpg ./3484.jpg ./3493.jpg
./3434.jpg ./3444.jpg ./3450.jpg
./3431.jpg ./3432.jpg ./3433.jpg ./3437.jpg ./3438.jpg ./3439.jpg ./3440.jpg ./3441.jpg ./3442.jpg ./3443.jpg ./3445.jpg ./3446.jpg ./3447.jpg ./3448.jpg ./3449.jpg ./3451.jpg
./2826.jpg ./3460.jpg

I would be happy to help troubleshoot this, but not sure where to start.

I figured it out, at least partially. In the table wp_wppa_photos, many of the filenames were wrong. They were most often the filenames of the original uploaded image, many of them duplicates such as 0001.jpg as they were named by the scanner. Some of them were custom names I had given the files. In many cases, though, the filenames weren’t the actual filenames. The UI is identifying database rows by the encrypted name and thus finds the correct row (although I don’t know how it’s finding the actual image if it needs to). The export function is apparently looking up actual filenames, and if it couldn’t find a file by that name, it just substituted the most recent one. I believe I have fixed it by running the query “update wp_wppa_photos set filename=concat(id,”.jpg”) where album=41;” and it doesn’t look like it broke anything else.

I did some tests yesterday and did not find any problems.
However, thank you for your analysis, it will help me to fix it.

I am trying to reproduce this issue, but even with equal names and equal filenames i get all the different images in the zip.

How did you find the duplicate images? on the pc when lookin in the zip, or after re-import (on a different installation)?

Another question: did you have saved original source files (see Advanced settings -> Files -> I -> Item 1 Keep source files)

“Keep source files” is checked and has never been changed from the default.

If you create a test directory and put the actual filenames (eg 1.jpg, 2.jpg) in the ‘filename’ field for some of them, and put other names (eg “not real name.jpg’) in the ‘filename’ field for some of them, then export, you will get a file for each record, and they will be named correctly, eg 1.jpg through 10.jpg. However, some of the files will not contain the correct image for that filename.

There are 150+ files in the directory I was exporting for the purpose of putting the files on a USB stick. For the first few iterations, I didn’t notice a problem. However, at the end when I plugged in the stick on my Chromebook and it displayed thumbnails images, I noticed the duplicates.

I am running WPPA in Docker on a Linux server. In order to remove the possibility of caching or other Chromebook idiosyncrasies, I expanded the zip file in a command line, then used the fdupes command to find duplicates. In each group of duplicates, one of the images is correct, and all of the others are duplicates of that one correct image.

Thanks for pursuing this issue. Let me know if there is anything I can do to help.