MP LINUX v0.25 - Search into database

*** Please report new bugs here! ***

Moderators: helmut, XnTriq, xnview, Dreamer

User avatar
oops66
XnThusiast
Posts: 2005
Joined: Tue Jul 17, 2007 1:17 am
Location: France

MP LINUX v0.25 - Search into database

Post by oops66 »

Sorry, but it's strange this problem has reappeared into this v0.21, I have it again !
see here: http://newsgroup.xnview.com/viewtopic.p ... 820#p77820
The function Search by IPTC Keywords
To reproduce:
Tools\Search \ ADD-->\ IPTC\Keywords\ (is) or (contain) \ "your keyword"\ ... does'nt work if "Use Database" is checked.
(I have checked into XnView MP database via sqlitebrowser, and it seems however that all keywords are already into the db)
PS: If "Use Database" is non checked, this function works correctly.
Last edited by oops66 on Tue Mar 16, 2010 10:52 pm, edited 1 time in total.
XnViewMP Linux X64 - Debian - X64
User avatar
xnview
Author of XnView
Posts: 37889
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by xnview »

I can't reproduce...
(I have checked into XnView MP database via sqlitebrowser, and it seems however that all keywords are already into the db)
When searching in IPTC, imported keywords are not used. XnView search in Images::Meta field
So perhaps this DB info is not good... Try with a clean DB?
Pierre.
User avatar
oops66
XnThusiast
Posts: 2005
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by oops66 »

xnview wrote:I can't reproduce...
(I have checked into XnView MP database via sqlitebrowser, and it seems however that all keywords are already into the db)
When searching in IPTC, imported keywords are not used. XnView search in Images::Meta field
So perhaps this DB info is not good... Try with a clean DB?
Hello Pierre,
I have tried to delete the XnView.db file, but unfortunately I have the same problem with this fresh XnView.db file.

PS: A other important thing: it's better to have by default the criteria: "=Contains" instead "=is "
XnViewMP Linux X64 - Debian - X64
User avatar
JohnFredC
XnThusiast
Posts: 2010
Joined: Wed Mar 17, 2004 8:33 pm
Location: Sarasota Florida

Re: MP LINUX v0.21 - Search into database

Post by JohnFredC »

oops66 wrote:A other important thing: it's better to have by default the criteria: "=Contains" instead "=is "
Maybe...
John
User avatar
xnview
Author of XnView
Posts: 37889
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by xnview »

Is it possible to have some files? And which search?
Pierre.
User avatar
oops66
XnThusiast
Posts: 2005
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by oops66 »

xnview wrote:Is it possible to have some files? And which search?
Yes why not (but not easy because I have a lot of files, more than 500), maybe you can first try to add some IPTC keywords with some characters like ( "space", "@", "(", "?" upper& lower case) .
IPTC keywords examples:

Code: Select all

Black Cat ? @home:3 (5) IPTC sample
red Dog (41) @ChicaGo gaRdEn: ... else - iptc sample
Name Firstname ? (21) IpTc sample
testtttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt (1) sample iPtC
...
I have some IPTC keywords with about 50 characters ( 54 is my maximum)
Pierre, how many characters max are supported for IPTC keywords ?
XnViewMP Linux X64 - Debian - X64
User avatar
xnview
Author of XnView
Posts: 37889
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by xnview »

oops66 wrote:Pierre, how many characters max are supported for IPTC keywords ?
I think 256

But you use special character in your search? Or perhaps send me your .db?
Pierre.
User avatar
oops66
XnThusiast
Posts: 2005
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by oops66 »

OK I have found the problem ( IPTC Keywords search into Data base):

1-) If I first select the Tab Categories ( browser mode) --> then do Tools\Search ---> then (the field : Filename is blank & the field "Directory" is blank too) --> And it works
but
2-) If I first select the Tab Folders ( browser mode) browse directories --> then do Tools\Search ---> then (the field : Filename is still blank but the field "Directory" is now not blank) --> And now it doesn't work

So this function only works if the field "Directory" is blank ! (even if "Match any of these following Conditions" is checked)

( I do not use special character in my search )
XnViewMP Linux X64 - Debian - X64
User avatar
xnview
Author of XnView
Posts: 37889
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by xnview »

Ok, the problem is base pathname, pathname stored in DB is not correct...
Pierre.
User avatar
xnview
Author of XnView
Posts: 37889
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by xnview »

Please, could you test XnViewMP 0.25
Pierre.
User avatar
oops66
XnThusiast
Posts: 2005
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by oops66 »

xnview wrote:Please, could you test XnViewMP 0.25
I have tried the linux 0.25 version and the "Search by IPTC Keyword" problem remains.
It's even worst because I can not perform a data-base search and I can not see now the thumbnails when I use by hand from the Xnview browser "Categories Tab\Categories\Others\ mouse-select a custom IPTC keyword " (thumbs are blank)
FI: I have deleted my old XnView.db file
XnViewMP Linux X64 - Debian - X64
User avatar
xnview
Author of XnView
Posts: 37889
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by xnview »

oops66 wrote:
xnview wrote:Please, could you test XnViewMP 0.25
I have tried the linux 0.25 version and the "Search by IPTC Keyword" problem remains.
It's even worst because I can not perform a data-base search and I can not see now the thumbnails when I use by hand from the Xnview browser "Categories Tab\Categories\Others\ mouse-select a custom IPTC keyword " (thumbs are blank)
FI: I have deleted my old XnView.db file
Could you send me a folder with some samples to test (like you)?
Pierre.
User avatar
oops66
XnThusiast
Posts: 2005
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by oops66 »

Hello Pierre,
Ok, but I plan to do some others more accurate tests before.

edit - strange: I have deleted my old xnview.ini file to have a fresh ini file, & a new time the XnView.db file, and the behavior is now different:
The "Search by IPTC Keyword" problem remains.
But now I can see the thumbnails when I use by hand from the Xnview browser "Categories Tab\Categories\Others\ mouse-select a custom IPTC keyword "...

Edit1: I have sent you some jpg samples with IPTC keywords by e-mail
XnViewMP Linux X64 - Debian - X64
User avatar
xnview
Author of XnView
Posts: 37889
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by xnview »

Ok, i've used your picture files.
You need to 'any of' because you search not the full keyword, but a word
Pierre.
User avatar
oops66
XnThusiast
Posts: 2005
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by oops66 »

I have tried both without success ...
I have sent you a new e-mail to explain the issue

Edit1: about the empty thumbnails, this bug occurs if the option is different of Options\Cache DB\Base path of your picture = /
like:
Options\Cache DB\Base path of your picture = /home/user1/albums/
maybe dues to 2 different partitions root / and /home, or the 2 folders names: Home & home into XnViewMP Browser ???

Edit2: Almost Fixed into the 0.26 XnViewMP Linux version - Tx
But the "Options\Cache DB\Base path of your picture" issue remains (see my e-mail)
XnViewMP Linux X64 - Debian - X64