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.
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.