Comment 3 for bug 863845

Revision history for this message
Rastislav Pecik (rapecik) wrote :

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'