I was told on IRC to report this, so here goes.
Installing AbuseFilter-REL1_24-782f0f8.tar.gz on a wiki using:
MediaWiki 1.24.1
PHP 5.6.5 (cgi-fcgi)
PostgreSQL 9.3.5
- When navigating to Special:AbuseFilter
Query: SELECT af_id,af_enabled,af_deleted,af_global,af_public_comments,af_hidden,af_hit_count,af_timestamp,af_user_text,af_user,af_actions,af_group FROM "abuse_filter" WHERE af_deleted = '0' ORDER BY af_id LIMIT 51 Function: IndexPager::buildQueryInfo (AbuseFilterPager) Error: 42703 ERROR: column "af_group" does not exist LINE 1: ...ount,af_timestamp,af_user_text,af_user,af_actions,af_group ... ^
This is because the abusefilter.tables.pg.sql doesn't define the af_group like the abusefilter.tables.sql does.
Alter table abuse_filter add column af_group text; fixes the immediate problem...
- Trying to import a new rule results in this: SELECT af_hidden FROM "abuse_filter" WHERE af_id = 'new' LIMIT 1
Which is acknowledged at the top of abusefilter.tables.pg.sql
However, even in MYSQL af_id is defined as a BIGINT - so looks like the query is just wrong, even for MYSQL.