OpenLP

MediaShout import causes traceback

Bug #1590657 reported by Tomas Groth
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenLP
Fix Released
Medium
Tomas Groth

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: -

Related branches

lp:~tomasgroth/openlp/25bugfixes3
Raoul Snyman: Approve
Diff: 263 lines (+81/-24)
9 files modified
openlp/plugins/songs/lib/importers/mediashout.py (+18/-11)
openlp/plugins/songs/lib/importers/opspro.py (+3/-3)
openlp/plugins/songs/lib/importers/presentationmanager.py (+7/-1)
openlp/plugins/songs/lib/importers/songpro.py (+1/-1)
openlp/plugins/songs/lib/importers/songshowplus.py (+10/-4)
openlp/plugins/songs/lib/importers/videopsalm.py (+1/-3)
openlp/plugins/songs/lib/importers/worshipcenterpro.py (+1/-1)
tests/functional/openlp_plugins/songs/test_songshowplusimport.py (+2/-0)
tests/resources/songshowplussongs/cleanse-me.json (+38/-0)
lp:openlp
lp:~tomasgroth/openlp/24bugfix-backport3
Raoul Snyman: Approve
Diff: 134 lines (+60/-6)
6 files modified
openlp/plugins/songs/lib/importers/mediashout.py (+5/-3)
openlp/plugins/songs/lib/importers/presentationmanager.py (+7/-1)
openlp/plugins/songs/lib/importers/songshowplus.py (+7/-1)
openlp/plugins/songs/lib/importers/videopsalm.py (+1/-1)
tests/functional/openlp_plugins/songs/test_songshowplusimport.py (+2/-0)
tests/resources/songshowplussongs/cleanse-me.json (+38/-0)
Superseded for merging into lp:openlp
OpenLP Core: Pending requested
Diff: 120157 lines (+92605/-12402) (has conflicts)
60 files modified
openlp/.version (+1/-1)
openlp/core/__init__.py (+4/-4)
openlp/core/lib/projector/pjlink1.py (+27/-0)
openlp/core/lib/spelltextedit.py.OTHER (+204/-0)
openlp/core/resources.py (+87433/-9326)
openlp/core/ui/exceptionform.py (+7/-0)
openlp/core/ui/servicemanager.py (+7/-0)
openlp/core/utils/__init__.py.OTHER (+543/-0)
openlp/plugins/bibles/lib/mediaitem.py (+8/-0)
openlp/plugins/presentations/lib/pdfcontroller.py (+22/-0)
openlp/plugins/remotes/lib/remotetab.py (+12/-0)
openlp/plugins/songs/forms/editsongform.py (+16/-1)
openlp/plugins/songs/lib/importers/easyworship.py (+32/-0)
openlp/plugins/songs/lib/importers/mediashout.py (+7/-0)
openlp/plugins/songs/lib/importers/openlp.py (+5/-0)
openlp/plugins/songs/lib/importers/videopsalm.py (+6/-0)
openlp/plugins/songs/lib/mediaitem.py (+26/-0)
resources/i18n/af.ts (+90/-68)
resources/i18n/bg.ts (+113/-91)
resources/i18n/cs.ts (+93/-69)
resources/i18n/da.ts (+91/-69)
resources/i18n/de.ts (+93/-69)
resources/i18n/el.ts (+90/-68)
resources/i18n/en.ts (+92/-68)
resources/i18n/en_GB.ts (+92/-68)
resources/i18n/en_ZA.ts (+90/-68)
resources/i18n/es.ts (+113/-89)
resources/i18n/et.ts (+90/-68)
resources/i18n/fi.ts (+104/-76)
resources/i18n/fr.ts (+90/-68)
resources/i18n/hu.ts (+93/-69)
resources/i18n/id.ts (+90/-68)
resources/i18n/ja.ts (+90/-68)
resources/i18n/ko.ts (+372/-335)
resources/i18n/lt.ts (+688/-649)
resources/i18n/nb.ts (+95/-71)
resources/i18n/nl.ts (+90/-68)
resources/i18n/pl.ts (+90/-68)
resources/i18n/pt_BR.ts (+292/-257)
resources/i18n/ru.ts (+90/-68)
resources/i18n/sk.ts (+93/-69)
resources/i18n/sv.ts (+90/-68)
resources/i18n/ta_LK.ts (+90/-68)
resources/i18n/th_TH.ts (+90/-68)
resources/i18n/zh_CN.ts (+90/-68)
resources/i18n/zh_TW.ts (+90/-68)
scripts/translation_utils.py (+4/-0)
tests/functional/openlp_core_lib/test_htmlbuilder.py (+25/-0)
tests/functional/openlp_core_lib/test_projector_pjlink1.py (+17/-0)
tests/functional/openlp_core_ui/test_firsttimeform.py (+20/-0)
tests/functional/openlp_core_ui/test_generaltab.py (+54/-0)
tests/functional/openlp_core_ui/test_themetab.py (+84/-0)
tests/functional/openlp_plugins/presentations/test_pdfcontroller.py (+74/-0)
tests/functional/openlp_plugins/remotes/test_router.py (+23/-0)
tests/functional/openlp_plugins/songs/test_lib.py (+27/-0)
tests/functional/openlp_plugins/songs/test_openlpimporter.py (+75/-0)
tests/interfaces/openlp_core_lib/test_pluginmanager.py (+10/-0)
tests/interfaces/openlp_plugins/custom/forms/test_customform.py (+19/-0)
tests/resources/songshowplussongs/cleanse-me.json (+38/-0)
tests/utils/test_bzr_tags.py (+1/-1)
lp:openlp/2.4
Revision history for this message
Raoul Snyman (raoul-snyman) wrote :

I have the database (it's 50MB). Let me know if you're working on this and you want to test it out.

Tomas Groth (tomasgroth)
Changed in openlp:
assignee: nobody → Tomas Groth (tomasgroth)
status: Confirmed → In Progress
Tomas Groth (tomasgroth)
Changed in openlp:
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.