Hello, Updated the 'shared-mime-info' package to 0.71 version, now the actual mime type is returned by 'g_file_info_get_content_type()' and also in the properties of the document the actual mime type is shown.
Thanks, Murugappan N. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of ext [email protected] Sent: Thursday, August 26, 2010 4:10 PM To: [email protected] Subject: tracker-list Digest, Vol 54, Issue 18 Send tracker-list mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://mail.gnome.org/mailman/listinfo/tracker-list or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of tracker-list digest..." Today's Topics: 1. Re: some files not indexed (Martyn Russell) 2. Re: sparql: Could not run update, constraint failed (database corruption?) (Mildred Ki'Lya) 3. Re: search by words in file names (Tshepang Lekhonkhobe) 4. Re: search by words in file names (Aleksander Morgado) 5. Problem with Mime type of PPSX file ([email protected]) ---------------------------------------------------------------------- Message: 1 Date: Wed, 25 Aug 2010 14:20:42 +0100 From: Martyn Russell <[email protected]> To: Mildred Ki'Lya <[email protected]> Cc: [email protected] Subject: Re: [Tracker] some files not indexed Message-ID: <[email protected]> Content-Type: text/plain; charset=UTF-8; format=flowed On 25/08/10 09:44, Mildred Ki'Lya wrote: > On 2010-08-25 10:13, Mildred Ki'Lya wrote: >> Yesterday, I restarted Tracker, it replayed the journal and the >> filesystem miner took a long time to index everything again (it seems). >> I don't understand why it missed some files. I don't have anything in >> the tracker-extract or tracker-miner-fs log and raised the kernel limit >> for inotify. > > > Errata: there are log messages. > Strangely enough, the tail -f on the log file didn't display the > messages when they happened. Now that I just cat the log file, I can see > them. A lot of error are about wrong sparql syntax and errors in queries. > > I have to test the queries my extractor generates, is there a way to > execute long sparql queries easily? tracker-sparql takes the query from > the command line, but I'm not sure my shell will accept, can it take > commands from the standard input ? Yes, tracker-sparql -f <file-with-sparql-in-it> See tracker-sparql --help or man tracker-sparql for more details. -- Regards, Martyn ------------------------------ Message: 2 Date: Wed, 25 Aug 2010 16:04:43 +0200 From: Mildred Ki'Lya <[email protected]> To: [email protected] Subject: Re: [Tracker] sparql: Could not run update, constraint failed (database corruption?) Message-ID: <[email protected]> Content-Type: text/plain; charset="utf-8" I could fix the database apparently: $ sqlite3 ~/.cache/tracker/meta.db SQLite version 3.6.22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> DELETE FROM "nco:EmailAddress" ...> WHERE "nco:emailAddress" = "[email protected]"; sqlite> .q And now it works. My theory about the problem is that the nco:EmailAddress existed but wasn't referenced anywhere. It should have been garbage collected. And thus, when I want to assign this email address to an existing nco:Contact, tracker tried to create a new nco:EmailAddress even though it already existed. In the SQLite database, the nco:EmailAddress table is as follows: CREATE TABLE "nco:EmailAddress" ( ID INTEGER NOT NULL PRIMARY KEY, "nco:emailAddress" TEXT UNIQUE, "nco:emailAddress:graph" INTEGER); The nco:emailAddress is set to UNIQUE. SQLite complained and Tracker failed to complete the transaction. It seems my database is full of these quirks, is there a way to run a garbage collector on it? It seems it's just a matter of running the following request on each of the ontology tables: DELETE FROM "nco:EmailAddress" WHERE ID NOT IN (SELECT ID FROM Resource); Can someone confirm this ? Anyway, it worked for my email addresses. Mildred -- Mildred Ki'Lya ?????????? ???????????????????? ?????????? ? Jabber, GoogleTalk: <[email protected]> ? Website: <http://ki.lya.online.fr> GPG ID: 9A7D 2E2B ? Fingerprint: 197C A7E6 645B 4299 6D37 684B 6F9D A8D6 9A7D 2E2B -------------- next part -------------- A non-text attachment was scrubbed... Name: 0x9A7D2E2B.asc Type: application/pgp-keys Size: 10035 bytes Desc: not available URL: <http://mail.gnome.org/archives/tracker-list/attachments/20100825/bb8d0fa4/attachment.bin> ------------------------------ Message: 3 Date: Wed, 25 Aug 2010 17:07:58 +0200 From: Tshepang Lekhonkhobe <[email protected]> To: Thibaud Hulin <[email protected]> Cc: [email protected] Subject: Re: [Tracker] search by words in file names Message-ID: <[email protected]> Content-Type: text/plain; charset=UTF-8 On Wed, Aug 25, 2010 at 12:54, Thibaud Hulin <[email protected]> wrote: > Hi, > Thanks for this excellent work with tracker. > I'm testing the 0.8.15 version with ubuntu lucid with tracker-search, but I > can't find documents like I want. For example, I'm looking for > "hamster-applet.txt". > When I type "hamster", I found my file. > When I type "applet", I don't found my file. > My bloc-notes is organized with files.txt, so it's important for me to > access to them by name files. > I have too tags in my notes, just a line with "{{tag>gnome applet }}", but > it would be probably more complicate to access them with this way that with > name files. > Best regards, > Thibaud. It's a missing feature and I don't know what it will take for Tracker devs to realise it's important enough to add. The difficulty has to do with some limitations of FTS, which someone else suggested a workaround for using regexps (but I can't find a link to that). -- blog: http://tshepang.tumblr.com ------------------------------ Message: 4 Date: Wed, 25 Aug 2010 17:20:03 +0200 From: Aleksander Morgado <[email protected]> To: Tshepang Lekhonkhobe <[email protected]> Cc: [email protected] Subject: Re: [Tracker] search by words in file names Message-ID: <1282749603.1921.1.ca...@currupipi-ubuntu> Content-Type: text/plain; charset="UTF-8" > > Thanks for this excellent work with tracker. > > I'm testing the 0.8.15 version with ubuntu lucid with tracker-search, but I > > can't find documents like I want. For example, I'm looking for > > "hamster-applet.txt". > > When I type "hamster", I found my file. > > When I type "applet", I don't found my file. > > My bloc-notes is organized with files.txt, so it's important for me to > > access to them by name files. > > I have too tags in my notes, just a line with "{{tag>gnome applet }}", but > > it would be probably more complicate to access them with this way that with > > name files. > > Best regards, > > Thibaud. > > It's a missing feature and I don't know what it will take for Tracker > devs to realise it's important enough to add. The difficulty has to do > with some limitations of FTS, which someone else suggested a > workaround for using regexps (but I can't find a link to that). > > We actually already realized that it's quite important to have non-prefix FTS searches, but the implementation is far from trivial, so probably not happening soon... :-/ -- Aleksander ------------------------------ Message: 5 Date: Thu, 26 Aug 2010 12:38:31 +0200 From: <[email protected]> To: <[email protected]> Subject: [Tracker] Problem with Mime type of PPSX file Message-ID: <b4d9c3e13918644d8a7f22d8f47154b12d5daa9...@nok-eumsg-03.mgdnok.nokia.com> Content-Type: text/plain; charset="us-ascii" Hello, I'm working on implementing the tracker plug-in for 'PPSX' file. I'm facing the following problem can anyone please provide some suggestion: The actual MIME type for PPSX file is "application/vnd.openxmlformats-officedocument.presentationml.slideshow". * In Tracker the mime type for PPSX file is returned as "application/zip" by 'g_file_info_get_content_type()' API instead of the actual mime type * Even in the Properties of the document, the mime type is shown as "application/zip" (right click on the file and selecting the 'Properties' to see the mime type) Attaching a sample PPSX file. Thank you Aleksander for providing the mailing list id. Thanks, Murugappan N. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mail.gnome.org/archives/tracker-list/attachments/20100826/20fe8f93/attachment.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: Presentation1.ppsx Type: application/vnd.openxmlformats-officedocument.presentationml.slideshow Size: 133597 bytes Desc: Presentation1.ppsx URL: <http://mail.gnome.org/archives/tracker-list/attachments/20100826/20fe8f93/attachment.bin> ------------------------------ _______________________________________________ tracker-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/tracker-list End of tracker-list Digest, Vol 54, Issue 18 ******************************************** _______________________________________________ tracker-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/tracker-list
