← Back to team overview

openlp-core team mailing list archive

[Bug 1590657] [NEW] MediaShout import causes traceback

 

Public bug reported:

Original reported here:
https://support.openlp.org/scp/tickets.php?id=3531

The problem seems to be that we expect a "Themes" table to be available,
but it isn't in this case.

**OpenLP Bug Report**
Version: {'build': None, 'full': '2.4.1', 'version': '2.4.1'}

--- Details of the Exception. ---

Trying to import songs from Mediashout 6 song database.

 --- Exception Traceback ---
Traceback (most recent call last):
  File "openlp\core\ui\wizard.py", line 216, in on_current_id_changed
  File "openlp\plugins\songs\forms\songimportform.py", line 351, in perform_wizard
  File "openlp\plugins\songs\lib\importers\mediashout.py", line 70, in do_import
pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Themes'.  Make sure it exists and that its name is spelled correctly. (-1305) (SQLExecDirectW)")

--- System information ---
Platform: Windows-7-6.1.7601-SP1

--- Library Versions ---
Python: 3.4.4
Qt5: 5.5.1
PyQt5: 5.5.1
QtWebkit: 538.1
SQLAlchemy: 1.0.11
SQLAlchemy Migrate: -
BeautifulSoup: 4.4.1
lxml: 3.4.4
Chardet: 2.3.0
PyEnchant: 1.6.6
Mako: 1.0.3
pyICU: 1.9.2
pyUNO bridge: -
VLC: -

** Affects: openlp
     Importance: Medium
         Status: Confirmed

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

Title:
  MediaShout import causes traceback

Status in OpenLP:
  Confirmed

Bug description:
  Original reported here:
  https://support.openlp.org/scp/tickets.php?id=3531

  The problem seems to be that we expect a "Themes" table to be
  available, but it isn't in this case.

  **OpenLP Bug Report**
  Version: {'build': None, 'full': '2.4.1', 'version': '2.4.1'}

  --- Details of the Exception. ---

  Trying to import songs from Mediashout 6 song database.

   --- Exception Traceback ---
  Traceback (most recent call last):
    File "openlp\core\ui\wizard.py", line 216, in on_current_id_changed
    File "openlp\plugins\songs\forms\songimportform.py", line 351, in perform_wizard
    File "openlp\plugins\songs\lib\importers\mediashout.py", line 70, in do_import
  pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Themes'.  Make sure it exists and that its name is spelled correctly. (-1305) (SQLExecDirectW)")

  --- System information ---
  Platform: Windows-7-6.1.7601-SP1

  --- Library Versions ---
  Python: 3.4.4
  Qt5: 5.5.1
  PyQt5: 5.5.1
  QtWebkit: 538.1
  SQLAlchemy: 1.0.11
  SQLAlchemy Migrate: -
  BeautifulSoup: 4.4.1
  lxml: 3.4.4
  Chardet: 2.3.0
  PyEnchant: 1.6.6
  Mako: 1.0.3
  pyICU: 1.9.2
  pyUNO bridge: -
  VLC: -

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


Follow ups