← Back to team overview

openlp-core team mailing list archive

[Bug 722834] Re: opensong bible import crashes

 

I tried to use the built in converter in openlp 1.9.4 and this http://www.opensong.org/d/_media/svf_reviderad.zip bible and got this error "Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.6/openlp/core/ui/wizard.py", line 159, in onCurrentIdChanged
    self.performWizard()
  File "/usr/lib/pymodules/python2.6/openlp/plugins/bibles/forms/bibleimportform.py", line 719, in performWizard
    filename=unicode(self.field(u'opensong_file').toString())
  File "/usr/lib/pymodules/python2.6/openlp/plugins/bibles/lib/manager.py", line 197, in import_bible
    name = importer.register(self.import_wizard)
  File "/usr/lib/pymodules/python2.6/openlp/plugins/bibles/lib/db.py", line 208, in register
    self.create_meta(u'dbversion', u'2')
  File "/usr/lib/pymodules/python2.6/openlp/plugins/bibles/lib/db.py", line 304, in create_meta
    self.save_object(BibleMeta.populate(key=key, value=value))
  File "/usr/lib/pymodules/python2.6/openlp/core/lib/db.py", line 149, in save_object
    self.session.commit()
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/scoping.py", line 127, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 671, in commit
    self.transaction.commit()
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 378, in commit
    self._prepare_impl()
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 362, in _prepare_impl
    self.session.flush()
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 1354, in flush
    self._flush(objects)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 1432, in _flush
    flush_context.execute()
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/unitofwork.py", line 261, in execute
    UOWExecutor().execute(self, tasks)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/unitofwork.py", line 753, in execute
    self.execute_save_steps(trans, task)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/unitofwork.py", line 768, in execute_save_steps
    self.save_objects(trans, task)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/unitofwork.py", line 759, in save_objects
    task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/mapper.py", line 1428, in _save_obj
    c = connection.execute(statement.values(value_params), params)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 824, in execute
    return Connection.executors[c](self, object, multiparams, params)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 874, in _execute_clauseelement
    return self.__execute_context(context)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 896, in __execute_context
    self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 950, in _cursor_execute
    self._handle_dbapi_exception(e, statement, parameters, cursor, context)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 931, in _handle_dbapi_exception
    raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect)
IntegrityError: (IntegrityError) column key is not unique u'INSERT INTO metadata ("key", value) VALUES (?, ?)' [u'dbversion', u'2']"

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

Title:
  opensong bible import crashes

Status in OpenLP - Worship Presentation Software:
  New

Bug description:
  When I try to import a opensong bible the guide seems to be fine but
  when it start to import it crashes



References