Error when making a Song 'Live'

baldrick45

Odd problem this morning. OLP is throwing up this error message every time I make a Song 'live' from my service. Custom slides and powerpoints aren't creating this error but consistently bringing up every song is.

Nothing changed from last week AFAIK although we have run a 'Windows Update' midweek.

Any ideas? As before the system is running on Vista 64bit


Traceback (most recent call last):

File "C:\Program Files\OpenLP\plugins\songusage\songusageplugin.py", line 206, in displaySongUsage

'display')), item)

File "C:\Program Files\OpenLP\plugins\songusage\songusageplugin.py", line 227, in _add_song_usage

self.manager.save_object(song_usage_item)

File "D:\OpenLP_Code\release-2.0\build\pyi.win32\OpenLP\out00-PYZ.pyz\openlp.core.lib.db", line 262, in save_object

File "C:\Program Files\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\scoping.py", line 114, in do

File "C:\Program Files\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\session.py", line 624, in rollback

File "C:\Program Files\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\session.py", line 338, in rollback

File "C:\Program Files\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\session.py", line 366, in _rollback_impl

File "C:\Program Files\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 2034, in rollback

File "C:\Program Files\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 2071, in _do_rollback

File "C:\Program Files\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 1266, in _rollback_impl

File "C:\Program Files\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 1263, in _rollback_impl

File "C:\Program Files\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\engine\default.py", line 300, in do_rollback

OperationalError: (OperationalError) cannot rollback - no transaction is active None None

baldrick45

Correction

System is Vista 32bit and we're running OLP 2.0

raoul

And you've restarted OpenLP and the machine itself?

ElderP

When you did the "Windows Update" was a restore point created?  If so, restore the machine to that point.  That will tell us if the "update" caused the problem.

Secondly, try exporting all of you songs.  That will tell us if the "songs" data base has been corrupted.

Let us know the outcome of the above.