← Back to team overview

openlp-core team mailing list archive

[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