Last modified: 2007-02-28 16:29:58 UTC
Perhaps related to 9103, another one (and hopefully the last on Special Pages;-): Running a fresh install of 1.10A (SVN) on PostgreSQL I get the following error(s), when entering Categories in Special Pages: A database error has occurred Query: SELECT cl_to,count(*) count FROM categorylinks GROUP BY cl_to ORDER BY cl_to LIMIT 51 Function: IndexPager::reallyDoQuery (CategoryPager) Error: 1 ERROR: syntax error at or near "count" at character 72 Backtrace: #0 /var/www/wiki/includes/Database.php(677): DatabasePostgres->reportQueryError('ERROR: syntax ...', 1, 'SELECT cl_to,c...', 'IndexPager::rea...', false) #1 /var/www/wiki/includes/Database.php(1073): Database->query('SELECT cl_to,c...', 'IndexPager::rea...') #2 /var/www/wiki/includes/Pager.php(184): Database->select(Array, Array, Array, 'IndexPager::rea...', Array) #3 /var/www/wiki/includes/Pager.php(102): IndexPager->reallyDoQuery('', 51, true) #4 /var/www/wiki/includes/Pager.php(306): IndexPager->doQuery() #5 /var/www/wiki/includes/Pager.php(335): IndexPager->getPagingQueries() #6 /var/www/wiki/includes/Pager.php(414): IndexPager->getPagingLinks(Array) #7 /var/www/wiki/includes/SpecialCategories.php(13): AlphabeticPager->getNavigationBar() #8 /var/www/wiki/includes/SpecialPage.php(624): wfSpecialCategories(NULL, Object(SpecialPage)) #9 /var/www/wiki/includes/SpecialPage.php(430): SpecialPage->execute(NULL) #10 /var/www/wiki/includes/Wiki.php(180): SpecialPage::executePath(Object(Title)) #11 /var/www/wiki/includes/Wiki.php(45): MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest)) #12 /var/www/wiki/index.php(48): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User), Object(WebRequest)) #13 {main}
Fixed in r20062, thanks for the report. The fix was changing the query to "count(*) AS count"
Works! Thanks a lot!