openlp-core team mailing list archive

[Rastislav Pecik <891740@xxxxxxxxxxxxxxxxxx>]

** Attachment added: "mysql dump and sqlite database"
   https://bugs.launchpad.net/bugs/891740/+attachment/2599875/+files/openlp.zip

-- 
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  databaze to openlp2 mysql
  databaze

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