https://bugzilla.wikimedia.org/show_bug.cgi?id=19160
Web browser: Mozilla Firefox 3.0.x
Summary: DISTINCTROW with Postgres
Product: MediaWiki
Version: 1.15.0
Platform: All
OS/Version: All
Status: NEW
Keywords: postgresql
Severity: minor
Priority: Normal
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
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.
--
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
