Page MenuHomePhabricator

ListFiles: Internal Error (Postgres)
Closed, ResolvedPublic

Description

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

Details

Reference
bz17676

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
InvalidNone
ResolvedNone

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:32 PM
bzimport set Reference to bz17676.
bzimport added a subscriber: Unknown Object (MLST).
  • Bug 17887 has been marked as a duplicate of this bug. ***
Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.