Last modified: 2012-08-04 20:48:44 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T21160, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 19160 - DISTINCTROW with Postgres
DISTINCTROW with Postgres
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.15.x
All All
: Normal minor (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks: postgres
  Show dependency tree / graph
 
Reported: 2009-06-11 15:52 UTC by Mario A. Guerra
Modified: 2012-08-04 20:48 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Mario A. Guerra 2009-06-11 15:52:53 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.
Comment 1 Alex Z. 2009-06-15 03:11:05 UTC 
Fixed in r51858. That appears to be the only use of DISTINCTROW.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links