starred/photoprism

Fork 0

mirror of https://github.com/photoprism/photoprism.git synced 2026-03-02 22:57:18 -05:00

Several files pointing to the same photo_id #484

New issue

Closed

opened 2026-02-19 23:09:47 -05:00 by deekerman · 7 comments

deekerman commented

2026-02-19 23:09:47 -05:00

Owner

Originally created by @danielo515 on GitHub (Nov 10, 2020).

Originally assigned to: @lastzero on GitHub.

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

Originally created by @danielo515 on GitHub (Nov 10, 2020). Originally assigned to: @lastzero on GitHub. Take a look at this screenshot: ![Screenshot 2020-11-10 at 21 05 13](https://user-images.githubusercontent.com/2270425/98727789-cad6ad80-2398-11eb-81ec-c98ae682e6cb.png) 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: ```sql 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: ![Screen Recording 2020-11-10 at 21 10 42](https://user-images.githubusercontent.com/2270425/98728255-87307380-2399-11eb-8a9b-bd67ab21c4ae.gif) You may find some duplicates

deekerman

2026-02-19 23:09:47 -05:00

closed this issue
added the
question

waiting
labels

deekerman commented

2026-02-19 23:09:48 -05:00

Author

Owner

@lastzero commented on GitHub (Nov 10, 2020):

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

@lastzero commented on GitHub (Nov 10, 2020): Did you disable "Stack Sequences" in settings? Likely due to your file names, I see lots of brackets.

deekerman commented

2026-02-19 23:09:48 -05:00

Author

Owner

@danielo515 commented on GitHub (Nov 11, 2020):

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 commented on GitHub (Nov 11, 2020): > 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)

deekerman commented

2026-02-19 23:09:48 -05:00

Author

Owner

@danielo515 commented on GitHub (Nov 11, 2020):

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.

@danielo515 commented on GitHub (Nov 11, 2020): > 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.

deekerman commented

2026-02-19 23:09:49 -05:00

Author

Owner

@graciousgrey commented on GitHub (Nov 11, 2020):

@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?

@graciousgrey commented on GitHub (Nov 11, 2020): @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?

deekerman commented

2026-02-19 23:09:49 -05:00

Author

Owner

@danielo515 commented on GitHub (Dec 1, 2020):

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

@danielo515 commented on GitHub (Dec 1, 2020): 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

deekerman commented

2026-02-19 23:09:49 -05:00

Author

Owner

@graciousgrey commented on GitHub (Dec 1, 2020):

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?

@graciousgrey commented on GitHub (Dec 1, 2020): 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?

deekerman commented

2026-02-19 23:09:49 -05:00

Author

Owner

@lastzero commented on GitHub (Dec 6, 2020):

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

@lastzero commented on GitHub (Dec 6, 2020): In there any specific bug or new feature request? If yes, the title should be changed. If no, we should close this issue.