[KPhotoAlbum] EXIF DB questions
tobias.leupold at web.de
Sat Aug 29 16:57:29 CEST 2015
> Can you show me the output of the following commands?
> sqlite3 exif-info.db 'select * from settings;'
> sqlite3 exif-info.db .schema
CREATE TABLE settings (keyword TEXT PRIMARY KEY, value TEXT) without rowid;
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, Exif_GPSInfo_GPSVersionID int, Exif_GPSInfo_GPSAltitude float,
Exif_GPSInfo_GPSAltitudeRef int, Exif_GPSInfo_GPSMeasureMode string,
Exif_GPSInfo_GPSDOP float, Exif_GPSInfo_GPSImgDirection float,
Exif_GPSInfo_GPSLatitude float, Exif_GPSInfo_GPSLatitudeRef string,
Exif_GPSInfo_GPSLongitude float, Exif_GPSInfo_GPSLongitudeRef string,
Exif_GPSInfo_GPSTimeStamp float , Exif_Photo_LensModel string);
> Maybe you have filenames that are somehow interpreted as being the same when
> you use the c locale. I guess this doesn't happen with a locale of
With LC_ALL=en_US.utf8, this does not happen, but the UI is still German ...
> Maybe you can get a more descriptive error message using sqlite. Can you try
> running some queries (e.g. 'select filename from exif;') using the C locale
> with sqlite? Maybe the sqlite client prints a more detailed error message
> containing the keys that are deemed not unique...
With "select filename from exif;", I get the very same output, no matter if I
use my normal locale or C. Anway, it seems to be only a small subset of my
images in the EXIF db, I only get 897 entries, but I have 8521 images ...
Well, could it be that my EXIF db is abit messed up? I'm using git master KPA
for my real collection if I mess with it ...
More information about the KPhotoAlbum