https://bugzilla.wikimedia.org/show_bug.cgi?id=17676
Summary: ListFiles: Internal Error
Product: MediaWiki
Version: 1.15-svn
Platform: PC
URL: http://www.diversitymobile.net/wiki/Special:ListFiles
OS/Version: Linux
Status: NEW
Severity: enhancement
Priority: Normal
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
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}
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
