Maintenance utility "remove data for orphaned files" doesn't work properly
Posted: Mon Jan 20, 2025 4:09 pm
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:
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: 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%'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
