openlp-core team mailing list archive

[Launchpad Bug Tracker <884826@xxxxxxxxxxxxxxxxxx>]

** Branch linked: lp:~googol/openlp/bug-884826

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

Title:
  Cloning songs does not work

Status in OpenLP - Worship Presentation Software:
  In Progress

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

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