[KPhotoAlbum] sql problem (?)
Jesper K. Pedersen
blackie at blackie.dk
Fri Apr 14 06:52:35 BST 2006
I've tried reproducing this without any luck.
Might it be that you've tried an older snapshot of KPhotoAlbum, at a time,
where I had one less entry in the database.
Could you please try and delete the file exif-info.db located in the same
directory as your index.xml, and tell me if you still see the error after
this.
Cheers
Jesper.
On Sunday 09 April 2006 15:57, Mark Zealey wrote:
| oh sorry I missed the error line:
|
| Error running query: INSERT into exif values ('/home/mark/images/2005
| China/Ruth''s pictures/p8300020.jpg', 11.8, 0.046337, -1, 4.1, 16, 0, 0, 0,
| 1, 2, 128, 2, 'OLYMPUS_IMAGING_CORP. ', 'X450,D535Z,C370Z')
| Error was: table exif has 16 columns but 15 values were supplied Unable to
| execute statement
|
|
| Mark
|
| On Sunday 09 April 2006 1:44 pm, Robert L Krawitz wrote:
| > From: Mark Zealey <mspam at zealey.org>
| > Date: Sun, 9 Apr 2006 13:33:32 +0100
| >
| > Hi, when I run kphotoalbum 2nd April snapshot I get tonnes of messages
| > like:
| >
| > Error running query: INSERT into exif values ('/home/mark/images/2005
| > China/Ruth''s pictures/p8300022.jpg', 7.2, 0.029496, -1, 3.2, 16, 0,
| > 0, 0, 1, 2, 128, 2, 'OLYMPUS_IMAGING_CORP. ', 'X450,D535Z,C370Z')
| >
| > Is this a problem with my setup or ?
| >
| > My SWAG is that you have something named
| >
| > /home/mark/images/2005China/Ruth's pictures/p8300022.jpg
| >
| > The "'" apparently isn't being quoted correctly by KPhotoAlbum.
--
Jesper K. Pedersen | Klarälvdalens Datakonsult
Senior Software Engineer | www.klaralvdalens-datakonsult.se
Prinsensgade 4a st. |
9800 Hjørring | Platform-independent
Denmark | software solutions
More information about the Kphotoalbum
mailing list