Several files pointing to the same photo_id

[danielo515]

Take a look at this screenshot:

As you can see, there are several files with different file_hash pointing to the same photo with the same photo_id and photo_uid.

If you want to check if there are duplicates on your DB run this:

SELECT photo_id, file_hash, count(photo_id) 
FROM files 
WHERE file_type IN (0x6A7067)  -- This is JPEG
GROUP BY photo_id order by 3 DESC;

On this video you can see how navigating the galery for those files feels:

You may find some duplicates

[lastzero]

Did you disable "Stack Sequences" in settings? Likely due to your file names, I see lots of brackets.

[danielo515]

Did you disable "Stack Sequences" in settings?

No I didn't. What are they for?

Likely due to your file names, I see lots of brackets.

Yeah, those are from the old days, when I was almost a teen and I had no idea about file naming (and some of my family members made it even worse)

[danielo515]

Stack sequences: Files with sequential names like 'IMG_1234 (2)' or 'IMG_1234 copy 2' belong to the same photo

Oh, I see. That's why some of my photos had a "sequence" icon. I just disabled it, I'll see what happens. Should I re-index or something?

By the way, in case they were, how would I see them in sequence? I didn't found a way to see the sequence. I though I should just click the sequence icon but nothing happened.

[graciousgrey]

@danielo515 If you click the sequence icon on the image, it should open in fullscreen. If you then use the arrows you can switch between the images of the sequence in fullscreen mode.
What exactly happens when you click on the sequence icon? From what view did you try?

[danielo515]

When I clicked it open the sequence like any other photo. I didn't tried to move with the arrows, but that is a bit not intuitive, there is nothing indicating that I can do that. I can't check again because I just disabled the option and rebuilt my library

[graciousgrey]

We know there is room for improvement. Any ideas how to improve the UX for that?
We plan to provide an option to manually merge similar images to stacks (#28 ), maybe we find a better solution for browsing through sequences then.
Can we close this issue?

[lastzero]

In there any specific bug or new feature request? If yes, the title should be changed. If no, we should close this issue.