Can't import webbible

Bug #1750447 reported by Simon Hanna on 2018-02-19
This bug affects 1 person
Affects Status Importance Assigned to Milestone

Bug Description

Starting with on openlp configs or data, adding a couple of non-english bibles in FTW and then importing a new bible. I just downloaded the list and went with what was chosen.

Here's the trace
Traceback (most recent call last):
  File "/home/sim/dev/openlp/trunk/openlp/core/widgets/", line 228, in on_current_id_changed
  File "/home/sim/dev/openlp/trunk/openlp/plugins/bibles/forms/", line 794, in perform_wizard
    if importer.do_import(license_version) and not importer.stop_import_flag:
  File "/home/sim/dev/openlp/trunk/openlp/plugins/bibles/lib/importers/", line 654, in do_import
    book_ref_id = self.get_book_ref_id_by_name(book, len(books), self.language_id)
  File "/home/sim/dev/openlp/trunk/openlp/core/common/", line 67, in wrapped
    raise e
  File "/home/sim/dev/openlp/trunk/openlp/core/common/", line 60, in wrapped
    return func(*args, **kwargs)
  File "/home/sim/dev/openlp/trunk/openlp/plugins/bibles/lib/", line 77, in get_book_ref_id_by_name
    book_id = AlternativeBookNamesDB.get_book_reference_id(book)
  File "/home/sim/dev/openlp/trunk/openlp/plugins/bibles/lib/", line 809, in get_book_reference_id
    'SELECT book_reference_id, name FROM alternative_book_names')
  File "/home/sim/dev/openlp/trunk/openlp/plugins/bibles/lib/", line 790, in run_sql
    cursor.execute(query, parameters)
sqlite3.OperationalError: no such table: alternative_book_names

I'm attaching a log

Related branches

Simon Hanna (thelinuxguy) wrote :
Simon Hanna (thelinuxguy) wrote :

English bibles also result in an exception

It imports fine but then this happens
Traceback (most recent call last):
  File "/home/sim/dev/openlp/bible-improvements/openlp/plugins/bibles/lib/", line 570, in on_version_combo_box_index_changed
  File "/home/sim/dev/openlp/bible-improvements/openlp/plugins/bibles/lib/", line 390, in initialise_advanced_bible
    log.debug('initialise_advanced_bible {bible}, {ref}'.format(, ref=last_book))
AttributeError: 'NoneType' object has no attribute 'name'

Phill (phill-ridout) on 2019-03-16
Changed in openlp:
status: New → In Progress
importance: Undecided → Medium
assignee: nobody → Phill (phill-ridout)
Phill (phill-ridout) on 2019-03-17
Changed in openlp:
status: In Progress → Fix Committed
Tim Bentley (trb143) on 2019-03-17
Changed in openlp:
milestone: none → 2.9.1
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Bug attachments