← Back to team overview

openlp-core team mailing list archive

[Bug 872975] Re: Importing from v1 fails with error about missing "settings" table

 

** Changed in: openlp
       Status: Confirmed => In Progress

** Changed in: openlp
     Assignee: (unassigned) => Andreas Preikschat (googol)

-- 
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:
  In Progress

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


References