Last modified: 2012-08-04 20:48:59 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 T20076, the corresponding Phabricator task for complete and up-to-date bug report information.

Bug 18076 - AbuseFilter schemas for PostgreSQL are out of date


Summary:	AbuseFilter schemas for PostgreSQL are out of date

Status:	RESOLVED FIXED

Product:	MediaWiki extensions
Classification:	Unclassified
Component:	AbuseFilter (Other open bugs)
Version:	unspecified
Hardware:	All All

Importance:	Normal normal (vote)
Target Milestone:	---
Assigned To:	Andrew Garrett

URL:
Whiteboard:
Keywords:	patch

Depends on:
Blocks:	postgres
	Show dependency tree / graph

Reported:	2009-03-21 01:56 UTC by Brad Jorsch
Modified:	2012-08-04 20:48 UTC (History)
CC List:	2 users (show)

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

Attachments
Patch against r48647 to update database schemas for PG (9.83 KB, patch) 2009-03-21 01:56 UTC, Brad Jorsch	Details
Add an attachment (proposed patch, testcase, etc.)

Description Brad Jorsch 2009-03-21 01:56:07 UTC

Created attachment 5947 [details]
Patch against r48647 to update database schemas for PG

The database schemas for AbuseFilter for PostgreSQL are out of date, and the "upgrade.php" hook is completely broken.

This patch fixes it for me, but I don't know whether it's the best way to do it. BTW, why does the MySQL schema use bigints all over the place, while the out-of-date PG schema uses integers?

Comment 1 Greg Sabino Mullane 2009-03-23 13:27:29 UTC

Not sure why they were using bigint - but I saw no reason to do so in the Postgres schema, as it is very unlikely that any wiki is going to have over 2 billion distinct users, 2 billion different filters, etc.

Comment 2 Greg Sabino Mullane 2009-03-23 14:19:38 UTC

Thanks for the patch, applied a slightly modified version in r48704. The indexes may still need tuning.

Wikimedia Bugzilla is closed!

Search

Personal tools

Navigation

Links