openlp-core team mailing list archive

[Rastislav Pecik <891740@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: openlp
     Importance: Undecided
         Status: New

-- 
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