openlp-core team mailing list archive

[John Cegalis <830662@xxxxxxxxxxxxxxxxxx>]

build 1786
Started getting full books "in the beginning" (Genesis). Made it to 1Kings and got this.


Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openlp/plugins/bibles/lib/mediaitem.py", line 643, in onAdvancedSearchButton
    self.search_results = self.plugin.manager.get_verses(bible, versetext)
  File "/usr/lib/pymodules/python2.7/openlp/plugins/bibles/lib/manager.py", line 309, in get_verses
    return self.db_cache[bible].get_verses(reflist, show_error)
  File "/usr/lib/pymodules/python2.7/openlp/plugins/bibles/lib/http.py", line 498, in get_verses
    search_results.verselist)
  File "/usr/lib/pymodules/python2.7/openlp/plugins/bibles/lib/db.py", line 244, in create_chapter
    self.session.commit()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/scoping.py", line 139, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 614, in commit
    self.transaction.commit()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 385, in commit
    self._prepare_impl()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 369, in _prepare_impl
    self.session.flush()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1400, in flush
    self._flush(objects)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1481, in _flush
    flush_context.execute()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 302, in execute
    rec.execute(self)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 446, in execute
    uow
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 1887, in _save_obj
    execute(statement, params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1191, in execute
    params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1271, in _execute_clauseelement
    return self.__execute_context(context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1302, in __execute_context
    context.parameters[0], context=context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1401, in _cursor_execute
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1394, in _cursor_execute
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 299, in do_execute
    cursor.execute(statement, parameters)
DatabaseError: (DatabaseError) database disk image is malformed u'INSERT INTO verse (book_id, chapter, verse, text) VALUES (?, ?, ?, ?)' (11, 2, 1, u' When the time drew near for David to die, he gave a charge to Solomon his son. ')

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

Title:
  NIV 2010 traceback

Status in OpenLP - Worship Presentation Software:
  Incomplete

Bug description:
  Web Bible download. I got to 1 Samuel getting the whole book and got
  this.

  Traceback (most recent call last):
    File "/home/john/Projects/openlp/trunk/openlp/plugins/bibles/lib/mediaitem.py", line 640, in onAdvancedSearchButton
      self.search_results = self.plugin.manager.get_verses(bible, versetext)
    File "/home/john/Projects/openlp/trunk/openlp/plugins/bibles/lib/manager.py", line 309, in get_verses
      return self.db_cache[bible].get_verses(reflist, show_error)
    File "/home/john/Projects/openlp/trunk/openlp/plugins/bibles/lib/http.py", line 495, in get_verses
      search_results.verselist)
    File "/home/john/Projects/openlp/trunk/openlp/plugins/bibles/lib/db.py", line 245, in create_chapter
      self.session.commit()
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/scoping.py", line 132, in do
      return getattr(self.registry(), name)(*args, **kwargs)
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 595, in commit
      self.transaction.commit()
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 367, in commit
      self._prepare_impl()
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 351, in _prepare_impl
      self.session.flush()
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1359, in flush
      self._flush(objects)
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1440, in _flush
      flush_context.execute()
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 299, in execute
      rec.execute(self)
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 443, in execute
      uow
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 1863, in _save_obj
      execute(statement, params)
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1194, in execute
      params)
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1274, in _execute_clauseelement
      return self.__execute_context(context)
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1305, in __execute_context
      context.parameters[0], context=context)
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1404, in _cursor_execute
      context)
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1397, in _cursor_execute
      context)
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 299, in do_execute
      cursor.execute(statement, parameters)
  DatabaseError: (DatabaseError) database disk image is malformed u'INSERT INTO verse (book_id, chapter, verse, text) VALUES (?, ?, ?, ?)' (10, 1, 1, u' After the death of Saul, David returned from striking down the Amalekites and stayed in Ziklag two days. ')

To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/830662/+subscriptions