openlp-core team mailing list archive

[Raoul Snyman <raoul.snyman@xxxxxxxxxxxxxxxxxxxxxxxx>]

Bug report from http://support.openlp.org/issues/43

** Tags added: bible-import

** Tags added: csv-bible

-- 
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/687309

Title:
  CSV Bible import fails in 1.9.3

Status in OpenLP - Worship Presentation Software:
  New

Bug description:
  While trying to import a Bible into version 1.9.3 I got the following 
error message:

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.bibles.forms.importwizardform", 
line 256, in onCurrentIdChanged
File "c:\Documents and Settings\raoul\My Documents\My 
Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.forms.importwizardform", 
line 408, in performImport
File "c:\Documents and Settings\raoul\My Documents\My 
Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.lib.manager", 
line 178, in import_bible
File "c:\Documents and Settings\raoul\My Documents\My 
Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.lib.db", 
line 203, in register
File "c:\Documents and Settings\raoul\My Documents\My 
Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.lib.db", 
line 293, in create_meta
File "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_object
File "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 do
File "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 commit
File "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 commit
File "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_impl
File "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 flush
File "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 _flush
File "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 execute
File "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 execute
File "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_steps
File "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_objects
File "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_obj
File "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 execute
File "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_clauseelement
File "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_context
File "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_execute
File "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_exception
IntegrityError: (IntegrityError) column key is not unique u'INSERT INTO 
metadata ("key", value) VALUES (?, ?)' [u'dbversion', u'2']

This appeared immediately after entering the file names and pressing the "go" button.

I have sucessfully imported the CSV file into version 1.x of openLP.