Last modified: 2010-05-15 15:33:04 UTC
The query in Article::getContents() used for the metadata fails on PostgreSQL due to a bad GROUP BY. <b>Warning</b>: pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: column " old.old_user_text" must appear in the GROUP BY clause or be used in an aggregate function in <b>/var/www/html/gres/ includes/DatabasePostgreSQL.php</b> on line <b>96</b><br /> A database error has occurred Query: SELECT old_user, old_user_text, user_real_name, MAX(old_timestamp) as timestamp FROM "old" LEFT JOIN "user" ON old_user = user_id WHERE old_namespace = 1 AND old_title = '?efpa?o' AND old_user != 1 GROUP BY old_user ORDER BY timestamp DESC Function: Article::getContributors Error: 1 ERROR: column "old.old_user_text" must appear in the GROUP BY clause or be used in an aggregate function <p>Backtrace:</p> <ul> <li>DatabasePostgreSQL.php line 366 calls wfDebugDieBacktrace()</li> <li>Database.php line 297 calls DatabasePostgreSQL::reportQueryError()</li> <li>Article.php line 715 calls DatabasePostgreSQL::query()</li> <li>Metadata.php line 139 calls Article::getContributors()</li> <li>Metadata.php line 49 calls dcBasics()</li> <li>index.php line 149 calls wfCreativeCommonsRdf()</li>
Still failing: <b>Warning</b>: pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: column " user.user_real_name" must appear in the GROUP BY clause or be used in an aggregate function in <b>/var/www/html/gres/includes/ DatabasePostgreSQL.php</b> on line <b>96</b><br /> A database error has occurred Query: SELECT old_user, old_user_text, user_real_name, MAX(old_timestamp) as timestamp FROM "old" LEFT JOIN "user" ON old_user = user_id WHERE old_namespace = 1 AND old_title = '?efpa?o' AND old_user != 1 GROUP BY old_user, old_user_text ORDER BY timestamp DESC Function: Article::getContributors Error: 1 ERROR: column "user.user_real_name" must appear in the GROUP BY clause or be used in an aggregate function <p>Backtrace:</p> <ul> <li>DatabasePostgreSQL.php line 370 calls wfDebugDieBacktrace()</li> <li>Database.php line 297 calls DatabasePostgreSQL::reportQueryError()</li> <li>Article.php line 715 calls DatabasePostgreSQL::query()</li> <li>Metadata.php line 139 calls Article::getContributors()</li> <li>Metadata.php line 49 calls dcBasics()</li> <li>index.php line 149 calls wfCreativeCommonsRdf()</li>
should be working right now (In reply to comment #1) > Still failing: >
