GNOME Bugzilla – Bug 390176
Can't edit icon for tag
Last modified: 2007-01-09 18:01:02 UTC
I get an error/crash when I right click on a tag, select "Edit tag" and then click on the icon. Here's the error message: An unhandled exception was thrown: near "AND": syntax error at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (IntPtr pzStart, System.IntPtr& pzTail, System.IntPtr& pStmt) [0x00000] at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior, Boolean want_results, System.Int32& rows_affected) [0x00000] at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader () [0x00000] at PhotoStore.Query (System.String query) [0x00000] at PhotoStore.Query (.Tag[] tags, System.String extra_condition, .DateRange range) [0x00000] at FSpot.PhotoQuery.RequestReload () [0x00000] at FSpot.PhotoQuery.set_Tags (.Tag[] value) [0x00000] at TagCommands+EditIcon.Execute (.Tag t) [0x00000] at TagCommands+Edit.HandleIconButtonClicked (System.Object sender, System.EventArgs args) [0x00000] at (wrapper delegate-invoke) System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs) at GLib.Signal.voidObjectCallback (IntPtr handle, IntPtr gch) [0x00000] at (wrapper native-to-managed) GLib.Signal:voidObjectCallback (intptr,intptr) at <0x00000> <unknown method> at (wrapper managed-to-native) Gtk.Dialog:gtk_dialog_run (intptr) at Gtk.Dialog.Run () [0x00000] at TagCommands+Edit.Execute (.Tag t) [0x00000] at MainWindow.HandleEditSelectedTagWithTag (.Tag tag) [0x00000] at TagPopup+<>c__CompilerGenerated9.<>c__AnonymousMethod31 (System.Object +23, System.EventArgs +24) [0x00000] at (wrapper delegate-invoke) System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs) at GLib.Signal.voidObjectCallback (IntPtr handle, IntPtr gch) [0x00000] at (wrapper native-to-managed) GLib.Signal:voidObjectCallback (intptr,intptr) at <0x00000> <unknown method> at (wrapper managed-to-native) Gtk.Application:gtk_main () at Gtk.Application.Run () [0x00000] at Gnome.Program.Run () [0x00000] at FSpot.Driver.Main (System.String[] args) [0x00000] .NET Version: 2.0.50727.42 Assembly Version Information: FlickrNet (1.1.0.0) google-sharp (0.1.0.0) pango-sharp (2.10.0.0) SemWeb (0.7.1.0) glade-sharp (2.10.0.0) gtkhtml-sharp (2.16.0.0) gconf-sharp (2.16.0.0) System.Data (2.0.0.0) Mono.Data.SqliteClient (2.0.0.0) gdk-sharp (2.10.0.0) gnome-vfs-sharp (2.16.0.0) NDesk.DBus (0.0.0.0) System (2.0.0.0) Mono.Posix (2.0.0.0) NDesk.DBus.GLib (0.0.0.0) atk-sharp (2.10.0.0) gtk-sharp (2.10.0.0) glib-sharp (2.10.0.0) gnome-sharp (2.16.0.0) f-spot (0.3.0.0) Mono.GetOptions (2.0.0.0) mscorlib (2.0.0.0) Platform Information: Linux 2.6.20-2-generic i686 unknown GNU/Linux Distribution Information: [/etc/debian_version] 4.0 [/etc/lsb-release] DISTRIB_ID=Ubuntu DISTRIB_RELEASE=7.04 DISTRIB_CODENAME=feisty DISTRIB_DESCRIPTION="Ubuntu feisty (development branch)"
I also get the same problem with Edgy (backported f-spot 0.3.0 to it).
*** Bug 393054 has been marked as a duplicate of this bug. ***
*** Bug 394431 has been marked as a duplicate of this bug. ***
As reported in bug #394431, this also happens when deleting a tag with no icon associated.
additional comment: it only happens with top-level tags
(forget about the previous comments, I think I really found out this time) Matthew, Bruce, Dotan and others: you removed your 'Hidden' tag, right ?
I committed a patch in r2679 which should fix this. Test it, and re-open if you still have an issue.
Stephane, as you have already discovered, the problem is not restricted to top-level tags. And yes, I have removed the Hidden tag. I can't test the patch now, but I will soon. Thanks for all your hard work.