Last modified: 2012-08-04 20:48:52 UTC
I'm running 1.14.0 on PostreSQL 8.3.3. I get this error when visiting Special:ListFiles: 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 /var/www/html/phagosys/includes/db/Database.php(591): DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'SELECT img_tim...', 'IndexPager::rea...', false) #1 /var/www/html/phagosys/includes/db/Database.php(1001): Database->query('SELECT img_tim...', 'IndexPager::rea...') #2 /var/www/html/phagosys/includes/Pager.php(256): Database->select(Array, Array, Array, 'IndexPager::rea...', Array, Array) #3 /var/www/html/phagosys/includes/Pager.php(148): IndexPager->reallyDoQuery('', 51, false) #4 /var/www/html/phagosys/includes/Pager.php(273): IndexPager->doQuery() #5 /var/www/html/phagosys/includes/specials/SpecialListfiles.php(16): IndexPager->getBody() #6 [internal function]: wfSpecialListfiles(NULL, Object(SpecialPage)) #7 /var/www/html/phagosys/includes/SpecialPage.php(749): call_user_func('wfSpecialListfi...', NULL, Object(SpecialPage)) #8 /var/www/html/phagosys/includes/SpecialPage.php(539): SpecialPage->execute(NULL) #9 /var/www/html/phagosys/includes/Wiki.php(226): SpecialPage::executePath(Object(Title)) #10 /var/www/html/phagosys/includes/Wiki.php(59): MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest)) #11 /var/www/html/phagosys/index.php(114): MediaWiki->initialize(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest)) #12 {main}
*** This bug has been marked as a duplicate of bug 17676 ***