Author: neubacher

Description:
A database error has occurred
Query: SELECT img_timestamp,img_name,img_user_text,img_size,img_description,COUNT(oi_archive_name),img_user FROM image LEFT JOIN oldimage ON ((oi_name = img_name)) GROUP BY img_name ORDER BY img_timestamp DESC LIMIT 51
Function: IndexPager::reallyDoQuery (ImageListPager)
Error: 1 ERROR: column "image.img_timestamp" must appear in the GROUP BY clause or be used in an aggregate function

Backtrace:

#0 /usr/share/mediawiki/phase3/includes/db/Database.php(616): DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'SELECT img_tim...', 'IndexPager::rea...', false)
#1 /usr/share/mediawiki/phase3/includes/db/Database.php(1026): Database->query('SELECT img_tim...', 'IndexPager::rea...')
#2 /usr/share/mediawiki/phase3/includes/Pager.php(256): Database->select(Array, Array, Array, 'IndexPager::rea...', Array, Array)
#3 /usr/share/mediawiki/phase3/includes/Pager.php(148): IndexPager->reallyDoQuery('', 51, false)
#4 /usr/share/mediawiki/phase3/includes/Pager.php(273): IndexPager->doQuery()
#5 /usr/share/mediawiki/phase3/includes/specials/SpecialListfiles.php(16): IndexPager->getBody()
#6 [internal function]: wfSpecialListfiles(NULL, Object(SpecialPage))
#7 /usr/share/mediawiki/phase3/includes/SpecialPage.php(750): call_user_func('wfSpecialListfi...', NULL, Object(SpecialPage))
#8 /usr/share/mediawiki/phase3/includes/SpecialPage.php(540): SpecialPage->execute(NULL)
#9 /usr/share/mediawiki/phase3/includes/Wiki.php(229): SpecialPage::executePath(Object(Title))
#10 /usr/share/mediawiki/phase3/includes/Wiki.php(59): MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest))
#11 /usr/share/mediawiki/phase3/index.php(114): MediaWiki->initialize(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest))
#12 {main}

Version: 1.15.x
Severity: normal
OS: Linux
Platform: PC
URL: http://www.diversitymobile.net/wiki/Special:ListFiles