[KPhotoAlbum] kpaxml2mysql.py fails on my DB

Shawn Willden shawn-kimdaba at willden.org
Tue Apr 24 23:01:32 BST 2007

On Tuesday 24 April 2007 03:30:37 pm Tuomas Suutari wrote:
> Instead compile KPA with SQL support and you'll get a meny item:
> Maintenance -> Convert backend.

Okay, that also fails with "error while executing SQL statement".  The last 
statements printed to the console were:

Executing query: SELECT id FROM category WHERE name='Tokens'
Executing query: SELECT id FROM tag WHERE categoryId=1 AND name=NULL
Executing statement: INSERT INTO tag(categoryId, name) VALUES (1, NULL)

So, it looks like the error is because the 'name' column is not nullable, 
which seems eminently reasonable but raises the question of how I could have 
a tag in my XML file with a null name.  Looks like maybe it's in the Tokens 
category?  Time to fire up the debugger...


More information about the Kphotoalbum mailing list