Author: s_angelov
Description:
hello all,
after upgrading from mediawiki 1.13.4/postgresql 8.3.6 to mediawiki 1.14.1/postgresql 8.3.8 the following error appears when action=createivecommons is used (e.g. http://<myhost>/index.php?title=FAQ&action=creativecommons)
PHP Warning: pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: column "mwuser.user_id" must appear in the GROUP BY clause or be used in an aggregate function in /<mypath>/wiki/includes/db/DatabasePostgres.php on line 578
[Fri Jan 15 15:37:36 2010] [error] [client 85.118.192.131] PHP Stack trace:
[Fri Jan 15 15:37:36 2010] [error] [client 85.118.192.131] PHP 1. {main}() /<mypath>/wiki/index.php:0
[Fri Jan 15 15:37:36 2010] [error] [client 85.118.192.131] PHP 2. MediaWiki->initialize() /<mypath>/wiki/index.php:114
[Fri Jan 15 15:37:36 2010] [error] [client 85.118.192.131] PHP 3. MediaWiki->performAction() /<mypath>/wiki/includes/Wiki.php:63
[Fri Jan 15 15:37:36 2010] [error] [client 85.118.192.131] PHP 4. CreativeCommonsRdf->show() /<mypath>/wikiroot/wiki/includes/Wiki.php:483
[Fri Jan 15 15:37:36 2010] [error] [client 85.118.192.131] PHP 5. RdfMetaData->basics() /<mypath>/wiki/includes/Metadata.php:246
[Fri Jan 15 15:37:36 2010] [error] [client 85.118.192.131] PHP 6. Article->getContributors() /<mypath>/wiki/includes/Metadata.php:77
[Fri Jan 15 15:37:36 2010] [error] [client 85.118.192.131] PHP 7. Database->query() /<mypath>/wiki/includes/Article.php:675
[Fri Jan 15 15:37:36 2010] [error] [client 85.118.192.131] PHP 8. DatabasePostgres->doQuery() /<mypath>/wiki/includes/db/Database.php:570
[Fri Jan 15 15:37:36 2010] [error] [client 85.118.192.131] PHP 9. pg_query() /<mypath>/wiki/includes/db/DatabasePostgres.php:578
the machine runs opensolaris SXCE build 130, x64
Version: 1.14.x
Severity: normal
OS: Solaris
Platform: Other