Fix: add author_uid in GROUP BY in LogDisplay for PostgreSQL compatibility
authorphirox
Sun, 10 Jan 2010 17:14:52 -0500
changeset 1212 db2edac4e5a7
parent 1211 488294ceee13
child 1213 0c328ca308dc
Fix: add author_uid in GROUP BY in LogDisplay for PostgreSQL compatibility
includes/log.php
--- a/includes/log.php	Sun Jan 10 17:13:03 2010 -0500
+++ b/includes/log.php	Sun Jan 10 17:14:52 2010 -0500
@@ -165,7 +165,7 @@
          . "  LEFT JOIN " . table_prefix . "users AS u\n"
          . "    ON ( u.user_id = l.author_uid OR u.user_id IS NULL )\n"
          . "  WHERE log_type = 'page' AND is_draft != 1$where_extra\n"
-         . "  GROUP BY log_id, action, page_id, namespace, page_text, author, time_id, edit_summary, minor_edit\n"
+         . "  GROUP BY log_id, action, page_id, namespace, page_text, author, author_uid, username, time_id, edit_summary, minor_edit\n"
          . "  ORDER BY time_id DESC $limit;";
     
     return $sql;