1.9.5 - Catalog does not get purged of deleted files [Solved]

[BigCheese]

EDIT: The solution was to click "No" on the "Do you want to check for affected entries first?" dialogue box when running Maintenance.

Original Post:
Behavior: After deleting a media file outside of XNView, catalog filter still has a record of them, even after maintenance is ran on the catalog.
Files show as 0byte ghost files.

I believe this behavior was introduced in 1.9.4

Steps to reproduce:
Tag an image in XNview with a category
Close XNView and delete that file in windows explorer (Also delete any relevant sidecar files)
Re-open XNView
Go to settings > Catalog
Run all "Maintenance", "Synchronize" and "Update metadata" features on relevant folder
Go to Catalog Filter Pane, and click the filter for the tag you used earlier
Deleted file shows up with its filename, but as a 0byte, no thumbnail record.

Selecting and deleting these ghost files only removes their record for THAT TAG.
If an image has multiple tags, has to be deleted for EVERY TAG INDIVIDUALLY by selecting the tag filter and deleting the ghost entries again and again.

So far I've manually deleted my entire catalog any time I need a significant clean up, but this is not an ideal solution as I have to rebuild it from scratch every time with "update catalog from files" feature.

[xnview]

I've tried, if i run Maintenance with 'remove data for orphaned files', the entry in database is removed

[BigCheese]

EDIT: Replicated with a blank Portable version, only modified settings a bit to make sure sidecar files are being generated. HOWEVER was able to replicate with DEFAULT settings after this as well!
Video and XNView.ini i used for this test:
https://www.dropbox.com/scl/fo/zdf1o23u ... 0jpap&dl=0

Thanks for checking the issue. I was able to reproduce it again, though it can be a bit finicky

Try with these additional steps:
- Create a NEW category/tag just for this image and tag the image with the tag
- After image is deleted and maintenance has been performed, and XNView has restarted, notice that the Category Filter count for that tag is still (1)
- In Catalog Filter CHANGE MATCH TYPE to "Global"
- Select that tag in the Category Filter.
- Change "Filter By" setting back and forth to something else and back to image (I usually use "custom" myself)

Image:
https://imgur.com/a/6TkKr81

[xnview]

ok, i understand, you need to click on 'No' to remove ALL orphaned entries even those with categories.

[BigCheese]

Thank you, that did in fact solve the issue.
The wording of "Do you want to check for affected entries first" is very vague and non-descriptive to me.

In previous versions of the software clicking "No" had caused me other issues and I had misunderstood its meaning.
What I interpreted it as meaning is somewhere along the lines of "Check if affected files actually exist before removing them from the database"
Since my interpretation is wrong, what is it checking for? What does it do with that check? Would you consider clarifying the dialogue text?
Cheers!