Public bug reported:

Binary package hint: tracker

Affects: Gutsy Hardy Intrepid Jaunty

The sqlite stored procedure defined in data/sqlite-stored-procs.sql

SetOption REPLACE into Options (OptionKey, OptionValue) values (?,?);

is incorrectly called from src/trackerd/tracker-db-
sqlite.c::tracker_db_set_option_string()

        tracker_exec_proc (db_con->common, "SetOption", 2, value,
option);

parameters 'value' and 'option' order is back-to-front.

The sqlite database at ~/.local/share/tracker/data/common.db has the
table "Options" with two columns: OptionKey, OptionValue and the system
*tries* to store the "IntegrityCheck" option but puts the key in the
OptionValue column.

To remove the incorrect values from the database use the command:

sqlite3 ~/.local/share/tracker/data/common.db "delete from Options where
OptionValue='IntegrityCheck';"

** Affects: tracker
     Importance: Unknown
         Status: Unknown

** Affects: tracker (Ubuntu)
     Importance: Undecided
         Status: New

** Bug watch added: GNOME Bug Tracker #570209
   http://bugzilla.gnome.org/show_bug.cgi?id=570209

** Also affects: tracker via
   http://bugzilla.gnome.org/show_bug.cgi?id=570209
   Importance: Unknown
       Status: Unknown

-- 
Incorrect parameter order for SetOption
https://bugs.launchpad.net/bugs/324300
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to