0.69 Catalog mess using "base path of the pictures"

Older bugs which are supposed to be fixed in 0.84. *** Please try to reproduce your bug and confirm the bug fix. ***

Moderators: XnTriq, helmut, xnview, Dreamer

Post Reply
baptiste
Posts: 2
Joined: Mon Nov 10, 2014 10:10 am

0.69 Catalog mess using "base path of the pictures"

Post by baptiste »

Hello,

I'm evaluating XnViewMP 0.69 (never used XnView nor XnViewMP before) to sort and catalog my pictures. I think I spotted one (or maybe two) issue(s) using the in the filed "Base path of the pictures" (Settings -> Catalog) when moving/copying files. Test done under MacOSX 10.10.

My "base" folder /Users/Shared/tmp/private/testxnv/pictures.
My catalog in folder /Users/Shared/tmp/private/testxnv/xnview.

If I do not use the base path to something else than / (the default), everything I checked is fine : tags, rating and color are still there.
If I do use a base folder, with the value /Users/Shared/tmp/private/testxnv/pictures, then things get messy.

The test was done from an empty catalog (deleted xnview.db). I've used command line sqlite3 from the terminal to observe the content of the catalog.

Setting up the test

- I start XnViewMP. Configure the base path. Browse to the base path so it will remember at new start. Quit XnViewMP.
- I delete the catalog.
- I start XnViewMP, set a color and a tag on image with ID 5 (see below).

I run the following requests against the catalog (# characters from me to distinguish requests' outputs):

Code: Select all

sqlite> select * from Folders; select ImageID, FolderID, Filename, Rating, Color from Images; select * from TagsTree;
1|@
#####
1|1|b1|0|0
2|1|IMG_20140911_190621.jpg|0|0
3|1|IMG_20140911_190631.jpg|0|0
4|1|IMG_20140912_114151.jpg|0|0
5|1|IMG_20140912_135046.jpg|0|4
#####
5|11
For now, that's fine.

Now the bug

- I copy (either drag n' drop or #C/#V) file 5 to folder b1/.

The catalog:

Code: Select all

sqlite> select * from Folders; select ImageID, FolderID, Filename, Rating, Color from Images; select * from TagsTree;
1|@
2|@b1/
#####
1|1|b1|0|0
2|1|IMG_20140911_190621.jpg|0|0
3|1|IMG_20140911_190631.jpg|0|0
4|1|IMG_20140912_114151.jpg|0|0
5|1|IMG_20140912_135046.jpg|0|4
6|2|IMG_20140912_135046.jpg|0|0
#####
5|11
Here you can see the copy of the file, with new ImageID 6 has no color and no tag. The same happens if I move the file instead.

Another example

I didn't capture my full SQL output on this one. But I'll summarize it. I have the following Folders table:

Code: Select all

sqlite> select * from Folders; select ImageID, FolderID, Filename, Rating, Color from Images; select * from TagsTree;
1|@
### [...]
When I copied a file from outside the base path, to a folder inside the base path, either /Users/Shared/tmp/private/testxnv/pictures or a subfolder, it created a new entry in table Folders, and the copied file was referenced twice in Images table:

Code: Select all

sqlite> select * from Folders; select ImageID, FolderID, Filename, Rating, Color from Images;
1|@
### [...]
7|/Users/Shared/tmp/private/testxnv/pictures
###
23|1|IMG_1475.jpg|0|0
23|7|IMG_1475.jpg|0|2
Also notice the mess (again) with the color value.

So, for now, the base path feature appears no usable to me, which I strongly regret, as I want to use it on both Mac and Windows, where base path are intrinsically different. I may do more specific tests if you want. For the moment, I think XnView could really fit my needs, with this problem handled.

Cheers,

Baptiste.
User avatar
xnview
Author of XnView
Posts: 43357
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: 0.69 Catalog mess using "base path of the pictures"

Post by xnview »

ok, thanks i'll check
Pierre.
User avatar
xnview
Author of XnView
Posts: 43357
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: 0.69 Catalog mess using "base path of the pictures"

Post by xnview »

Do you still have this problem with latest version 0.84?
Pierre.
Post Reply