| Summary: | kphotoalbum failed to create database | ||
|---|---|---|---|
| Product: | [Applications] kphotoalbum | Reporter: | Manu <kde> |
| Component: | general | Assignee: | KPhotoAlbum Bugs <kphotoalbum-bugs-null> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | johannes |
| Priority: | NOR | ||
| Version First Reported In: | 5.3 | ||
| Target Milestone: | --- | ||
| Platform: | Ubuntu | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed/Implemented In: | ||
| Sentry Crash Report: | |||
|
Description
Manu
2018-08-13 21:45:09 UTC
Thanks for reporting this!
Can you show the file permissions for the exif database ("ls -l exif-info.db")?
Also, is there a stale kphotoalbum process still running on your system which could have locked the file?
Did you already try to remove the file and try again?
Regarding the mass of error messages: I can make this to be less annoying...
Hi,
1st i had to say that i don't have only one error but a lot (thousand of error : 2 or 3 per file). As a result kphotoalbum do not work properly.
I only send the 1st one because i think that every things will be ok when this one is solved.
$ ls -l exif-info.db
-rw-rw---- 1 emmanuel share.photo 0 août 14 00:00 exif-info.db
emmanuel is me and share.photo is the group who can access the photos
Please note that exif-info.db take place on and CIFS mounted drive.
I don't know how to place it somewhere else cause it don't ask it on startup.
There's no stale kphotoalbum process : ps aux | grep kphoto gives only one.
>>> Did you already try to remove the file and try again?
Yes i did, it do not change anything.
Here is other errors if it can help :
$ kphotoalbum
Icon theme "adwaita" not found.
kphotoalbum.Exif: Error running query: create table if not exists settings (keyword TEXT PRIMARY KEY, value TEXT) without rowid
Error was: database is locked Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: insert or replace into settings (keyword, value) values('DBVersion','3')
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: alter table exif add column Exif_GPSInfo_GPSVersionID int
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: alter table exif add column Exif_GPSInfo_GPSAltitude float
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: alter table exif add column Exif_GPSInfo_GPSAltitudeRef int
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: alter table exif add column Exif_GPSInfo_GPSMeasureMode string
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: alter table exif add column Exif_GPSInfo_GPSDOP float
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: alter table exif add column Exif_GPSInfo_GPSImgDirection float
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: alter table exif add column Exif_GPSInfo_GPSLatitude float
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: alter table exif add column Exif_GPSInfo_GPSLatitudeRef string
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: alter table exif add column Exif_GPSInfo_GPSLongitude float
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: alter table exif add column Exif_GPSInfo_GPSLongitudeRef string
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: alter table exif add column Exif_GPSInfo_GPSTimeStamp float
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: alter table exif add column Exif_Photo_LensModel string
Error was: Pas de requête Impossible de récupérer la ligne
kphotoalbum.Exif: Error running query: DELETE FROM exif WHERE fileName=?
Error was: Nombre de paramètres incorrect
kphotoalbum.Exif: Error running query: INSERT OR REPLACE into exif values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Error was: Nombre de paramètres incorrect
kphotoalbum.Exif: Error running query: DELETE FROM exif WHERE fileName=?
Error was: Nombre de paramètres incorrect
kphotoalbum.Exif: Error running query: INSERT OR REPLACE into exif values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Error was: Nombre de paramètres incorrect
kphotoalbum.Exif: Error running query: DELETE FROM exif WHERE fileName=?
Error was: Nombre de paramètres incorrect
kphotoalbum.Exif: Error running query: INSERT OR REPLACE into exif values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Error was: Nombre de paramètres incorrect
and it continues this way until the end of photo parsing.
Hi, i manage to recompile it from latest master. I got the same error. But when i added : set(CMAKE_BUILD_TYPE RelWithDebInfo) just after set(CMAKE_CXX_REQUIRED TRUE) to the file CMakelists.txt and rebuild all I do not longer have the problem and everything seams to work like a charm So, there's something really wreid there... Any idea on how i can find what's wrong ? Unfortunately, I can not recreate the problem, even with your additional information. For now, and mainly because you have found a suitable[1] workaround, I close this bug because it's likely some ephemeral combination of library versions and build flags that will be impossible to track down. [1] As a side not, "RelWithDebInfo" (or "Release") is usually preferred over the standard "empty" build type. |