<p>I am upgrading to OpenLP 1.9.3 from 1.9.2 and have been unable to convert my song dB. When I follow the instructions to convert the song database to 1.9.3 using the Import feature, an "error occurred" box comes up. When I click on it to continue, it hangs up midway through the import. Although I let it go for some time, I finally have to cancel the process and a 2nd "error occurred" box comes up. The text of the 2 error messages follows. </p>
<p>I have twice tried to convert my song dB with the same results, and right now I have no songs in OpenLP 1.9.3.</p>
<p>1ST ERROR: Traceback (most recent call last): File "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.songs.forms.songimportform", line 356, in onCurrentIdChangedFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.songs.forms.songimportform", line 451, in performImportFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.songs.lib.olpimport", line 218, in do_importFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.core.lib.db", line 152, in save_objectFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.scoping", line 127, in doFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 671, in commitFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 378, in commitFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 362, in _prepare_implFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 1354, in flushFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 1432, in _flushFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.unitofwork", line 261, in executeFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.unitofwork", line 753, in executeFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.unitofwork", line 768, in execute_save_stepsFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.unitofwork", line 759, in save_objectsFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.mapper", line 1428, in _save_objFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 824, in executeFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 874, in _execute_clauseelementFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 896, in __execute_contextFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 950, in _cursor_executeFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 931, in _handle_dbapi_exceptionOperationalError: (OperationalError) unable to open database file u'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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' [0, u'My Jesus I Love Thee', u'', u'<?xml version="1.0" encoding="utf-8"?><song version="1.0"><lyrics language="en"><verse label="1" type="Verse"><![CDATA[Verse 1\r\nMy Jesus I love Thee I know Thou art mine\r\nFor Thee all the follies of sin I resign]]></verse><verse label="2" type="Verse"><![CDATA[My gracious Redeemer my Savior art Thou\r\nIf ever I loved Thee my Jesus \'tis now]]></verse><verse label="3" type="Verse"><![CDATA[Verse 2\r\nI love Thee because Thou hast first loved me\r\nAnd purchased my pardon on Calvary\'s tree]]></verse><verse label="4" type="Verse"><![CDATA[I love Thee for wearing the thorns on Thy brow\r\nIf ever I loved Thee my Jesus \'tis now]]></verse><verse label="5" type="Verse"><![CDATA[Verse 3\r\nI\'ll love Thee in life I will love Thee in death\r\nAnd praise Thee as long as Thou lendest me breath]]></verse><verse label="6" type="Verse"><![CDATA[And say when the death-dew lies cold on my brow\r\nIf ever I loved Thee my Jesus \'tis now]]></verse><verse label="7" type="Verse"><![CDATA[Verse 4\r\nIn mansions of glory and endless delight\r\nI\'ll ever adore Thee in heaven so bright]]></verse><verse label="8" type="Verse"><![CDATA[I\'ll sing with the glittering crown on my brow\r\nIf ever I loved Thee my Jesus \'tis now]]></verse></lyrics></song>', u'', u'Hymn # 382', u'', u'', u'', u'', u'My Jesus I Love Thee@', u'Verse 1 My Jesus I love Thee I know Thou art mine For Thee all the follies of sin I resign My gracious Redeemer my Savior art Thou If ever I loved Thee my Jesus tis now Verse 2 I love Thee because Thou hast first loved me And purchased my pardon on Calvary s tree I love Thee for wearing the thorns on Thy brow If ever I loved Thee my Jesus tis now Verse 3 I ll love Thee in life I will love Thee in death And praise Thee as long as Thou lendest me breath And say when the death dew lies cold on my brow If ever I loved Thee my Jesus tis now Verse 4 In mansions of glory and endless delight I ll ever adore Thee in heaven so bright I ll sing with the glittering crown on my brow If ever I loved Thee my Jesus tis now ']</p>
<p>2ND ERROR: Traceback (most recent call last):File "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.songs.lib.mediaitem", line 170, in onSearchTextButtonClickFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.core.lib.db", line 205, in get_all_objectsFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.query", line 1267, in allFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.query", line 1361, in iterFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.query", line 1364, in _execute_and_instancesFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 752, in executeFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 717, in __connectionFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 312, in _connection_for_bindFile "c:\Documents and Settings\raoul\My Documents\My Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 247, in _assert_is_activeInvalidRequestError: The transaction is inactive due to a rollback in a subtransaction. Issue rollback() to cancel the transaction.</p>