After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 390176 - Can't edit icon for tag
Can't edit icon for tag
Status: RESOLVED FIXED
Product: f-spot
Classification: Other
Component: Tags
0.3.0
Other Linux
: Normal normal
: ---
Assigned To: F-spot maintainers
F-spot maintainers
: 393054 394431 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2006-12-27 23:35 UTC by Matthew East
Modified: 2007-01-09 18:01 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Matthew East 2006-12-27 23:35:15 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)"
Comment 1 Bruce Cowan 2007-01-04 21:33:18 UTC
I also get the same problem with Edgy (backported f-spot 0.3.0 to it).
Comment 2 Stephane Delcroix 2007-01-05 09:03:01 UTC
*** Bug 393054 has been marked as a duplicate of this bug. ***
Comment 3 Stephane Delcroix 2007-01-09 08:34:19 UTC
*** Bug 394431 has been marked as a duplicate of this bug. ***
Comment 4 Stephane Delcroix 2007-01-09 08:35:17 UTC
As reported in bug #394431, this also happens when deleting a tag with no icon associated. 
Comment 5 Stephane Delcroix 2007-01-09 12:24:26 UTC
additional comment: it only happens with top-level tags
Comment 6 Stephane Delcroix 2007-01-09 12:51:24 UTC
(forget about the previous comments, I think I really found out this time)

Matthew, Bruce, Dotan and others: you removed your 'Hidden' tag, right ?
Comment 7 Stephane Delcroix 2007-01-09 12:59:21 UTC
I committed a patch in r2679 which should fix this. Test it, and re-open if you still have an issue.
Comment 8 Dotan Cohen 2007-01-09 18:01:02 UTC
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.