[ubuntu-mono] [Bug 653327] Re: f-spot crashes when image has wrong date

[OblongCheese]

You can fix this problem temporarily by taking the following action:

1. Backup your photos.db, usually located in $HOME/.config/f-spot/photos.db
2. Install sqlite3 (apt-get install sqlite3)
3. Run: sqlite3 $HOME/.config/f-spot/photos.db
4. To find out which files are broken, do: select * from photos where date<0 - this will list all the photos with a negative number as the date (aka corrupt dates)
5. Then do: delete from photos where date<0 - this will delete all records from the database which reference photos with a corrupt date. F-Spot will not work again, but obviously won't have the affected photos in the database.

-- 
You received this bug notification because you are a member of Ubuntu
CLI/Mono Uploaders, which is subscribed to f-spot in ubuntu.
https://bugs.launchpad.net/bugs/653327

Title:
  f-spot crashes when image has wrong date

Status in Personal photo management for the GNOME desktop:
  Unknown
Status in “f-spot” package in Ubuntu:
  Confirmed

Bug description:
  Binary package hint: f-spot

  f-spot crashes when the gallery contains an image which has an invalid date. f-spot can not be started / crashes on each start.
  This should be handled and not result in an application crash.

  Exception in Gtk# callback delegate
    Note: Applications can use GLib.ExceptionManager.UnhandledException to handle the exception.
  System.ArgumentOutOfRangeException: Argument is out of range.
    at System.DateTime.DaysInMonth (Int32 year, Int32 month) [0x00000] in <filename unknown>:0 
    at FSpot.TimeAdaptor.DateFromIndexDescending (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.Application.gtk_main()
     at Gtk.Application.Run()
     at FSpot.Driver.Startup()
     at Hyena.Gui.CleanRoomStartup.Startup(Hyena.Gui.StartupInvocationHandler startup)
     at FSpot.Driver.Main(System.String[] args)