Last modified: 2012-08-04 20:48:44 UTC
When trying to execute one of the maintenance scripts, it fails because it was sending a query with the reserved word "DISTINCTROW" to the Postgres database server of my installation. Postgres does not support this word. The scrip: ..../maintenance$ php deleteOldRevisions.php --delete 76 The error is on the query: SELECT DISTINCTROW rev_text_id FROM revision The workaround: Edit the file purgeOldText.inc, in the lines 23 and 31, replacing the text "DISTINCTROW" with "DISTINCT" Tip: Doing a little search it appears that "DISTINCTROW" is not standard SQL. I suggest replacing all references to "DISTINCTROW" to "DISTINCT" in futures releases of MediaWiki.
Fixed in r51858. That appears to be the only use of DISTINCTROW.