BPF : erreur à la suppression d'une facture et de l'affaire associée
Si l'on supprime une facture créée sans devis, on supprime également l'affaire qui la contient.
xxxxxxxxx /invoices/443/delete'
Traceback (most recent call last):
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid_exclog/__init__.py", line 134, in exclog_tween
response = handler(request)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/endi-5.1.3-py2.7.egg/endi/utils/sqlalchemy_fix.py", line 25, in tween
return handler(request)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 171, in tm_tween
reraise(*exc_info)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 136, in tm_tween
response = handler(request)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid/tweens.py", line 43, in excview_tween
response = _error_handler(request, exc)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid/tweens.py", line 17, in _error_handler
reraise(*exc_info)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid/tweens.py", line 41, in excview_tween
response = handler(request)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid/router.py", line 148, in handle_request
registry, request, context, context_iface, view_name
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid/view.py", line 657, in _call_view
response = view_callable(context, request)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid/config/views.py", line 188, in attr_view
return view(context, request)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid/config/views.py", line 214, in predicate_wrapper
return view(context, request)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid/viewderivers.py", line 325, in secured_view
return view(context, request)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid/viewderivers.py", line 514, in csrf_view
return view(context, request)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid/viewderivers.py", line 401, in viewresult_to_response
result = view(context, request)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/pyramid/viewderivers.py", line 130, in _class_view
response = inst()
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/endi-5.1.3-py2.7.egg/endi/views/task/views.py", line 217, in __call__
self.request.dbsession.flush()
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2254, in flush
self._flush(objects)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2380, in _flush
transaction.rollback(_capture_exception=True)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2344, in _flush
flush_context.execute()
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 386, in execute
n.execute_aggregate(self, set_)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 489, in execute_aggregate
self.execute(uow)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 556, in execute
uow
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 177, in save_obj
mapper, table, update)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 768, in _emit_update_statements
execute(statement, multiparams)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
cursor.execute(statement, parameters)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 198, in execute
res = self._query(query)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 304, in _query
db.query(q)
File "/home/endi/.virtualenvs/endi/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 217, in query
_mysql.connection.query(self, query)
IntegrityError: (MySQLdb._exceptions.IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`endi`.`business_bpf_data`, CONSTRAINT `fk_business_bpf_data_business_id` FOREIGN KEY (`business_id`) REFERENCES `business` (`id`) ON DELETE CASCADE)') [SQL: u'UPDATE business_bpf_data SET business_id=%s, updated_at=%s WHERE business_bpf_data.id = %s'] [parameters: (None, datetime.datetime(2020, 2, 14, 11, 33, 11, 385551), 33)] (Background on this error at: http://sqlalche.me/e/gkpj)