openlp-core team mailing list archive

[Raoul Snyman <raoul@xxxxxxxxxxx>]

Public bug reported:

We're seeing a lot of this exception since 2.4.5, so it looks like we've
introduced a big. I don't actually know how to repetisie it because all
of the users reporting the bug swear blind that they did nothing wrong
and don't know how to reproduce it.

--- Exception Traceback ---

Traceback (most recent call last):

  File "site-packages\sqlalchemy\engine\base.py", line 1182, in
_execute_context

  File "site-packages\sqlalchemy\engine\default.py", line 470, in
do_execute

sqlite3.IntegrityError: NOT NULL constraint failed: authors.display_name


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


Traceback (most recent call last):

  File "openlp\plugins\songs\forms\editsongform.py", line 1005, in
accept

  File "openlp\plugins\songs\forms\editsongform.py", line 1063, in
save_song

  File "openlp\core\lib\db.py", line 272, in save_object

  File "site-packages\sqlalchemy\orm\scoping.py", line 157, in do

  File "site-packages\sqlalchemy\orm\session.py", line 874, in commit

  File "site-packages\sqlalchemy\orm\session.py", line 461, in commit

  File "site-packages\sqlalchemy\orm\session.py", line 441, in
_prepare_impl

  File "site-packages\sqlalchemy\orm\session.py", line 2139, in flush

  File "site-packages\sqlalchemy\orm\session.py", line 2259, in _flush

  File "site-packages\sqlalchemy\util\langhelpers.py", line 60, in
__exit__

  File "site-packages\sqlalchemy\util\compat.py", line 187, in reraise

  File "site-packages\sqlalchemy\orm\session.py", line 2223, in _flush

  File "site-packages\sqlalchemy\orm\unitofwork.py", line 389, in
execute

  File "site-packages\sqlalchemy\orm\unitofwork.py", line 548, in
execute

  File "site-packages\sqlalchemy\orm\persistence.py", line 181, in
save_obj

  File "site-packages\sqlalchemy\orm\persistence.py", line 835, in
_emit_insert_statements

  File "site-packages\sqlalchemy\engine\base.py", line 945, in execute

  File "site-packages\sqlalchemy\sql\elements.py", line 263, in
_execute_on_connection

  File "site-packages\sqlalchemy\engine\base.py", line 1053, in
_execute_clauseelement

  File "site-packages\sqlalchemy\engine\base.py", line 1189, in
_execute_context

  File "site-packages\sqlalchemy\engine\base.py", line 1393, in
_handle_dbapi_exception

  File "site-packages\sqlalchemy\util\compat.py", line 203, in
raise_from_cause

  File "site-packages\sqlalchemy\util\compat.py", line 186, in reraise

  File "site-packages\sqlalchemy\engine\base.py", line 1182, in
_execute_context

  File "site-packages\sqlalchemy\engine\default.py", line 470, in
do_execute

sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed:
authors.display_name [SQL: 'INSERT INTO authors (first_name, last_name, display_name)
VALUES (?, ?, ?)'] [parameters: (None, None, None)]

** Affects: openlp
     Importance: Undecided
         Status: New

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

Title:
  Author display name not populated

Status in OpenLP:
  New

Bug description:
  We're seeing a lot of this exception since 2.4.5, so it looks like
  we've introduced a big. I don't actually know how to repetisie it
  because all of the users reporting the bug swear blind that they did
  nothing wrong and don't know how to reproduce it.

  --- Exception Traceback ---

  Traceback (most recent call last):

    File "site-packages\sqlalchemy\engine\base.py", line 1182, in
  _execute_context

    File "site-packages\sqlalchemy\engine\default.py", line 470, in
  do_execute

  sqlite3.IntegrityError: NOT NULL constraint failed:
  authors.display_name


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


  Traceback (most recent call last):

    File "openlp\plugins\songs\forms\editsongform.py", line 1005, in
  accept

    File "openlp\plugins\songs\forms\editsongform.py", line 1063, in
  save_song

    File "openlp\core\lib\db.py", line 272, in save_object

    File "site-packages\sqlalchemy\orm\scoping.py", line 157, in do

    File "site-packages\sqlalchemy\orm\session.py", line 874, in commit

    File "site-packages\sqlalchemy\orm\session.py", line 461, in commit

    File "site-packages\sqlalchemy\orm\session.py", line 441, in
  _prepare_impl

    File "site-packages\sqlalchemy\orm\session.py", line 2139, in flush

    File "site-packages\sqlalchemy\orm\session.py", line 2259, in _flush

    File "site-packages\sqlalchemy\util\langhelpers.py", line 60, in
  __exit__

    File "site-packages\sqlalchemy\util\compat.py", line 187, in reraise

    File "site-packages\sqlalchemy\orm\session.py", line 2223, in _flush

    File "site-packages\sqlalchemy\orm\unitofwork.py", line 389, in
  execute

    File "site-packages\sqlalchemy\orm\unitofwork.py", line 548, in
  execute

    File "site-packages\sqlalchemy\orm\persistence.py", line 181, in
  save_obj

    File "site-packages\sqlalchemy\orm\persistence.py", line 835, in
  _emit_insert_statements

    File "site-packages\sqlalchemy\engine\base.py", line 945, in execute

    File "site-packages\sqlalchemy\sql\elements.py", line 263, in
  _execute_on_connection

    File "site-packages\sqlalchemy\engine\base.py", line 1053, in
  _execute_clauseelement

    File "site-packages\sqlalchemy\engine\base.py", line 1189, in
  _execute_context

    File "site-packages\sqlalchemy\engine\base.py", line 1393, in
  _handle_dbapi_exception

    File "site-packages\sqlalchemy\util\compat.py", line 203, in
  raise_from_cause

    File "site-packages\sqlalchemy\util\compat.py", line 186, in reraise

    File "site-packages\sqlalchemy\engine\base.py", line 1182, in
  _execute_context

    File "site-packages\sqlalchemy\engine\default.py", line 470, in
  do_execute

  sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed:
  authors.display_name [SQL: 'INSERT INTO authors (first_name, last_name, display_name)
  VALUES (?, ?, ?)'] [parameters: (None, None, None)]

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