Fix alert count on bad query

1 files changed, 5 insertions, 1 deletions

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'))