Comment 1 for bug 863845

Revision history for this message
Andreas Preikschat (googol-deactivatedaccount) wrote :

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