openlp-core team mailing list archive

[John Cegalis <687309@xxxxxxxxxxxxxxxxxx>]

1251 build on Kubuntu 10.10
When importing csv book and verse, it got to Revelation and this traceback came up. 

--- Exception Traceback ---
Traceback (most recent call last):
File "/usr/lib/pymodules/python2.6/openlp/core/ui/wizard.py", line 136, in onCurrentIdChanged
self.performWizard()
File "/usr/lib/pymodules/python2.6/openlp/plugins/bibles/forms/bibleimportform.py", line 850, in performWizard
if importer.do_import():
File "/usr/lib/pymodules/python2.6/openlp/plugins/bibles/lib/csvbible.py", line 175, in do_import
if book_ptr != book_list[int(line[0])]:
ValueError: invalid literal for int() with base 10: 'Genesis'

--- System information ---
Platform: Linux-2.6.35-25-generic-x86_64-with-Ubuntu-10.10-maverick
Desktop: KDE SC

--- Library Versions ---
Python: 2.6.6
Qt4: 4.7.0
Phonon: 4.4.4
PyQt4: 4.8.1
SQLAlchemy: 0.6.3
BeautifulSoup: 3.1.0.1
lxml: 2.2.6
Chardet: 2.0.1
PyEnchant: 1.5.3
PySQLite: -

-- 
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:
  Fix Released

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.