[ubuntu-mono] [Bug 636819] Re: F-spot error: Value is greater than Int32.MaxValue or less than Int32.MinValue

[Mirek]

I can confirm that changing future date (whose timestamp is greater than 32 bit signed integer) to smaller value solves the problem.
To change the date, edit FSpot database (in my case it was ~/.config/f-spot/photos.db) with sqlite manager and execute the following query:

update photos set time=[new_timestamp_which_is_less_then_max_int32]
where id=[id_of_photo_in_question]

If you have many photos with wrong timestamp, you can try to modify the
above query to update all of them at once e.g.:

update photos set time=[new_timestamp_which_is_less_then_max_int32]
where time > 2000000000

-- 
F-spot error: Value is greater than Int32.MaxValue or less than Int32.MinValue
https://bugs.launchpad.net/bugs/636819
You received this bug notification because you are a member of Ubuntu
CLI/Mono Uploaders, which is subscribed to f-spot in ubuntu.

Status in “f-spot” package in Ubuntu: New

Bug description:
Binary package hint: f-spot

When I open f-spot before I can use it I get this error:

An unhandled exception was thrown: 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 

.NET Version: 2.0.50727.1433
OS Version: Unix 2.6.35.20

Assembly Version Information:

glade-sharp (2.12.0.0)
FSpot.Bling (0.7.0.0)
TagLib (0.7.0.0)
pango-sharp (2.12.0.0)
FSpot.Query (0.7.0.0)
gtk-sharp-beans (2.14.0.0)
gnome-sharp (2.24.0.0)
System.Transactions (2.0.0.0)
System.Data (2.0.0.0)
Mono.Data.Sqlite (0.7.0.0)
Hyena.Data.Sqlite (0.7.0.0)
FSpot.JobScheduler (0.7.0.0)
System.Core (3.5.0.0)
unique-sharp (1.0.0.0)
System.Configuration (2.0.0.0)
FSpot.Gui (0.7.0.0)
System.Xml (2.0.0.0)
Mono.Addins (0.4.0.0)
Mono.Addins.Setup (0.4.0.0)
gconf-sharp (2.24.0.0)
Hyena.Gui (0.7.0.0)
atk-sharp (2.12.0.0)
System (2.0.0.0)
gtk-sharp (2.12.0.0)
FSpot.Cms (0.7.0.0)
FSpot.Core (0.7.0.0)
FSpot.Platform (0.7.0.0)
Mono.Posix (2.0.0.0)
gdk-sharp (2.12.0.0)
Hyena (0.7.0.0)
glib-sharp (2.12.0.0)
FSpot.Utils (0.7.0.0)
f-spot (0.7.0.0)
mscorlib (2.0.0.0)

Platform Information: Linux 2.6.35-20-generic x86_64 unknown GNU/Linux

Disribution Information:

[/etc/lsb-release]
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=10.10
DISTRIB_CODENAME=maverick
DISTRIB_DESCRIPTION="Ubuntu maverick (development branch)"

[/etc/debian_version]
squeeze/sid

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: f-spot 0.7.2-1
ProcVersionSignature: Ubuntu 2.6.35-20.29-generic 2.6.35.4
Uname: Linux 2.6.35-20-generic x86_64
NonfreeKernelModules: wl
Architecture: amd64
Date: Mon Sep 13 07:12:44 2010
ExecutablePath: /usr/lib/f-spot/f-spot.exe
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
InterpreterPath: /usr/bin/mono
ProcEnviron:
 SHELL=/bin/bash
 LANG=en_US.UTF-8
SourcePackage: f-spot