MP LINUX v0.21 - Search into database

[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.php?f=74&t=18433&p=77820#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.

[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?

[oops66]

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 "

[JohnFredC]

A other important thing: it's better to have by default the criteria: "=Contains" instead "=is "

Maybe...

[xnview]

Is it possible to have some files? And which search?

[oops66]

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 ?

[xnview]

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?

[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 )

[xnview]

Ok, the problem is base pathname, pathname stored in DB is not correct...