openlp-core team mailing list archive
-
openlp-core team
-
Mailing list archive
-
Message #13127
[Bug 891740] Re: error when importing from openlp2 sqlite database to openlp2 mysql database
*** This bug is a duplicate of bug 863845 ***
https://bugs.launchpad.net/bugs/863845
Hello,
This should be fixed now....
Please try it again...
Regards, OpenLP team
** Changed in: openlp
Milestone: None => 1.9.8
** This bug has been marked a duplicate of bug 863845
Crash upon using the OpenLP 2 importer with newer databases
--
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/891740
Title:
error when importing from openlp2 sqlite database to openlp2 mysql
database
Status in OpenLP - Worship Presentation Software:
New
Bug description:
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
To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/891740/+subscriptions
References