[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