[KPhotoAlbum] sql problem (?)

[Mark Zealey]

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.

-- 

Mark Zealey
http://mark.zealey.org  (Diary at http://mark.zealey.org/diary)