MP LINUX v0.25 - Search into database

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

Moderator: Dreamer

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

MP LINUX v0.25 - Search into database

Post by oops66 » Sat Oct 17, 2009 1:28 pm

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 0.82 Linux X64 - Ubuntu 16.04 LTS - X64

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

Re: MP LINUX v0.21 - Search into database

Post by xnview » Thu Nov 19, 2009 1:48 pm

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: 1999
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by oops66 » Thu Nov 19, 2009 2:19 pm

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 0.82 Linux X64 - Ubuntu 16.04 LTS - 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 » Thu Nov 19, 2009 6:41 pm

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: 33337
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: MP LINUX v0.21 - Search into database

Post by xnview » Fri Nov 20, 2009 1:02 pm

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

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

Re: MP LINUX v0.21 - Search into database

Post by oops66 » Fri Nov 20, 2009 1:32 pm

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 0.82 Linux X64 - Ubuntu 16.04 LTS - X64

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

Re: MP LINUX v0.21 - Search into database

Post by xnview » Fri Nov 20, 2009 1:56 pm

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: 1999
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by oops66 » Fri Nov 20, 2009 3:06 pm

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 0.82 Linux X64 - Ubuntu 16.04 LTS - X64

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

Re: MP LINUX v0.21 - Search into database

Post by xnview » Mon Nov 23, 2009 9:31 am

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

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

Re: MP LINUX v0.21 - Search into database

Post by xnview » Tue Mar 16, 2010 8:27 pm

Please, could you test XnViewMP 0.25
Pierre.

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

Re: MP LINUX v0.21 - Search into database

Post by oops66 » Tue Mar 16, 2010 10:48 pm

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 0.82 Linux X64 - Ubuntu 16.04 LTS - X64

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

Re: MP LINUX v0.21 - Search into database

Post by xnview » Wed Mar 17, 2010 8:21 am

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: 1999
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by oops66 » Sat Mar 20, 2010 8:20 pm

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 0.82 Linux X64 - Ubuntu 16.04 LTS - X64

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

Re: MP LINUX v0.21 - Search into database

Post by xnview » Mon Mar 22, 2010 12:45 pm

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: 1999
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Re: MP LINUX v0.21 - Search into database

Post by oops66 » Tue Mar 30, 2010 10:51 pm

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 0.82 Linux X64 - Ubuntu 16.04 LTS - X64

Post Reply