openlp-core team mailing list archive
-
openlp-core team
-
Mailing list archive
-
Message #12995
[Bug 863845] Re: Crash upon using the OpenLP 2 importer with newer databases
The song import still does not work with newer song databases (well only
tested with the Russian song database in the First Time Wizard).
**OpenLP Bug Report**
Version: {u'full': u'1.9.7-bzr1812', u'version': u'1.9.7', u'build': u'bzr1812'}
--- Exception Traceback ---
Traceback (most recent call last):
File "/home/andreas/Projekte/openlp/trunk/openlp/core/ui/mainwindow.py", line 783, in onFirstTimeWizardClicked
self.firstTime()
File "/home/andreas/Projekte/openlp/trunk/openlp/core/ui/mainwindow.py", line 755, in firstTime
plugin.firstTime()
File "/home/andreas/Projekte/openlp/trunk/openlp/plugins/songs/songsplugin.py", line 255, in firstTime
importer.doImport()
File "/home/andreas/Projekte/openlp/trunk/openlp/plugins/songs/lib/olpimport.py", line 164, in doImport
source_songs = self.sourceSession.query(OldSong).all()
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py", line 113, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 917, in query
return self._query_cls(entities, self, **kwargs)
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 106, in __init__
self._set_entities(entities)
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 115, in _set_entities
self._setup_aliasizers(self._entities)
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 130, in _setup_aliasizers
_entity_info(entity)
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/util.py", line 476, in _entity_info
mapperlib.configure_mappers()
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py", line 2742, in configure_mappers
mapper._post_configure_properties()
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/mapper.py", line 1048, in _post_configure_properties
prop.init()
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/interfaces.py", line 121, in init
self.do_init()
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/properties.py", line 904, in do_init
self._determine_joins()
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/properties.py", line 1041, in _determine_joins
% self)
ArgumentError: Could not determine join condition between parent/child tables on relationship OldSong.media_files. Specify a 'primaryjoin' expression. If 'secondary' is present, 'secondaryjoin' is needed as well.
--- System information ---
Platform: Linux-3.1.4-1-ARCH-i686-Intel-R-_Pentium-R-_4_CPU_1.80GHz-with-glibc2.0
--- Library Versions ---
Python: 2.7.2
Qt4: 4.7.4
Phonon: 4.5.1
PyQt4: 4.8.6
SQLAlchemy: 0.7.2
SQLAlchemy Migrate: 0.7.1
BeautifulSoup: 3.2.0
lxml: 2.3.1
Chardet: 2.0.1
PyEnchant: 1.6.5
PySQLite: 1.0.1
Mako: 0.5.0
pyUNO bridge: 3.4
** Changed in: openlp
Status: Fix Released => Confirmed
--
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/863845
Title:
Crash upon using the OpenLP 2 importer with newer databases
Status in OpenLP - Worship Presentation Software:
Confirmed
Bug description:
Hello,
When you attempt to import a newer database with the OpenLP 2
importer, the following traceback is shown (this included the Russian
sample songs database).
**OpenLP Bug Report**
Version: {u'full': u'1.9.7-bzr1765', u'version': u'1.9.7', u'build': u'bzr1765'}
--- Exception Traceback ---
Traceback (most recent call last):
File "/home/andreas/Projekte/openlp/trunk/openlp/core/ui/mainwindow.py", line 780, in onFirstTimeWizardClicked
self.firstTime()
File "/home/andreas/Projekte/openlp/trunk/openlp/core/ui/mainwindow.py", line 752, in firstTime
plugin.firstTime()
File "/home/andreas/Projekte/openlp/trunk/openlp/plugins/songs/songsplugin.py", line 255, in firstTime
importer.doImport()
File "/home/andreas/Projekte/openlp/trunk/openlp/plugins/songs/lib/olpimport.py", line 127, in doImport
source_meta.tables[u'media_files_songs']
KeyError: u'media_files_songs'
--- System information ---
Plattform: Linux-3.0-ARCH-i686-Intel-R-_Pentium-R-_4_CPU_1.80GHz-with-glibc2.0
--- Library Versions ---
Python: 2.7.2
Qt4: 4.7.4
Phonon: 4.5.55
PyQt4: 4.8.5
SQLAlchemy: 0.7.2
BeautifulSoup: 3.2.0
lxml: 2.3.0
Chardet: 2.0.1
PyEnchant: 1.6.3
PySQLite: 1.0.1
To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/863845/+subscriptions
References