0.51: Categories filter shows duplicate entries
Moderators: XnTriq, helmut, xnview, Dreamer
0.51: Categories filter shows duplicate entries
Hi,
I have a strange problem: When I apply/filter Category and Rating (in this case "5") to my folders of images.
I have tagged some pictures with the rating "2". After applying rating filter in the categories tab there are dublicated results with the same filename but different, strange file date.
The problem is only present when filter for the view is set to all files. It disappears when pictures (Bilder) is selected.
Similar problem has been already posted for XnView in 2008: http://newsgroup.xnview.com/viewtopic.p ... ble#p57441.
Best regards
Orloff34
I have a strange problem: When I apply/filter Category and Rating (in this case "5") to my folders of images.
I have tagged some pictures with the rating "2". After applying rating filter in the categories tab there are dublicated results with the same filename but different, strange file date.
The problem is only present when filter for the view is set to all files. It disappears when pictures (Bilder) is selected.
Similar problem has been already posted for XnView in 2008: http://newsgroup.xnview.com/viewtopic.p ... ble#p57441.
Best regards
Orloff34
Kind regards
orloff34
______________________________________________
Ubuntu 12.04, 32 Bit, Unity Desktop + XnViewMP 0.60
orloff34
______________________________________________
Ubuntu 12.04, 32 Bit, Unity Desktop + XnViewMP 0.60
Re: Categories filter shows duplicate entries
it seems that you have ghost items in the database...
Do you have a way to reproduce this problem?
Do you have a way to reproduce this problem?
Pierre.
Re: Categories filter shows duplicate entries
Hello Pierre,
I tried to reproduce the phenomena. No change, I was not able to get the same again. I will have a loo on that.
Best regards
Orloff34
I tried to reproduce the phenomena. No change, I was not able to get the same again. I will have a loo on that.
Best regards
Orloff34
Kind regards
orloff34
______________________________________________
Ubuntu 12.04, 32 Bit, Unity Desktop + XnViewMP 0.60
orloff34
______________________________________________
Ubuntu 12.04, 32 Bit, Unity Desktop + XnViewMP 0.60
Re: Categories filter shows duplicate entries
In database queries, spurious duplicate records are evidence of an incorrectly specified SQL JOIN statement.
John
Re: Categories filter shows duplicate entries
It's not duplicate entries, only ghost entries
Pierre.
Re: Categories filter shows duplicate entries
I'm just guessing at what is going on behind the scenes in MP, but: If there are duplicates in a dependent record source, to suppress them in the final result, specify that distinct records are to be returned.only ghost entries
"Distinct" can lengthen query times considerably. Make sure that the join fields are all indexed and examine each subordinate query for "worst-case" number of records retrieved. Sometimes "Distinct" is best applied to the final "top" query, other times to one of the subordinate queries.
Apologies if I am 'way off course with my guess.
John
-
- Posts: 2
- Joined: Thu May 20, 2021 11:59 am
Re: 0.51: Categories filter shows duplicate entries
Hey people, I've had the same problem (pictures appearing twice when filtering by category). Deleting and restoring the pictures did not help -- the images from some folders kept reappearing as twins, i.e. two times.
I just found the cause of the problem: The directories (folders) in question were included twice in the folder list on the Catalog tab (under Settings). After deleting the second (identical) file path the duplicate images disappeared. Hope this is useful to you people!
I just found the cause of the problem: The directories (folders) in question were included twice in the folder list on the Catalog tab (under Settings). After deleting the second (identical) file path the duplicate images disappeared. Hope this is useful to you people!
Re: 0.51: Categories filter shows duplicate entries
do you use 'base folder' in settings>Catalog?Andreas Berning wrote: ↑Thu May 20, 2021 12:11 pm Hey people, I've had the same problem (pictures appearing twice when filtering by category). Deleting and restoring the pictures did not help -- the images from some folders kept reappearing as twins, i.e. two times.
I just found the cause of the problem: The directories (folders) in question were included twice in the folder list on the Catalog tab (under Settings). After deleting the second (identical) file path the duplicate images disappeared. Hope this is useful to you people!
Pierre.
Re: 0.51: Categories filter shows duplicate entries
Hi there. just to confirm I have the exact same problem and it has been annoying me for some time. using 0.98.4
For most Category filters there are double files listed. I realise there are not duplicate files because file location is the same, and setting new category on one changes both files in list etc.
In Settings > Catalogue folder list, folders are listed twice. And I use a base folder 'my_pics'
I can't go through the list deleting the doubles, there are hundreds.
For most Category filters there are double files listed. I realise there are not duplicate files because file location is the same, and setting new category on one changes both files in list etc.
In Settings > Catalogue folder list, folders are listed twice. And I use a base folder 'my_pics'
I can't go through the list deleting the doubles, there are hundreds.
- Attachments
-
- xnview-db-duplicates.png (10.77 KiB) Viewed 984 times
Build Debian http://dquinton.github.io/debian-install/
Re: 0.51: Categories filter shows duplicate entries
do you use 'base path'?orbspider wrote: ↑Tue Jun 29, 2021 4:09 am Hi there. just to confirm I have the exact same problem and it has been annoying me for some time. using 0.98.4
For most Category filters there are double files listed. I realise there are not duplicate files because file location is the same, and setting new category on one changes both files in list etc.
In Settings > Catalogue folder list, folders are listed twice. And I use a base folder 'my_pics'
I can't go through the list deleting the doubles, there are hundreds.
Pierre.
Re: 0.51: Categories filter shows duplicate entries
Hi Pierre, yes I do.
Set to /media/D1/my_pics
Set to /media/D1/my_pics
Build Debian http://dquinton.github.io/debian-install/
Re: 0.51: Categories filter shows duplicate entries
Why? Do you use multiple computers?
It seems that you have some files with base path and some without
Pierre.
Re: 0.51: Categories filter shows duplicate entries
HI, yes I thought that a base folder path was a good way to prevent files from all over the computer getting in the catalogue, is that right or not?
So, on removing base path.... it seems the duplicates are no longer made with a category filter!
So, on removing base path.... it seems the duplicates are no longer made with a category filter!
Build Debian http://dquinton.github.io/debian-install/
Re: 0.51: Categories filter shows duplicate entries
Pierre, what is 'base folder' for??
Do you suggest I use it or not?
When I removed 'base folder' it actually damaged my categories, like they all disappeared.
So I cleared catalog and added folders back. But now files with keywords are funny, they show up with category filter, but there is no category in the tooltip or in categories checkboxes, but there is in Info > XMP.
Do you suggest I use it or not?
When I removed 'base folder' it actually damaged my categories, like they all disappeared.
So I cleared catalog and added folders back. But now files with keywords are funny, they show up with category filter, but there is no category in the tooltip or in categories checkboxes, but there is in Info > XMP.
Build Debian http://dquinton.github.io/debian-install/