Comment 2 for bug 714510

Latest windows exe 1301 now gets further. Program starts and database tables are created.

However when I tried to save a new song with new author:

Traceback (most recent call last):
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.songs.forms.editsongform", line 659, in accept
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.songs.forms.editsongform", line 712, in saveSong
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.core.lib.db", line 149, in save_object
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.scoping", line 139, in do
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 623, in commit
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 385, in commit
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 369, in _prepare_impl
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 1397, in flush
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 1478, in _flush
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.unitofwork", line 304, in execute
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.unitofwork", line 448, in execute
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.mapper", line 1872, in _save_obj
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1191, in execute
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1271, in _execute_clauseelement
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1302, in __execute_context
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1401, in _cursor_execute
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1394, in _cursor_execute
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.default", line 299, in do_execute
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/MySQLdb.cursors", line 174, in execute
  File "C:\Documents and Settings\raoul\My Documents\My Projects\openlp\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/MySQLdb.connections", line 36, in defaulterrorhandler
IntegrityError: (IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails ("test"."songs", CONSTRAINT "songs_ibfk_1" FOREIGN KEY ("song_book_id") REFERENCES "song_books" ("id"))') 'INSERT INTO songs (song_book_id, title, alternate_title, lyrics, verse_order, copyright, comments, ccli_number, song_number, theme_name, search_title, search_lyrics) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' (0, 'title', 'alternate', '<?xml version=\'1.0\' encoding=\'UTF-8\'?>\n<song version="1.0"><lyrics><verse type="Verse" label="1"><![CDATA[lyrics]]></verse></lyrics></song>', '', '', '', '', '', None, 'title@alternate', 'lyrics ')