Last modified: 2012-08-04 20:48:40 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T19676, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 17676 - ListFiles: Internal Error (Postgres)
ListFiles: Internal Error (Postgres)
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.15.x
PC Linux
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
http://www.diversitymobile.net/wiki/S...
:
: 17887 (view as bug list)
Depends on:
Blocks: postgres
  Show dependency treegraph
 
Reported: 2009-02-26 13:55 UTC by Dieter Neubacher
Modified: 2012-08-04 20:48 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Dieter Neubacher 2009-02-26 13:55:30 UTC
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}
Comment 1 Greg Sabino Mullane 2009-03-12 14:25:53 UTC
*** Bug 17887 has been marked as a duplicate of this bug. ***
Comment 2 Greg Sabino Mullane 2009-03-12 14:26:55 UTC
Fix committed in r48350

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links