From c96766c9dff48daa6c8a4b3835622f8b4020f875 Mon Sep 17 00:00:00 2001 From: Alexandre Emsenhuber Date: Sat, 21 Feb 2009 15:27:56 +0000 Subject: [PATCH] Fixed Special:Wantedtemplates' SQL query to work with PostgreSQL, was throwing the following error: ERROR: column "templatelinks.tl_namespace" must appear in the GROUP BY clause or be used in an aggregate function --- RELEASE-NOTES | 4 +++- includes/specials/SpecialWantedtemplates.php | 2 +- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/RELEASE-NOTES b/RELEASE-NOTES index cb4546c5eb..d003ff515a 100644 --- a/RELEASE-NOTES +++ b/RELEASE-NOTES @@ -209,7 +209,9 @@ it from source control: http://www.mediawiki.org/wiki/Download_from_SVN * (bug 17538) Use shorter URLs in elements * (bug 13778) Hidden input added to the search form so that using the Enter key on IE will do a fulltext search like clicking the button does -* (bug 1061) CSS-added icons next to links display through the text and makes it unreadable in RTL +* (bug 1061) CSS-added icons next to links display through the text and makes + it unreadable in RTL +* Special:Wantedtemplates now works on PostgreSQL == API changes in 1.15 == * (bug 16858) Revamped list=deletedrevs to make listing deleted contributions diff --git a/includes/specials/SpecialWantedtemplates.php b/includes/specials/SpecialWantedtemplates.php index 43b5cf8f87..4010ef89e2 100644 --- a/includes/specials/SpecialWantedtemplates.php +++ b/includes/specials/SpecialWantedtemplates.php @@ -42,7 +42,7 @@ class WantedTemplatesPage extends QueryPage { FROM $templatelinks LEFT JOIN $page ON tl_title = page_title AND tl_namespace = page_namespace WHERE page_title IS NULL AND tl_namespace = ". NS_TEMPLATE ." - GROUP BY tl_title + GROUP BY tl_namespace, tl_title "; } -- 2.20.1