openlp-core team mailing list archive

[John Cegalis <1030965@xxxxxxxxxxxxxxxxxx>]

And if there still isn't enough information: I tried importing on Win7.
I got the traceback but the songs were imported. Here's the good part,
if I search for one of the songs I just imported by typing text in the
box searching for a title it shows the song BUT if I backspace the
search box back to blank the traceback comes up again.


**OpenLP Bug Report**
Version: {u'full': u'1.9.10-bzr2037', u'version': u'1.9.10', u'build': u'bzr2037'}

--- Details of the Exception. ---

testjlkjl lkjlkjlkjlkjlkj

 --- Exception Traceback ---
Traceback (most recent call last):
  File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\out01-PYZ.pyz\openlp.plugins.songs.lib.mediaitem", line 256, in onSongListLoad
  File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\out01-PYZ.pyz\openlp.plugins.songs.lib.mediaitem", line 195, in onSearchTextButtonClicked
  File "D:\OpenLP_Code\trunk\build\pyi.win32\OpenLP\out01-PYZ.pyz\openlp.core.lib.db", line 376, in get_all_objects
  File "build\bdist.win32\egg\sqlalchemy\orm\query.py", line 2114, in all
  File "build\bdist.win32\egg\sqlalchemy\orm\query.py", line 2338, in instances
  File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 3179, in fetchall
  File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 3173, in fetchall
  File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 3140, in _fetchall_impl
OperationalError: (OperationalError) Could not decode to UTF-8 column 'songs_search_lyrics' with text '' None None

--- System information ---
Platform: Windows-7-6.1.7601-SP1

--- Library Versions ---
Python: 2.7.3
Qt4: 4.8.0
Phonon: 4.4.0
PyQt4: 4.9.1
QtWebkit: 534.34
SQLAlchemy: 0.7.7
SQLAlchemy Migrate: 0.7.2
BeautifulSoup: 3.2.1
lxml: 2.3.0
Chardet: 1.0.1
PyEnchant: 1.6.5
PySQLite: 1.0.1
Mako: 0.7.0
pyUNO bridge: -

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