Author: mathias.behrle
Description:
This one is similar to 9097, but IMHO too different to add it there. Running a
fresh install of 1.10A (SVN) on PostgreSQL I get the following error(s), when
entering Protected Pages in Special Pages:
A database error has occurred Query: SELECT page_id, page_restrictions.*,
page_title,page_namespace FROM page_restrictions,page WHERE
(pr_expiry>'2007-02-25 17:19:42 GMT') AND (page_id=pr_page) GROUP BY page_id
ORDER BY pr_id DESC LIMIT 51 Function: IndexPager::reallyDoQuery
(ProtectedPagesPager) Error: 1 ERROR: column "pr_id" does not exist
Backtrace:
#0 /var/www/wiki/includes/Database.php(672):
DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'SELECT page_id...',
'IndexPager::rea...', false)
#1 /var/www/wiki/includes/Database.php(1068): Database->query('SELECT
page_id...', 'IndexPager::rea...')
#2 /var/www/wiki/includes/Pager.php(184): Database->select(Array, 'page_id,
page_r...', Array, 'IndexPager::rea...', Array)
#3 /var/www/wiki/includes/Pager.php(102): IndexPager->reallyDoQuery('', 51, false)
#4 /var/www/wiki/includes/Pager.php(296): IndexPager->doQuery()
#5 /var/www/wiki/includes/SpecialProtectedpages.php(27): IndexPager->getNumRows()
#6 /var/www/wiki/includes/SpecialProtectedpages.php(137):
ProtectedPagesForm->showList()
#7 /var/www/wiki/includes/SpecialPage.php(624): wfSpecialProtectedpages(NULL,
Object(SpecialPage))
#8 /var/www/wiki/includes/SpecialPage.php(430): SpecialPage->execute(NULL)
#9 /var/www/wiki/includes/Wiki.php(180): SpecialPage::executePath(Object(Title))
#10 /var/www/wiki/includes/Wiki.php(45):
MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage),
Object(WebRequest))
#11 /var/www/wiki/index.php(48): MediaWiki->initialize(Object(Title),
Object(OutputPage), Object(User), Object(WebRequest))
#12 {main}
After having created column "pr_id" the next error is:
A database error has occurred Query: SELECT page_id, page_restrictions.*,
page_title,page_namespace FROM page_restrictions,page WHERE
(pr_expiry>'2007-02-25 17:26:33 GMT') AND (page_id=pr_page) GROUP BY page_id
ORDER BY pr_id DESC LIMIT 51 Function: IndexPager::reallyDoQuery
(ProtectedPagesPager) Error: 1 ERROR: column "page_restrictions.pr_page" must
appear in the GROUP BY clause or be used in an aggregate function
Backtrace:
#0 /var/www/wiki/includes/Database.php(672):
DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'SELECT page_id...',
'IndexPager::rea...', false)
#1 /var/www/wiki/includes/Database.php(1068): Database->query('SELECT
page_id...', 'IndexPager::rea...')
#2 /var/www/wiki/includes/Pager.php(184): Database->select(Array, 'page_id,
page_r...', Array, 'IndexPager::rea...', Array)
#3 /var/www/wiki/includes/Pager.php(102): IndexPager->reallyDoQuery('', 51, false)
#4 /var/www/wiki/includes/Pager.php(296): IndexPager->doQuery()
#5 /var/www/wiki/includes/SpecialProtectedpages.php(27): IndexPager->getNumRows()
#6 /var/www/wiki/includes/SpecialProtectedpages.php(137):
ProtectedPagesForm->showList()
#7 /var/www/wiki/includes/SpecialPage.php(624): wfSpecialProtectedpages(NULL,
Object(SpecialPage))
#8 /var/www/wiki/includes/SpecialPage.php(430): SpecialPage->execute(NULL)
#9 /var/www/wiki/includes/Wiki.php(180): SpecialPage::executePath(Object(Title))
#10 /var/www/wiki/includes/Wiki.php(45):
MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage),
Object(WebRequest))
#11 /var/www/wiki/index.php(48): MediaWiki->initialize(Object(Title),
Object(OutputPage), Object(User), Object(WebRequest))
#12 {main}
Version: unspecified
Severity: normal
OS: Linux
Platform: PC