Bug 331844 - Broken f-spot db prevents photo import
Summary: Broken f-spot db prevents photo import
Status: RESOLVED DUPLICATE of bug 327122
Alias: None
Product: openSUSE 10.3
Classification: openSUSE
Component: GNOME (show other bugs)
Version: Final
Hardware: Other Other
: P5 - None : Major (vote)
Target Milestone: ---
Assignee: Larry Ewing
QA Contact: E-mail List
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-10-08 15:37 UTC by Boyd Timothy
Modified: 2007-10-24 14:33 UTC (History)
0 users

See Also:
Found By: ---
Services Priority:
Business Priority:
Blocker: ---
Marketing QA Status: ---
IT Deployment: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***