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

Bug #872975 reported by Raoul Snyman
12
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenLP
Fix Released
Medium
Unassigned

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

Related branches

Revision history for this message
Raoul Snyman (raoul-snyman) wrote :
Revision history for this message
Andreas Preikschat (googol-deactivatedaccount) wrote :
Changed in openlp:
importance: Medium → High
tags: added: support-system
Revision history for this message
Andreas Preikschat (googol-deactivatedaccount) wrote :

Songs database attach in this ticket!
http://support.openlp.org/issues/290

Changed in openlp:
assignee: nobody → Andreas Preikschat (googol)
status: Confirmed → In Progress
Changed in openlp:
status: In Progress → Fix Committed
importance: High → Medium
Changed in openlp:
status: Fix Committed → In Progress
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.