openlp-core team mailing list archive

[Raoul Snyman <raoul.snyman@xxxxxxxxxxxxxxxxxxxxxxxx>]

Public bug reported:

Some v1 databases don't seem to have a "settings" table. See the user-
submitted bug report below:

I've tried to import songs from older version of OpenLP to 1.9.7
version.

When I was importing the same database to version 1.9.5 everything was
good.

--- Exception Traceback ---
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openlp/core/ui/wizard.py", line 191, in onCurrentIdChanged
    self.performWizard()
  File "/usr/lib/pymodules/python2.7/openlp/plugins/songs/forms/songimportform.py", line 762, in performWizard
    importer.doImport()
  File "/usr/lib/pymodules/python2.7/openlp/plugins/songs/lib/olp1import.py", line 96, in doImport
    cursor.execute(u'SELECT settingsid, settingsname FROM settings')
  File "/usr/lib/python2.7/dist-packages/sqlite/main.py", line 244, in execute
    self.rs = self.con.db.execute(SQL)
DatabaseError: no such table: settings

** Affects: openlp
     Importance: Medium
         Status: Confirmed


** Tags: song-import version-1

-- 
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/872975

Title:
  Importing from v1 fails with error about missing "settings" table

Status in OpenLP - Worship Presentation Software:
  Confirmed

Bug description:
  Some v1 databases don't seem to have a "settings" table. See the user-
  submitted bug report below:

  I've tried to import songs from older version of OpenLP to 1.9.7
  version.

  When I was importing the same database to version 1.9.5 everything was
  good.

  --- Exception Traceback ---
  Traceback (most recent call last):
    File "/usr/lib/pymodules/python2.7/openlp/core/ui/wizard.py", line 191, in onCurrentIdChanged
      self.performWizard()
    File "/usr/lib/pymodules/python2.7/openlp/plugins/songs/forms/songimportform.py", line 762, in performWizard
      importer.doImport()
    File "/usr/lib/pymodules/python2.7/openlp/plugins/songs/lib/olp1import.py", line 96, in doImport
      cursor.execute(u'SELECT settingsid, settingsname FROM settings')
    File "/usr/lib/python2.7/dist-packages/sqlite/main.py", line 244, in execute
      self.rs = self.con.db.execute(SQL)
  DatabaseError: no such table: settings

To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/872975/+subscriptions