Bug 331844

Summary:	Broken f-spot db prevents photo import
Product:	[openSUSE] openSUSE 10.3	Reporter:	Boyd Timothy <btimothy>
Component:	GNOME	Assignee:	Larry Ewing <lewing>
Status:	RESOLVED DUPLICATE	QA Contact:	E-mail List <qa-bugs>
Severity:	Major
Priority:	P5 - None
Version:	Final
Target Milestone:	---
Hardware:	Other
OS:	Other
Whiteboard:
Found By:	---	Services Priority:
Business Priority:		Blocker:	---
Marketing QA Status:	---	IT Deployment:	---

Description Boyd Timothy 2007-10-08 15:37:43 UTC

I plugged-in my Canon Digital Rebel XTi (400D) and the import photo dialog appeared.  When selecting the "Import Photo" button, nothing appeared to happen (i.e., f-spot never opened).

Under further investigation, I tried to start f-spot from a command-line.  It wouldn't start because a bunch of other f-spot processes were already running (I tried the importing multiple times).  After "killall f-spot", I started it again from the command-line and got an error: Unhandled Exception: Mono.Data.SqliteClient.SqliteSyntaxException: file is encrypted or is not a database

lewing let me know that I should install sqlite2 and run: f-spot-sqlite-upgrade

After doing that, f-spot loads.  And, when plugging my camera in, I am now able to run the importer (via ptp) successfully.  I'm not sure how a non-techie user would ever figure out how to do this.

Comment 1 Boyd Timothy 2007-10-17 19:37:34 UTC

Looks like upgrading photos.db from SLED 10 SP1 -> openSUSE 10.3 works fine.

Out of curiosity, I tried the following:

1. Opened f-spot on a clean SLED 10 SP1 machine
2. Imported a couple photos
3. Copied ~/Photos/ to a clean openSUSE 10.3 machine
4. Copied ~/.gnome2/f-spot/photos.db to openSUSE 10.3
5. Launched f-spot on openSUSE 10.3 from a terminal window and got this output:

boyd@bht-opensuse-vm:~> f-spot
Initializing Mono.Addins
Starting new FSpot server
Updating F-Spot Database
Updated database from version 3 to 3.1
Updated database from version 3.1 to 4
Will add a roll_id field to photos!
Will rename imports to rolls!
Cleaning weird descriptions, fixes bug #324425.
Updated database from version 4 to 5
Updated database from version 5 to 6
Database updates completed successfully.

Comment 2 JP Rosevear 2007-10-24 14:33:42 UTC


*** This bug has been marked as a duplicate of bug 327122 ***