Error al entrar incidències

[jaumeteixidor]

El programa dona error a alguns professors al intentar entrar incidències Al intetar entrar una incidència (ja sigui des de la dreta (incidència a aula) o a esquerra(incidència a fora o per el professor de guadia)) els dona error.

Sembla que es queixa de un profesional_id, però no tinc clar de què és no com informar-lo. No passa a tots els professors. El trace que obtenim és el següent:

Internal Server Error: /incidencies/posaIncidenciaAula/81826/

IntegrityError at /incidencies/posaIncidenciaAula/81826/ null value in column "professional_id" violates not-null constraint DETAIL: Failing row contains (6673, 2020-02-19, Parla, molesta i no deixa treballar als companys., t, null, null, 1326, 1259415, 5, null, null, null, 3, f, , null).

Request Method: POST Request URL: https://ca.iesnx.cat/incidencies/posaIncidenciaAula/81826/ Django Version: 2.2.3 Python Executable: /opt/djau2019/venv/bin/python Python Version: 3.6.8 Python Path: ['/opt/djau2019', '/usr/lib/python36.zip', '/usr/lib/python3.6', '/usr/lib/python3.6/lib-dynload', '/opt/djau2019/venv/lib/python3.6/site-packages'] Server time: dj., 20 Feb. 2020 09:26:13 +0100 Installed Applications: ['customising', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.sites', 'django_extensions', 'django_tables2', 'django.contrib.humanize', 'aula.apps.missatgeria', 'aula.apps.alumnes', 'aula.apps.assignatures', 'aula.apps.horaris', 'aula.apps.presencia', 'aula.apps.incidencies', 'aula.apps.tutoria', 'aula.apps.extKronowin', 'aula.apps.extSaga', 'aula.apps.extEsfera', 'aula.apps.avaluacioQualitativa', 'aula.apps.todo', 'aula.apps.usuaris', 'aula.apps.relacioFamilies', 'aula.apps.sortides', 'aula.apps.baixes', 'aula.apps.BI', 'aula.apps.aules', 'aula.utils', 'aula.apps.presenciaSetmanal', 'aula.apps.extUntis', 'private_storage'] Installed Middleware: ['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'aula.utils.middleware.MultipleProxyMiddleware', 'aula.utils.middleware.NoCacheMiddleware', 'aula.utils.middleware.timeOutMiddleware', 'aula.utils.middleware.IncludeLoginInErrors']

Traceback:

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/query.py" in get_or_create

538. return self.get(**kwargs), False

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/query.py" in get

408. self.model._meta.object_name

During handling of the above exception (Incidencia matching query does not exist.), another exception occurred:

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute

84. return self.cursor.execute(sql, params)

The above exception (null value in column "professional_id" violates not-null constraint DETAIL: Failing row contains (6673, 2020-02-19, Parla, molesta i no deixa treballar als companys., t, null, null, 1326, 1259415, 5, null, null, null, 3, f, , null). ) was the direct cause of the following exception:

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner

34. response = get_response(request)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response

115. response = self.process_exception_by_middleware(e, request)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response

113. response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/contrib/auth/decorators.py" in _wrapped_view

21. return view_func(request, *args, **kwargs)

File "/opt/djau2019/aula/utils/decorators.py" in inner_decorator

17. return func(request, *args, **kwargs)

File "/opt/djau2019/aula/apps/incidencies/views.py" in posaIncidenciaAula

109. tipus = tipus )

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/manager.py" in manager_method

82. return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/query.py" in get_or_create

541. return self._create_object_from_params(kwargs, params)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/query.py" in _create_object_from_params

583. raise e

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/query.py" in _create_object_from_params

575. obj = self.create(**params)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/query.py" in create

422. obj.save(force_insert=True, using=self.db)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/base.py" in save

741. force_update=force_update, update_fields=update_fields)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/base.py" in save_base

779. force_update, using, update_fields,

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/base.py" in _save_table

870. result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/base.py" in _do_insert

908. using=using, raw=raw)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/manager.py" in manager_method

82. return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/query.py" in _insert

1186. return query.get_compiler(using=using).execute_sql(return_id)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/models/sql/compiler.py" in execute_sql

1335. cursor.execute(sql, params)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/backends/utils.py" in execute

67. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute_with_wrappers

76. return executor(sql, params, many, context)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute

84. return self.cursor.execute(sql, params)

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/utils.py" in exit

89. raise dj_exc_value.with_traceback(traceback) from exc_value

File "/opt/djau2019/venv/lib/python3.6/site-packages/django/db/backends/utils.py" in _execute

84. return self.cursor.execute(sql, params)

Exception Type: IntegrityError at /incidencies/posaIncidenciaAula/81826/ Exception Value: null value in column "professional_id" violates not-null constraint DETAIL: Failing row contains (6673, 2020-02-19, Parla, molesta i no deixa treballar als companys., t, null, null, 1326, 1259415, 5, null, null, null, 3, f, , null).

Request information: USER: mballespici

[ctrl-alt-d]

hola,

heu entrat a mà (des d'admin) aquests professors? Comproveu des de l'admin que els usuaris d'aquests professors estan al grup "professionals" (que són els que poden entrar incidències)

[jaumeteixidor]

Em sembla que si. Ok. gràcies. Ho desconeixia.

[ctrl-alt-d]

La figura del 'professional' es va crear per si algú diferent de 'professor' havia d'entrar incidències (ex: monitor de menjador)