openlp-core team mailing list archive

[Rastislav Pecik <863845@xxxxxxxxxxxxxxxxxx>]

I have just tested the import and it seems it does not work well. I have
tried it on the Ubuntu 11.10 machine with MySql backend (Mysql from
standard Ubuntu repositories) and the import from the old sqlite
database (that was used just before I have changed it to MySQL) has
resulted into following error (I am using special Slovak characters in
the songs). I have used the bazaar version 1823.

Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openlp/core/ui/wizard.py", line 191, in onCurrentIdChanged
    self.performWizard()
  File "/usr/lib/pymodules/python2.7/openlp/plugins/songs/forms/songimportform.py", line 764, in performWizard
    importer.doImport()
  File "/usr/lib/pymodules/python2.7/openlp/plugins/songs/lib/olpimport.py", line 132, in doImport
    mapper(OldMediaFile, source_media_files_table)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/__init__.py", line 890, in mapper
    return Mapper(class_, local_table, *args, **params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 212, in __init__
    self._configure_pks()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 502, in _configure_pks
    (self, self.mapped_table.description))
ArgumentError: Mapper Mapper|OldMediaFile|media_files could not assemble any primary key columns for mapped table 'media_files'

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

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