openlp-core team mailing list archive

[Andreas Preikschat <863845@xxxxxxxxxxxxxxxxxx>]

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