Bug 179983

Summary: f-spot crashes after yesterday's upgrade - fc5t2
Product: [Fedora] Fedora Reporter: Igor Jagec <igorm5>
Component: f-spotAssignee: Alexander Larsson <alexl>
Status: CLOSED RAWHIDE QA Contact:
Severity: medium Docs Contact:
Priority: medium    
Version: 5   
Target Milestone: ---   
Target Release: ---   
Hardware: i686   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2006-02-06 12:14:49 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Igor Jagec 2006-02-04 08:09:26 UTC 
From Bugzilla Helper:
User-Agent: Opera/8.51 (X11; Linux i686; U; en)

Description of problem:
The program just crashes after yesterday's upgrade on FC5t2. Here's the output:
$ f-spot
Starting new FSpot server

Unhandled Exception: Mono.Data.SqliteClient.SqliteSyntaxException: file is 
encrypted or is not a database
in [0x0007f] Mono.Data.SqliteClient.SqliteCommand:GetNextStatement (IntPtr 
pzStart, System.IntPtr pzTail, System.IntPtr pStmt)
in [0x00022] (at /usr/src/build/687862-i386/BUILD/mono-1.1.13.2/mcs/class/Mono.
Data.SqliteClient/Mono.Data.SqliteClient/SqliteCommand.cs:459) Mono.Data.
SqliteClient.SqliteCommand:ExecuteReader (CommandBehavior behavior, Boolean 
want_results, System.Int32 rows_affected)
in [0x00005] (at /usr/src/build/687862-i386/BUILD/mono-1.1.13.2/mcs/class/Mono.
Data.SqliteClient/Mono.Data.SqliteClient/SqliteCommand.cs:435) Mono.Data.
SqliteClient.SqliteCommand:ExecuteReader (CommandBehavior behavior)
in [0x00002] (at /usr/src/build/687862-i386/BUILD/mono-1.1.13.2/mcs/class/Mono.
Data.SqliteClient/Mono.Data.SqliteClient/SqliteCommand.cs:429) Mono.Data.
SqliteClient.SqliteCommand:ExecuteReader ()
in <0x00092> TagStore:LoadAllTags ()
in <0x0005c> TagStore:.ctor (Mono.Data.SqliteClient.SqliteConnection connection, 
Boolean is_new)
in <0x000c7> Db:.ctor (System.String path, Boolean create_if_missing)
in <0x002f1> Driver:Main (System.String[] args)
[ijagec@munja ~]$ rpm -q f-spot
f-spot-0.1.8-2
[ijagec@munja ~]$ uname -m
i686


Version-Release number of selected component (if applicable):
f-spot-0.1.8-2

How reproducible:
Always

Steps to Reproduce:
1.
2.
3.
  

Additional info:
Comment 1 Alexander Larsson 2006-02-06 12:14:49 UTC 
This is due to a switch from sqlite2 to sqlite3. You can use the sqlite and
sqlite3 programs to dump and restore ~/.gnome2/f-spot/photos.db converting it to
a n sqlite3 database. Or if you have no important data, just remove the db file
and reimport.

I know this is unfortunate, but we wanted to make this switch before the final
fc5, so we're not stuck with the old sqlite2 version forever.
Comment 2 Igor Jagec 2006-02-07 12:15:57 UTC 
It did help, thank you Alexander. I just removed ~/.gnome2/f-spot/photos.db 
file. Cheers!
Comment 3 Alexander Larsson 2006-02-20 09:50:49 UTC 
*** Bug 179984 has been marked as a duplicate of this bug. ***