GNOME Bugzilla – Bug 635340
exception after import
Last modified: 2010-11-23 02:22:03 UTC
After importing some pictures, f-spot exited and no longer starts up. The following output is shown when starting from a terminal: airzimmy@asus:~$ f-spot [Info 10:18:13.284] Initializing Mono.Addins Value is greater than Int32.MaxValue or less than Int32.MinValue System.OverflowException: Value is greater than Int32.MaxValue or less than Int32.MinValue at System.Convert.ToInt32 (Int64 value) [0x00000] in <filename unknown>:0 at System.Int64.System.IConvertible.ToInt32 (IFormatProvider provider) [0x00000] in <filename unknown>:0 at System.Convert.ToType (System.Object value, System.Type conversionType, IFormatProvider provider, Boolean try_target_to_type) [0x00000] in <filename unknown>:0 at System.Convert.ChangeType (System.Object value, System.Type conversionType, IFormatProvider provider) [0x00000] in <filename unknown>:0 at Mono.Data.Sqlite.Sqlite3.GetValue (Mono.Data.Sqlite.SqliteStatement stmt, Int32 index, Mono.Data.Sqlite.SqliteType typ) [0x00000] in <filename unknown>:0 at Mono.Data.Sqlite.SqliteDataReader.GetValue (Int32 i) [0x00000] in <filename unknown>:0 at Hyena.Data.Sqlite.HyenaSqliteArrayDataReader.ReadAllRows (Mono.Data.Sqlite.SqliteDataReader reader) [0x00000] in <filename unknown>:0 at Hyena.Data.Sqlite.HyenaSqliteArrayDataReader..ctor (Mono.Data.Sqlite.SqliteDataReader reader) [0x00000] in <filename unknown>:0 at (wrapper remoting-invoke-with-check) Hyena.Data.Sqlite.HyenaSqliteArrayDataReader:.ctor (Mono.Data.Sqlite.SqliteDataReader) at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection, Mono.Data.Sqlite.SqliteConnection connection) [0x00000] in <filename unknown>:0 Exception in Gtk# callback delegate Note: Applications can use GLib.ExceptionManager.UnhandledException to handle the exception. System.ArgumentOutOfRangeException: Argument is out of range. Parameter name: Parameters describe an unrepresentable DateTime. at System.DateTime..ctor (Int32 year, Int32 month, Int32 day, Int32 hour, Int32 minute, Int32 second, Int32 millisecond) [0x00000] in <filename unknown>:0 at System.DateTime..ctor (Int32 year, Int32 month, Int32 day) [0x00000] in <filename unknown>:0 at FSpot.TimeAdaptor.DateFromIndexAscending (Int32 item) [0x00000] in <filename unknown>:0 at FSpot.TimeAdaptor.DateFromIndex (Int32 item) [0x00000] in <filename unknown>:0 at FSpot.TimeAdaptor.TickLabel (Int32 item) [0x00000] in <filename unknown>:0 at FSpot.GroupSelector.HandleAdaptorChanged (FSpot.GroupAdaptor adaptor) [0x00000] in <filename unknown>:0 at (wrapper delegate-invoke) FSpot.GroupAdaptor/ChangedHandler:invoke_void__this___GroupAdaptor (FSpot.GroupAdaptor) at FSpot.TimeAdaptor+<DoReload>c__AnonStorey19.<>m__6B () [0x00000] in <filename unknown>:0 at FSpot.Driver+<RunIdle>c__AnonStorey11.<>m__50 () [0x00000] in <filename unknown>:0 at GLib.Idle+IdleProxy.Handler () [0x00000] in <filename unknown>:0 at GLib.ExceptionManager.RaiseUnhandledException(System.Exception e, Boolean is_terminal) at GLib.Idle+IdleProxy.Handler() at Gtk.Dialog.gtk_dialog_run(IntPtr ) at Gtk.Dialog.Run() at Hyena.Gui.CleanRoomStartup.Startup(Hyena.Gui.StartupInvocationHandler startup) at FSpot.Driver.Main(System.String[] args) airzimmy@asus:~$ f-spot -version F-Spot 0.8.0 http://f-spot.org (c)2003-2009, Novell Inc (c)2009 Stephane Delcroix Personal photo management for the GNOME Desktop airzimmy@asus:~$ cat /etc/lsb-release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=10.10 DISTRIB_CODENAME=maverick DISTRIB_DESCRIPTION="Ubuntu 10.10"
As mentioned in https://bugzilla.gnome.org/show_bug.cgi?id=626699#c13 I executed the commands: echo 'update photos set time=-2147483647 where time<-2147483647;' | sqlite3 \ ~/.config/f-spot/photos.db echo 'update photos set time=2147483647 where time>2147483647;' | sqlite3 \ ~/.config/f-spot/photos.db F-spot was able to start up. I did another import and had the same issue, again had to do the update of time, of course, the time is screwed now ...
As mentioned this is a duplicate. *** This bug has been marked as a duplicate of bug 626699 ***