Author: mguerra13
Description:
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.
Version: 1.15.x
Severity: minor