From 014cf42986487a2ec70d68f741308d48ff88e486 Mon Sep 17 00:00:00 2001 From: Étienne Loks Date: Tue, 29 Dec 2020 07:57:26 +0100 Subject: Fix alert count on bad query --- ishtar_common/views_item.py | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/ishtar_common/views_item.py b/ishtar_common/views_item.py index 32b6c77d1..ded93212b 100644 --- a/ishtar_common/views_item.py +++ b/ishtar_common/views_item.py @@ -21,6 +21,7 @@ from django.core.urlresolvers import reverse, NoReverseMatch from django.db.models import Q, Count, Sum, ImageField, Func, \ ExpressionWrapper, FloatField, FileField from django.db.models.fields import FieldDoesNotExist +from django.db.utils import ProgrammingError from django.forms.models import model_to_dict from django.http import HttpResponse from django.shortcuts import render @@ -1756,7 +1757,10 @@ def get_item(model, func_name, default_name, extra_request_keys=None, items = items.distinct() - items_nb = items.values('pk').aggregate(Count('pk'))['pk__count'] + try: + items_nb = items.values('pk').aggregate(Count('pk'))['pk__count'] + except ProgrammingError: + items_nb = 0 if count: return items_nb # print(str(items.values("id").query).encode('utf-8')) -- cgit v1.2.3