Last modified: 2012-08-04 20:48:52 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 T19887, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 17887 - Special:ListFiles problem with PostgreSQL
Special:ListFiles problem with PostgreSQL
Status: RESOLVED DUPLICATE of bug 17676
Product: MediaWiki
Classification: Unclassified
Special pages (Other open bugs)
1.14.x
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks: postgres
  Show dependency treegraph
 
Reported: 2009-03-09 16:59 UTC by Mark Woodbridge
Modified: 2012-08-04 20:48 UTC (History)
2 users (show)

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


Attachments

Description Mark Woodbridge 2009-03-09 16:59:06 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}
Comment 1 Greg Sabino Mullane 2009-03-12 14:25:53 UTC

*** This bug has been marked as a duplicate of bug 17676 ***

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


Navigation
Links