NIV 2010 traceback

[John Cegalis]

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. ')

[Andreas Preikschat (googol-deactivatedaccount)]

Can you actually reproduce this? Because I guess that the donwload somehow failed causing a broken database.

[John Cegalis (jseagull1)]

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. ')

[Andreas Preikschat (googol-deactivatedaccount)]

I am pretty sure that this is not our fault, that is why I close this one.

http://www.sqlite.org/lockingv3.html#how_to_corrupt