Cloning songs does not work

Bug #884826 reported by Andreas Preikschat
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenLP
Fix Released
Medium
Unassigned

Bug Description

Hello,

Cloning songs does not work.

Version: {u'full': u'1.9.5-bzr1421', u'version': u'1.9.5', u'build': u'bzr1421'}

--- Exception Traceback ---
Traceback (most recent call last):
  File "/home/andreas/Projekte/openlp/trunk/openlp/plugins/songs/lib/mediaitem.py", line 423, in onCloneClick
    new_song = self.plugin.manager.get_object(Song, new_song_id)
  File "/home/andreas/Projekte/openlp/trunk/openlp/core/lib/db.py", line 279, in get_object
    return self.session.query(object_class).get(key)
  File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 722, in get
    return self._load_on_ident(key)
  File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2119, in _load_on_ident
    return q.one()
  File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 1796, in one
    ret = list(self)
  File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 1839, in __iter__
    return self._execute_and_instances(context)
  File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 1854, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1399, in execute
    params)
  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1532, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_context
    context)
  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1633, in _execute_context
    context)
  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 325, in do_execute
    cursor.execute(statement, parameters)
InterfaceError: (InterfaceError) Error binding parameter 0 - probably unsupported type. u'SELECT songs.id AS songs_id, songs.song_book_id AS songs_song_book_id, songs.title AS songs_title, songs.alternate_title AS songs_alternate_title, songs.lyrics AS songs_lyrics, songs.verse_order AS songs_verse_order, songs.copyright AS songs_copyright, songs.comments AS songs_comments, songs.ccli_number AS songs_ccli_number, songs.song_number AS songs_song_number, songs.theme_name AS songs_theme_name, songs.search_title AS songs_search_title, songs.search_lyrics AS songs_search_lyrics, songs.create_date AS songs_create_date, songs.last_modified AS songs_last_modified, authors_1.id AS authors_1_id, authors_1.first_name AS authors_1_first_name, authors_1.last_name AS authors_1_last_name, authors_1.display_name AS authors_1_display_name \nFROM songs LEFT OUTER JOIN authors_songs AS authors_songs_1 ON songs.id = authors_songs_1.song_id LEFT OUTER JOIN authors AS authors_1 ON authors_1.id = authors_songs_1.author_id \nWHERE songs.id = ?' (<openlp.plugins.songs.lib.db.Song object at 0xd15fb0c>,)

--- System information ---
Plattform: Linux-3.0-ARCH-i686-Intel-R-_Pentium-R-_4_CPU_1.80GHz-with-glibc2.0

--- Library Versions ---
Python: 2.7.2
Qt4: 4.7.4
Phonon: 4.5.1
PyQt4: 4.8.6
SQLAlchemy: 0.7.2
SQLAlchemy Migrate: 0.7.1
BeautifulSoup: 3.2.0
lxml: 2.3.1
Chardet: 2.0.1
PyEnchant: 1.6.5
PySQLite: 1.0.1
Mako: 0.5.0
pyUNO bridge: 3.4

http://support.openlp.org/issues/314

Related branches

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

Other bug subscribers

Remote bug watches

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