Ubuntu
tracker package

Incorrect parameter order for SetOption

Bug #324300 reported by TJ
4
Affects Status Importance Assigned to Milestone
Tracker
Fix Released
High
tracker (Ubuntu)
Fix Released
Low
Unassigned

Bug Description

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';"

Revision history for this message
TJ (tj) wrote :

The debdiff patches include the fix for bug #324227 Configuration file mis-spells "Divisions" as "Dvisions"

Revision history for this message
TJ (tj) wrote :
Revision history for this message
TJ (tj) wrote :
Revision history for this message
TJ (tj) wrote :
Pedro Villavicencio (pedro)
Changed in tracker:
importance: Undecided → Low
status: New → Triaged
Bug Watch Updater (bug-watch-updater)
Changed in tracker:
status: Unknown → Fix Released
Revision history for this message
Martin Mai (mrkanister-deactivatedaccount-deactivatedaccount) wrote :

This is fixed in Jaunty now. Thanks for reporting. If you need a fix for the bug in previous versions of Ubuntu, please follow the instructions for "How to request new packages" at https://help.ubuntu.com/community/UbuntuBackports#request-new-packages

Changed in tracker:
status: Triaged → Fix Released
Revision history for this message
Martin Mai (mrkanister-deactivatedaccount-deactivatedaccount) wrote :

And thank you very much for the patch :)

Bug Watch Updater (bug-watch-updater)
Changed in tracker:
importance: Unknown → High
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.