openlp-core team mailing list archive

[Jonathan Corwin <1391638@xxxxxxxxxxxxxxxxxx>]

So can we check for the existence of the authors_songs_1.author_type
column (or whatever it is that is different between 2.0.4 and 2.0.5) and
do it that way? If it isn't there, give up with a message.

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

Title:
  Songs database error when upgrading from 2.0.5 to 2.1.1

Status in OpenLP - Worship Presentation Software:
  Confirmed

Bug description:
  Reported by a few of our users (and experienced by me too).

  http://support.openlp.org/scp/tickets.php?id=2575
  http://support.openlp.org/scp/tickets.php?id=2567

  
  *OpenLP Bug Report*
  Version: {'build': None, 'full': '2.1.1', 'version': '2.1.1'}

  --- Details of the Exception. ---

  Songs list empty after upgrade to 2.11 (Ubuntu ppa).
  Every time I try to acces my songs list, I get this error. Also after manually importin from 2.05 (backup folder)

  --- Exception Traceback ---
  Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
  context)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
  cursor.execute(statement, parameters)
  sqlite3.OperationalError: no such column: authors_songs_1.author_type

  The above exception was the direct cause of the following exception:

  Traceback (most recent call last):
  File "/usr/share/openlp/openlp/plugins/songs/lib/mediaitem.py", line 282, in on_clear_text_button_click
  self.on_search_text_button_clicked()
  File "/usr/share/openlp/openlp/plugins/songs/lib/mediaitem.py", line 189, in on_search_text_button_clicked
  self.display_results_author(search_results)
  File "/usr/share/openlp/openlp/plugins/songs/lib/mediaitem.py", line 252, in display_results_author
  for song in author.songs:
  File "/usr/lib/python3/dist-packages/sqlalchemy/orm/attributes.py", line 239, in __get__
  return self.impl.get(instance_state(instance), dict_)
  File "/usr/lib/python3/dist-packages/sqlalchemy/orm/attributes.py", line 591, in get
  value = self.callable_(state, passive)
  File "/usr/lib/python3/dist-packages/sqlalchemy/orm/strategies.py", line 534, in _load_for_state
  return self._emit_lazyload(session, state, ident_key, passive)
  File "<string>", line 1, in <lambda>
  File "/usr/lib/python3/dist-packages/sqlalchemy/orm/strategies.py", line 603, in _emit_lazyload
  result = q.all()
  File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 2300, in all
  return list(self)
  File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 2412, in __iter__
  return self._execute_and_instances(context)
  File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 2427, in _execute_and_instances
  result = conn.execute(querycontext.statement, self._params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 729, in execute
  return meth(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 321, in _execute_on_connection
  return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
  compiled_sql, distilled_params
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
  context)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
  exc_info
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 188, in raise_from_cause
  reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 181, in reraise
  raise value.with_traceback(tb)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
  context)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
  cursor.execute(statement, parameters)
  sqlalchemy.exc.OperationalError: (OperationalError) no such column: authors_songs_1.author_type '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, songs."temporary" AS songs_temporary, anon_1.authors_1_id AS authors_1_id, anon_1.authors_1_first_name AS authors_1_first_name, anon_1.authors_1_last_name AS authors_1_last_name, anon_1.authors_1_display_name AS authors_1_display_name \nFROM authors_songs, songs LEFT OUTER JOIN (SELECT authors_songs_1.author_id AS authors_songs_1_author_id, authors_songs_1.song_id AS authors_songs_1_song_id, authors_songs_1.author_type AS authors_songs_1_author_type, 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 authors_songs AS authors_songs_1 JOIN authors AS authors_1 ON authors_1.id = authors_songs_1.author_id) AS anon_1 ON songs.id = anon_1.authors_songs_1_song_id \nWHERE ? = authors_songs.author_id AND songs.id = authors_songs.song_id' (77,)

  --- System information ---
  Plattform: Linux-3.16.0-24-generic-x86_64-with-Ubuntu-14.10-utopic
  Desktop: KDE SC

  --- Library Versions ---
  Python: 3.4.2
  Qt4: 4.8.6
  Phonon: 4.7.80
  PyQt4: 4.11.2
  QtWebkit: 537.21
  SQLAlchemy: 0.9.7
  SQLAlchemy Migrate: -
  BeautifulSoup: 4.3.2
  lxml: 3.3.6
  Chardet: 2.2.1
  PyEnchant: 1.6.6
  Mako: 1.0.0
  pyICU: -
  pyUNO bridge: 4.3
  VLC: 2.2.0-pre2 Weatherwax

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