openlp-core team mailing list archive

[John Cegalis <1030965@xxxxxxxxxxxxxxxxxx>]

Going back into the Win7 OpenLP I opened OpenLP and there were no songs
in my media. I checked the songs folder and the songs.sqlite showed
being 1.4 meg so I knew they were there. I tried searching for a song in
openlp and I received the traceback above. Corrupted database available
upon request.

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

Title:
  ccli import failed with traceback

Status in OpenLP - Worship Presentation Software:
  New

Bug description:
  I was importing this song from ccli text and got this. I imported a
  first song without a problem and now this traceback keeps coming up.
  It did corrupt my database once with a different traceback and I had
  to restore my song database.

  
  Version: {u'full': u'1.9.11', u'version': u'1.9.11', u'build': None}

  --- Details of the Exception. ---


  --- Exception Traceback ---
  Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openlp/core/ui/mainwindow.py", line 1187, in closeEvent
  self.cleanUp()
  File "/usr/lib/pymodules/python2.7/openlp/core/ui/mainwindow.py", line 1209, in cleanUp
  self.pluginManager.finalise_plugins()
  File "/usr/lib/pymodules/python2.7/openlp/core/lib/pluginmanager.py", line 206, in finalise_plugins
  plugin.finalise()
  File "/usr/lib/pymodules/python2.7/openlp/plugins/songs/songsplugin.py", line 268, in finalise
  self.clearTemporarySongs()
  File "/usr/lib/pymodules/python2.7/openlp/plugins/songs/songsplugin.py", line 285, in clearTemporarySongs
  songs = self.manager.get_all_objects(Song, Song.temporary == True)
  File "/usr/lib/pymodules/python2.7/openlp/core/lib/db.py", line 376, in get_all_objects
  return query.all()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1947, in all
  return list(self)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2057, in __iter__
  return self._execute_and_instances(context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2070, in _execute_and_instances
  close_with_result=True)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2061, in _connection_from_session
  **kw)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 719, in connection
  close_with_result=close_with_result)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 723, in _connection_for_bind
  return self.transaction._connection_for_bind(engine)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 249, in _connection_for_bind
  self._assert_is_active()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 173, in _assert_is_active
  % self._rollback_exception
  InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (OperationalError) attempt to write a readonly database u'INSERT INTO songs (song_book_id, title, alternate_title, lyrics, verse_order, copyright, comments, ccli_number, song_number, theme_name, search_title, search_lyrics, create_date, last_modified, "temporary") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?)' (None, u'You Never Let Go', u'', u'<?xml version=\'1.0\' encoding=\'UTF-8\'?>\n<song version="1.0"><lyrics><verse type="p" label="1"><![CDATA[And I will fear no evil\r\nFor my God is with me\r\nAnd if my God is with me\r\nWhom then shall I fear\r\nWhom then shall I fear]]></verse><verse type="c" label="1"><![CDATA[Oh no You never let go\r\nThrough the calm and through the storm\r\nOh no You never let go\r\nIn ev\'ry high and ev\'ry low\r\nOh no You never let go\r\nLord You never let go of me]]></verse><verse type="v" label="1"><![CDATA[Even though I walk\r\nThrough the valley of the shadow of death\r\nYour perfect love is casting out fear\r\nAnd even when I\'m caught\r\nIn the middle of the storms of this life\r\nI won\'t turn back I know You are near]]></verse><verse type="v" label="2"><![CDATA[And I can see a light that is coming\r\nFor the heart that holds on\r\nA glorious light beyond all compare\r\nAnd there will be an end to these troubles\r\nBut until that day comes\r\nWe\'ll live to know You here on the earth]]></verse><verse type="c" label="2"><![CDATA[Oh no You never let go\r\nThrough the calm and through the storm\r\nOh no You never let go\r\nIn ev\'ry high and ev\'ry low\r\nOh no You never let go\r\nLord You never let go of me\r\nYou keep on runnin\' and You never let go\r\nSingin\']]></verse><verse type="b" label="1"><![CDATA[Yes I can see a light\r\nThat is coming for the heart that holds on\r\nAnd there will be an end to these troubles\r\nBut until that day comes\r\nStill I will praise You\r\nStill I will praise You\r\n(REPEAT)]]></verse></lyrics></song>', u'', u'\xa9 2005 Thankyou Music (Admin. by EMI Christian Music Publishing)', u'For use solely with the SongSelect Terms of Use. All rights reserved. www.ccli.com', u'4674166', u'', u'', u'', u'', 0)

  --- System information ---
  Platform: Linux-3.2.0-27-generic-x86_64-with-Ubuntu-12.04-precise
  Desktop: KDE SC

  --- Library Versions ---
  Python: 2.7.3
  Qt4: 4.8.1
  Phonon: 4.6.0
  PyQt4: 4.9.1
  QtWebkit: 534.34
  SQLAlchemy: 0.7.4
  SQLAlchemy Migrate: 0.7.2
  BeautifulSoup: 3.2.0
  lxml: 2.3.2
  Chardet: 2.0.1
  PyEnchant: 1.6.5
  PySQLite: 1.0.1
  Mako: 0.5.0
  pyUNO bridge: 3.5

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