XnView Software

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

it seems that you have ghost items in the database...
Do you have a way to reproduce this problem?

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

In database queries, spurious duplicate records are evidence of an incorrectly specified SQL JOIN statement.

It's not duplicate entries, only ghost entries

only ghost 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.

"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.

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!

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!

do you use 'base folder' in settings>Catalog?

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.

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.

do you use 'base path'?

Hi Pierre, yes I do.
Set to /media/D1/my_pics

orbspider wrote: Thu Jul 01, 2021 8:16 am Set to /media/D1/my_pics

Why? Do you use multiple computers?
It seems that you have some files with base path and some without

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!

orbspider wrote: Fri Jul 16, 2021 1:12 am 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?

what do you means?

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.