error when importing from openlp2 sqlite database to openlp2 mysql database

[Rastislav Pecik]

I have replaced the backend database with mysql. Then I have tried to import songs from the previous sqlite database, but I have encoutnered an error :

Traceback (most recent call last):
  File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.core.ui.wizard", line 191, in onCurrentIdChanged
  File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.songs.forms.songimportform", line 762, in performWizard
  File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.songs.lib.olpimport", line 127, in doImport
KeyError: u'media_files_songs'

I am using the 1.9.7 version of OpenLP on Windows 7 Professional. I have used the WAMP server which contains the MySQL database. The sqlite database contained only english songs that had been downloaded through first time wizard.

steps :
1) installed the openlp2
2) downloaded the english songs from first time wizard
3)changed the database backend to mysql (in registry settings) - openlp2 has correctly connected to the mysql database and i was able to create songs
4) File -> Import - openlp2 database - pointed to the old sqlite database
5) error

I am sending the sqldump of mysql and sqlite database in the attachement

[Andreas Preikschat (googol-deactivatedaccount)]

Hello,

This should be fixed now....

Please try it again...

Regards, OpenLP team