[KPhotoAlbum] exif/exiv issue with stadler debian build

Mark Eichin eichin at gmail.com
Thu Jul 9 21:06:49 CEST 2009

Even worse, I did a "mv exif-info.db pre-k4-exif-info.db", started
kphotoalbum, it imported some pictures, created a fresh
exif-info.db... and *still* gave

Error running query: INSERT into exif values (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?)
Error was: constraint failed Unable to fetch row

for each picture... running sqlite3 .schema on the new file gives:

CREATE TABLE exif (filename string PRIMARY KEY, Exif_Photo_FocalLength
float, Exif_Photo_ExposureTime float, Exif_Photo_ApertureValue float,
Exif_Photo_FNumber float, Exif_Photo_Flash int, Exif_Photo_Contrast
int, Exif_Photo_Sharpness int, Exif_Photo_Saturation int,
Exif_Image_Orientation int, Exif_Photo_MeteringMode int,
Exif_Photo_ISOSpeedRatings int, Exif_Photo_ExposureProgram int,
Exif_Image_Make string, Exif_Image_Model string );

which is at least the right number of columns... also, other than
PRIMARY KEY I don't see any constraints, and a .dump gives a number of

PowerShot SX10 IS');

(the hex does encode to a valid filename and is one of the new
imports... so apparently I'm getting errors but it is importing them
anyway? maybe it's trying to load them twice or something?)

On Mon, Jul 6, 2009 at 12:59 AM, Mark Eichin<eichin at gmail.com> wrote:
> Oh, huh, I actually can cut&paste from the error dialog:
> There was an error while executing the SQL backend command. The error
> is likely due to a broken database file.
> To fix this problem run Maintainance->Rebuild EXIF database.
> For debugging, this is the command I tried to execute:
> INSERT into exif values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
> This was the error message I got:
> Parameter count mismatch

_Mark_ <eichin at thok.org> <eichin at gmail.com>

More information about the KPhotoAlbum mailing list