Hello, I am facing the following issue after upgrading to 2.2 from 1.11. Here is the stack trace:
Traceback (most recent call last): File "(...)\.env\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "(...)\.env\lib\site-packages\django\db\backends\sqlite3\base.py", line 383, in execute return Database.Cursor.execute(self, query, params) sqlite3.OperationalError: only a single result allowed for a SELECT that is part of an expression The above exception was the direct cause of the following exception: Traceback (most recent call last): File "(...)\dashboard\deployment\tests\test_view.py", line 53, in test_display_list_view response = self.client.get(self.url_my_list) File "(...)\.env\lib\site-packages\django\test\client.py", line 535, in get response = super().get(path, data=data, secure=secure, **extra) File "(...)\.env\lib\site-packages\django\test\client.py", line 347, in get **extra, File "(...)\.env\lib\site-packages\django\test\client.py", line 422, in generic return self.request(**r) File "(...)\.env\lib\site-packages\django\test\client.py", line 503, in request raise exc_value File "(...)\.env\lib\site-packages\django\core\handlers\exception.py", line 34, in inner response = get_response(request) File "(...)\.env\lib\site-packages\django\core\handlers\base.py", line 115, in _get_response response = self.process_exception_by_middleware(e, request) File "(...)\.env\lib\site-packages\django\core\handlers\base.py", line 113, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "(...)\.env\lib\site-packages\django\views\generic\base.py", line 71, in view return self.dispatch(request, *args, **kwargs) File "(...)\.env\lib\site-packages\django\contrib\auth\mixins.py", line 52, in dispatch return super().dispatch(request, *args, **kwargs) File "(...)\.env\lib\site-packages\django\views\generic\base.py", line 97, in dispatch return handler(request, *args, **kwargs) File "(...)\.env\lib\site-packages\django\views\generic\list.py", line 157, in get context = self.get_context_data() File "(...)\dashboard\deployment\views.py", line 53, in get_context_data context = super().get_context_data(**kwargs) File "(...)\.env\lib\site-packages\django\views\generic\list.py", line 119, in get_context_data paginator, page, queryset, is_paginated = self.paginate_queryset(queryset, page_size) File "(...)\.env\lib\site-packages\django\views\generic\list.py", line 69, in paginate_queryset page = paginator.page(page_number) File "(...)\.env\lib\site-packages\django\core\paginator.py", line 70, in page number = self.validate_number(number) File "(...)\.env\lib\site-packages\django\core\paginator.py", line 48, in validate_number if number > self.num_pages: File "(...)\.env\lib\site-packages\django\utils\functional.py", line 80, in __get__ res = instance.__dict__[self.name] = self.func(instance) File "(...)\.env\lib\site-packages\django\core\paginator.py", line 97, in num_pages if self.count == 0 and not self.allow_empty_first_page: File "(...)\.env\lib\site-packages\django\utils\functional.py", line 80, in __get__ res = instance.__dict__[self.name] = self.func(instance) *File "(...)\.env\lib\site-packages\django\core\paginator.py", line 91, in count* * return c()* File "(...)\.env\lib\site-packages\django\db\models\query.py", line 392, in count return self.query.get_count(using=self.db) File "(...)\.env\lib\site-packages\django\db\models\sql\query.py", line 504, in get_count number = obj.get_aggregation(using, ['__count'])['__count'] File "(...)\.env\lib\site-packages\django\db\models\sql\query.py", line 489, in get_aggregation result = compiler.execute_sql(SINGLE) File "(...)\.env\lib\site-packages\django\db\models\sql\compiler.py", line 1097, in execute_sql cursor.execute(sql, params) File "(...)\.env\lib\site-packages\django\db\backends\utils.py", line 67, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "(...)\.env\lib\site-packages\django\db\backends\utils.py", line 76, in _execute_with_wrappers return executor(sql, params, many, context) File "(...)\.env\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "(...)\.env\lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "(...)\.env\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "(...)\.env\lib\site-packages\django\db\backends\sqlite3\base.py", line 383, in execute return Database.Cursor.execute(self, query, params) django.db.utils.OperationalError: only a single result allowed for a SELECT that is part of an expression It seems that during pagination some query is made that is not supported by SQLite. Did anybody face the same issue? I am using Python 3.6 with SQLite 3.14. Thanks in advance, Szabolcs -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/a5a54e8c-d3aa-4eef-b455-82ec15a99e76%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.