Internal Server Error: /app/hjelp/issues/get_next_properties/ [Ticket#75418]

support-bot commented

2021-09-25 21:55:18 +02:00

(Migrated from edugit.org)

Internal Server Error: /app/hjelp/issues/get_next_properties/
>
ValueError at /app/hjelp/issues/get_next_properties/
Field 'id' expected a number but got ''.
>
Request Method: GET
Request URL: [1] https://info.katharineum.de/app/hjelp/issues/get_next_properties/?id=
Django Version: 3.2.7
Python Executable: /usr/bin/uwsgi-core
Python Version: 3.9.2
Python Path: ['/srv/aleksis', '.', '', '/usr/lib/python39.zip', '/usr/lib/python3.9', '/usr/lib/python3.9/lib-dynload', '/srv/aleksis/envs/production/lib/python3.9/site-packages']
Server time: Wed, 22 Sep 2021 11:49:50 +0200
Installed Applications:
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.sites',
'django.contrib.staticfiles',
'django.contrib.humanize',
'django_uwsgi',
'django_extensions',
'guardian',
'rules.apps.AutodiscoverRulesConfig',
'haystack',
'polymorphic',
'dbbackup',
'django_celery_beat',
'django_celery_results',
'celery_progress',
'health_check.contrib.celery',
'djcelery_email',
'celery_haystack',
'sass_processor',
'django_any_js',
'django_yarnpkg',
'django_tables2',
'maintenance_mode',
'menu_generator',
'reversion',
'phonenumber_field',
'debug_toolbar',
'django_prometheus',
'django_select2',
'hattori',
'templated_email',
'html2text',
'django_otp.plugins.otp_totp',
'django_otp.plugins.otp_static',
'django_otp',
'otp_yubikey',
'aleksis.core',
'allauth',
'allauth.account',
'allauth.socialaccount',
'health_check',
'health_check.db',
'health_check.cache',
'health_check.storage',
'health_check.contrib.psutil',
'health_check.contrib.migrations',
'dynamic_preferences',
'dynamic_preferences.users.apps.UserPreferencesConfig',
'impersonate',
'two_factor',
'material',
'ckeditor',
'ckeditor_uploader',
'django_js_reverse',
'colorfield',
'django_bleach',
'favicon',
'django_filters',
'oauth2_provider',
'rest_framework',
'extra_views',
'feeds',
'aleksis.apps.csv_import.apps.CSVImportConfig',
'aleksis.apps.chronos.apps.ChronosConfig',
'aleksis.apps.untis.apps.UntisConfig',
'aleksis.apps.abi.apps.DefaultConfig',
'aleksis.apps.resint.apps.ResintConfig',
'aleksis.apps.dashboardfeeds.apps.DefaultConfig',
'aleksis.apps.hjelp.apps.HjelpConfig',
'aleksis.apps.alsijil.apps.AlsijilConfig',
'aleksis.apps.fritak.apps.FritakConfig',
'aleksis.apps.ldap.apps.LDAPConfig',
'cachalot',
'django_cleanup.apps.CleanupConfig']
Installed Middleware:
['django_prometheus.middleware.PrometheusBeforeMiddleware',
'django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'debug_toolbar.middleware.DebugToolbarMiddleware',
'django.middleware.locale.LocaleMiddleware',
'django.middleware.http.ConditionalGetMiddleware',
'django.contrib.sites.middleware.CurrentSiteMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django_otp.middleware.OTPMiddleware',
'impersonate.middleware.ImpersonateMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
'maintenance_mode.middleware.MaintenanceModeMiddleware',
'aleksis.core.util.middlewares.EnsurePersonMiddleware',
'django_prometheus.middleware.PrometheusAfterMiddleware']
>
Traceback (most recent call last):
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/fields/__init__.py", line 1823, in get_prep_value
   return int(value)
>
The above exception (invalid literal for int() with base 10: '') was the direct cause of the following exception:
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/core/handlers/exception.py", line 47, in inner
   response = get_response(request)
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/core/handlers/base.py", line 181, in _get_response
   response = wrapped_callback(request, *callback_args, **callback_kwargs)
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/views/decorators/cache.py", line 44, in _wrapped_view_func
   response = view_func(request, *args, **kwargs)
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/aleksis/apps/hjelp/views.py", line 189, in issues_get_next_properties
   issue_category = get_object_or_404(IssueCategory, id=_id)
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/shortcuts.py", line 76, in get_object_or_404
   return queryset.get(*args, **kwargs)
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/query.py", line 424, in get
   clone = self._chain() if self.query.combinator else self.filter(*args, **kwargs)
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/query.py", line 941, in filter
   return self._filter_or_exclude(False, args, kwargs)
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/query.py", line 961, in _filter_or_exclude
   clone._filter_or_exclude_inplace(negate, args, kwargs)
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/query.py", line 968, in _filter_or_exclude_inplace
   self._query.add_q(Q(*args, **kwargs))
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/sql/query.py", line 1393, in add_q
   clause, _ = self._add_q(q_object, self.used_aliases)
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/sql/query.py", line 1412, in _add_q
   child_clause, needed_inner = self.build_filter(
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/sql/query.py", line 1347, in build_filter
   condition = self.build_lookup(lookups, col, value)
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/sql/query.py", line 1193, in build_lookup
   lookup = lookup_class(lhs, rhs)
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/lookups.py", line 25, in __init__
   self.rhs = self.get_prep_lookup()
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/lookups.py", line 77, in get_prep_lookup
   return self.lhs.output_field.get_prep_value(self.rhs)
 File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/fields/__init__.py", line 1825, in get_prep_value
   raise e.__class__(
>
Exception Type: ValueError at /app/hjelp/issues/get_next_properties/
Exception Value: Field 'id' expected a number but got ''.
Request information:
USER: **********
>
GET:
id = ''
>
POST: No POST data
>
FILES: No FILES data

``` Internal Server Error: /app/hjelp/issues/get_next_properties/ > ValueError at /app/hjelp/issues/get_next_properties/ Field 'id' expected a number but got ''. > Request Method: GET Request URL: [1] https://info.katharineum.de/app/hjelp/issues/get_next_properties/?id= Django Version: 3.2.7 Python Executable: /usr/bin/uwsgi-core Python Version: 3.9.2 Python Path: ['/srv/aleksis', '.', '', '/usr/lib/python39.zip', '/usr/lib/python3.9', '/usr/lib/python3.9/lib-dynload', '/srv/aleksis/envs/production/lib/python3.9/site-packages'] Server time: Wed, 22 Sep 2021 11:49:50 +0200 Installed Applications: ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.sites', 'django.contrib.staticfiles', 'django.contrib.humanize', 'django_uwsgi', 'django_extensions', 'guardian', 'rules.apps.AutodiscoverRulesConfig', 'haystack', 'polymorphic', 'dbbackup', 'django_celery_beat', 'django_celery_results', 'celery_progress', 'health_check.contrib.celery', 'djcelery_email', 'celery_haystack', 'sass_processor', 'django_any_js', 'django_yarnpkg', 'django_tables2', 'maintenance_mode', 'menu_generator', 'reversion', 'phonenumber_field', 'debug_toolbar', 'django_prometheus', 'django_select2', 'hattori', 'templated_email', 'html2text', 'django_otp.plugins.otp_totp', 'django_otp.plugins.otp_static', 'django_otp', 'otp_yubikey', 'aleksis.core', 'allauth', 'allauth.account', 'allauth.socialaccount', 'health_check', 'health_check.db', 'health_check.cache', 'health_check.storage', 'health_check.contrib.psutil', 'health_check.contrib.migrations', 'dynamic_preferences', 'dynamic_preferences.users.apps.UserPreferencesConfig', 'impersonate', 'two_factor', 'material', 'ckeditor', 'ckeditor_uploader', 'django_js_reverse', 'colorfield', 'django_bleach', 'favicon', 'django_filters', 'oauth2_provider', 'rest_framework', 'extra_views', 'feeds', 'aleksis.apps.csv_import.apps.CSVImportConfig', 'aleksis.apps.chronos.apps.ChronosConfig', 'aleksis.apps.untis.apps.UntisConfig', 'aleksis.apps.abi.apps.DefaultConfig', 'aleksis.apps.resint.apps.ResintConfig', 'aleksis.apps.dashboardfeeds.apps.DefaultConfig', 'aleksis.apps.hjelp.apps.HjelpConfig', 'aleksis.apps.alsijil.apps.AlsijilConfig', 'aleksis.apps.fritak.apps.FritakConfig', 'aleksis.apps.ldap.apps.LDAPConfig', 'cachalot', 'django_cleanup.apps.CleanupConfig'] Installed Middleware: ['django_prometheus.middleware.PrometheusBeforeMiddleware', 'django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'debug_toolbar.middleware.DebugToolbarMiddleware', 'django.middleware.locale.LocaleMiddleware', 'django.middleware.http.ConditionalGetMiddleware', 'django.contrib.sites.middleware.CurrentSiteMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django_otp.middleware.OTPMiddleware', 'impersonate.middleware.ImpersonateMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'maintenance_mode.middleware.MaintenanceModeMiddleware', 'aleksis.core.util.middlewares.EnsurePersonMiddleware', 'django_prometheus.middleware.PrometheusAfterMiddleware'] > Traceback (most recent call last): File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/fields/__init__.py", line 1823, in get_prep_value return int(value) > The above exception (invalid literal for int() with base 10: '') was the direct cause of the following exception: File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/core/handlers/exception.py", line 47, in inner response = get_response(request) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/core/handlers/base.py", line 181, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/views/decorators/cache.py", line 44, in _wrapped_view_func response = view_func(request, *args, **kwargs) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/aleksis/apps/hjelp/views.py", line 189, in issues_get_next_properties issue_category = get_object_or_404(IssueCategory, id=_id) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/shortcuts.py", line 76, in get_object_or_404 return queryset.get(*args, **kwargs) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/query.py", line 424, in get clone = self._chain() if self.query.combinator else self.filter(*args, **kwargs) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/query.py", line 941, in filter return self._filter_or_exclude(False, args, kwargs) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/query.py", line 961, in _filter_or_exclude clone._filter_or_exclude_inplace(negate, args, kwargs) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/query.py", line 968, in _filter_or_exclude_inplace self._query.add_q(Q(*args, **kwargs)) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/sql/query.py", line 1393, in add_q clause, _ = self._add_q(q_object, self.used_aliases) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/sql/query.py", line 1412, in _add_q child_clause, needed_inner = self.build_filter( File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/sql/query.py", line 1347, in build_filter condition = self.build_lookup(lookups, col, value) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/sql/query.py", line 1193, in build_lookup lookup = lookup_class(lhs, rhs) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/lookups.py", line 25, in __init__ self.rhs = self.get_prep_lookup() File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/lookups.py", line 77, in get_prep_lookup return self.lhs.output_field.get_prep_value(self.rhs) File "/srv/aleksis/envs/production/lib/python3.9/site-packages/django/db/models/fields/__init__.py", line 1825, in get_prep_value raise e.__class__( > Exception Type: ValueError at /app/hjelp/issues/get_next_properties/ Exception Value: Field 'id' expected a number but got ''. Request information: USER: ********** > GET: id = '' > POST: No POST data > FILES: No FILES data ```

hansegucker commented

2021-09-25 21:55:18 +02:00

(Migrated from edugit.org)

moved from AlekSIS/AlekSaaS#17

hansegucker commented

2021-11-09 16:09:01 +01:00

(Migrated from edugit.org)

changed title from {-Fwd: [Django] ERROR (EXTERNAL IP): -}Internal Server Error: /app/hjelp/issues/get_next_properties/ [Ticket#75418] to Internal Server Error: /app/hjelp/issues/get_next_properties/ [Ticket#75418]

changed title from **{-Fwd: [Django] ERROR (EXTERNAL IP): -}Internal Server Error: /app/hjelp/issues/get_next_properties/ [Ticket#75418]** to **Internal Server Error: /app/hjelp/issues/get_next_properties/ [Ticket#75418]**

hansegucker commented

2021-11-09 16:09:01 +01:00

(Migrated from edugit.org)

changed the description

hansegucker commented

2021-11-09 16:09:17 +01:00

(Migrated from edugit.org)

assigned to @yuha

hansegucker commented

2021-11-09 16:09:45 +01:00

(Migrated from edugit.org)

made the issue visible to everyone

hansegucker commented

2021-11-09 16:10:00 +01:00

(Migrated from edugit.org)

@yuha Can you please take a look at this issue?

yuha commented

2021-11-26 00:09:56 +01:00

(Migrated from edugit.org)

yes

yuha commented

2021-11-26 00:51:24 +01:00

(Migrated from edugit.org)

Actually, I wasn't able to reproduce this misbehavior in my own testing environment. Could you please further describe the scenario in which it occured? @hansegucker

hansegucker commented

2021-11-29 10:09:08 +01:00

(Migrated from edugit.org)

With some trying, it seems to appear if you clear a Select2 field:

With some trying, it seems to appear if you clear a Select2 field: ![get-next-properties-2021-11-29_10.07.30](/uploads/48efed09c06e50436fc5bb9a0c2306fb/get-next-properties-2021-11-29_10.07.30.mp4)

yuha commented

2021-11-29 18:19:31 +01:00

(Migrated from edugit.org)

oh I see where the issue is

yuha commented

2021-11-29 18:20:39 +01:00

(Migrated from edugit.org)

created merge request !154 to address this issue