Changeset 6653 for branches/2.1/include/functions_notification.inc.php

Timestamp:

Jul 3, 2010, 2:16:12 PM (14 years ago)

Author:

nikrou

Message:

Bug 1754 fixed : The keyword AS is mandatory for alias in PostgreSQL queries
Merge from trunk

File:

• branches/2.1/include/functions_notification.inc.php (modified) (2 diffs)

branches/2.1/include/functions_notification.inc.php

@@ -477 +477 @@
   $query = '
 SELECT date_available,
-      COUNT(DISTINCT id) nb_elements,
-      COUNT(DISTINCT category_id) nb_cats
+      COUNT(DISTINCT id) AS nb_elements,
+      COUNT(DISTINCT category_id) AS nb_cats
   FROM '.IMAGES_TABLE.' i INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=image_id
   '.$where_sql.'
@@ -516 +516 @@
     {// get some categories ...
       $query = '
-SELECT c.uppercats, COUNT(DISTINCT i.id) img_count
+SELECT c.uppercats, COUNT(DISTINCT i.id) AS img_count
   FROM '.IMAGES_TABLE.' i INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id=image_id
     INNER JOIN '.CATEGORIES_TABLE.' c ON c.id=category_id