Comment 4 for bug 488428

Revision history for this message
zvpunry (miloeffler) wrote :

I had the same error message (on debian sid). But i found the problem in the database:

i stopped f-spot an then:

cd ~/.config/f-spot/
cp -a photos.db photos.db.backup
sqlite3 photos.db .dump > photos.db.dump
rm photos.db
sqlite3 photos.db < photos.db.dump
Error: near line 13669: constraint failed

then i looked at line 13669 and found this: INSERT INTO "photo_versions" VALUES(NULL,NULL,NULL,NULL,NULL,NULL,NULL);

i deleted that statement and restored the db again (without error), and now it works again.