Maintenance utility "remove data for orphaned files" doesn't work properly

[CyrilS]

Subject: 1.8.3 : Maintenance utility "remove data for orphaned files" doesn't work properly.

XnView: MP 1.8.3 - 64 bit
OS: Windows 64bit

Effect: no visible effect, but incorrect database content

To reproduce:

1. Close XnView MP
2. Move an image from one folder to another with Windows Explorer
3. Launch XnView MP
4. Run the following query on the SQLite database:

Code: Select all

SELECT f.pathname, i.*
from Images i
join folders f on i.folderId = f.folderId
where filename like '%désert%'

Result: the query returns 2 rows corresponding to the old and new folders of the image, which is quite normal.

5. Launch the maintenance utility by checking the box "remove data for orphaned files"
6. rerun the previous query on the database.
Result: the record corresponding to the old folder is still present

Expected behaviour: the query should return only one row, corresponding to the new image folder

[xnview]

it works correctly here, are you able to reproduce each time?

[CyrilS]

I was systematically reproducing the problem in version 1.8.3, but since upgrading to 1.9.1, it seems to have been solved

Note that images present in the database but deleted from disk (via Windows Explorer, for example) are displayed as thumbnails. Ideally, when you delete the thumbnail (by right-clicking Delete), it should also delete the corresponding entry in the database.