Can't import webbible

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

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/wizard.py", line 228, in on_current_id_changed
    self.perform_wizard()
  File "/home/sim/dev/openlp/trunk/openlp/plugins/bibles/forms/bibleimportform.py", 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/http.py", 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/mixins.py", line 67, in wrapped
    raise e
  File "/home/sim/dev/openlp/trunk/openlp/core/common/mixins.py", line 60, in wrapped
    return func(*args, **kwargs)
  File "/home/sim/dev/openlp/trunk/openlp/plugins/bibles/lib/bibleimport.py", 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/db.py", 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/db.py", 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/mediaitem.py", line 570, in on_version_combo_box_index_changed
    self.initialise_advanced_bible(self.select_book_combo_box.currentData())
  File "/home/sim/dev/openlp/bible-improvements/openlp/plugins/bibles/lib/mediaitem.py", line 390, in initialise_advanced_bible
    log.debug('initialise_advanced_bible {bible}, {ref}'.format(bible=self.bible.name, 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