<p>DonP again,</p>
<p>Just looked at the data and a thought struck me, does all of the names of the books have to be in quotes.</p>
<p>So I tried it with all text in quotes and ran the 1.2.1 version again, this time i just got a message saying, "There was a problem importing the books: SQL Logic Error or missing database" The remainder of the original error message was gone.</p>
<p>So I ran the 1.9.5 version again with the same test data and got a traceback message as follows. By the way, I notice mentions of drive d\ in the traceback, this drive on my system is my DVD player.</p>
<p>Traceback (most recent call last):</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.core.ui.wizard", line 160, in onCurrentIdChanged</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.forms.bibleimportform", line 714, in performWizard</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.lib.manager", line 191, in import_bible</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.lib.db", line 210, in register</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.lib.db", line 306, in create_meta</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.core.lib.db", line 150, in save_object</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.scoping", line 139, in do</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 614, in commit</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 385, in commit</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 369, in _prepare_impl</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 1388, in flush</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", line 1469, in _flush</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.unitofwork", line 302, in execute</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.unitofwork", line 446, in execute</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.mapper", line 1878, in _save_obj</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1191, in execute</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1271, in _execute_clauseelement</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1302, in __execute_context</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1401, in _cursor_execute</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", line 1394, in _cursor_execute</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">File "d:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.default", line 299, in do_execute</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0;">IntegrityError: (IntegrityError) column key is not unique u'INSERT INTO metadata ("key", value) VALUES (?, ?)' (u'dbversion', u'2')</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0; -qt-paragraph-type: empty;"> </p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0; -qt-paragraph-type: empty;">Hope this all helps to find out what I am doing wrong.</p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0; -qt-paragraph-type: empty;"> </p>
<p style="text-indent: 0px; margin: 0px; -qt-block-indent: 0; -qt-paragraph-type: empty;">DonP.</p>