I think it was the current version. I used git clone
to install it
directly.
The Special:Version page does not list the version number of AbuseFilter,
except for
*(ca5be08).
<https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/extensions/AbuseFilter.git;h=ca5be08f5b69f683575a9d6e19d4d98801f200f1>*
*Jamie*
*
<https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/extensions/AbuseFilter.git;h=ca5be08f5b69f683575a9d6e19d4d98801f200f1>*
On 14 October 2014 10:34, John <phoenixoverride(a)gmail.com> wrote:
When you downloaded abuse filter did you get the
1.23 version or did you
just get the current version?
On Monday, October 13, 2014, Justin Folvarcik <jfolvarcik(a)gmail.com>
wrote:
In that case, I don't know. I suggest talking
to the folks at #mediawiki
on
the freenode IRC. They usually know how to sort
out AbuseFilter problems.
Sorry I can't help you anymore.
----
Justin Folvarcik
On Mon, Oct 13, 2014 at 7:20 PM, Yves de Lyle <yvesdelyle(a)gmail.com
<javascript:;>> wrote:
> I have run update.php when I installed the AbuseFilter and again later.
> I was planning an upgrade to mediawiki 1.23, but I ran in to this
problem
when
backing up the database. So I have not upgraded yet.
What should I be looking for in the update response?
MediaWiki 1.20.2 Updater
Going to run database updates for cunnan
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds (skip this countdown with
--quick)
... 0
...have ipb_id field in ipblocks table.
...have ipb_expiry field in ipblocks table.
...already have interwiki table
...indexes seem up to 20031107 standards.
...hitcounter table already exists.
...have rc_type field in recentchanges table.
...have user_real_name field in user table.
...querycache table already exists.
...objectcache table already exists.
...categorylinks table already exists.
...have pagelinks; skipping old links table updates
...il_from OK
...have rc_ip field in recentchanges table.
...index PRIMARY already set on image table.
...have rc_id field in recentchanges table.
...have rc_patrolled field in recentchanges table.
...logging table already exists.
...have user_token field in user table.
...have wl_notificationtimestamp field in watchlist table.
...watchlist talk page rows already present.
...user table does not contain user_emailauthenticationtimestamp field.
...page table already exists.
...have log_params field in logging table.
...logging table has correct log_title encoding.
...have ar_rev_id field in archive table.
...have page_len field in page table.
...revision table does not contain inverse_timestamp field.
...have rev_text_id field in revision table.
...have rev_deleted field in revision table.
...have img_width field in image table.
...have img_metadata field in image table.
...have user_email_token field in user table.
...have ar_text_id field in archive table.
...page_namespace is already a full int (int(11)).
...ar_namespace is already a full int (int(11)).
...rc_namespace is already a full int (int(11)).
...wl_namespace is already a full int (int(11)).
...qc_namespace is already a full int (int(11)).
...log_namespace is already a full int (int(11)).
...have img_media_type field in image table.
...already have pagelinks table.
...image table does not contain img_type field.
...already have unique user_name index.
...user_groups table exists and is in current format.
...have ss_total_pages field in site_stats table.
...user_newtalk table already exists.
...transcache table already exists.
...have iw_trans field in interwiki table.
...wl_notificationtimestamp is already nullable.
...index times already set on logging table.
...have ipb_range_start field in ipblocks table.
...no page_random rows needed to be set
...have user_registration field in user table.
...templatelinks table already exists
...externallinks table already exists.
...job table already exists.
...have ss_images field in site_stats table.
...langlinks table already exists.
...querycache_info table already exists.
...filearchive table already exists.
...have ipb_anon_only field in ipblocks table.
...index rc_ns_usertext already set on recentchanges table.
...index rc_user_text already set on recentchanges table.
...have user_newpass_time field in user table.
...redirect table already exists.
...querycachetwo table already exists.
...have ipb_enable_autoblock field in ipblocks table.
...index pl_namespace on table pagelinks includes field pl_from.
...index tl_namespace on table templatelinks includes field tl_from.
...index il_to on table imagelinks includes field il_from.
...have rc_old_len field in recentchanges table.
...have user_editcount field in user table.
...page_restrictions table already exists.
...have log_id field in logging table.
...have rev_parent_id field in revision table.
...have pr_id field in page_restrictions table.
...have rev_len field in revision table.
...have rc_deleted field in recentchanges table.
...have log_deleted field in logging table.
...have ar_deleted field in archive table.
...have ipb_deleted field in ipblocks table.
...have fa_deleted field in filearchive table.
...have ar_len field in archive table.
...have ipb_block_email field in ipblocks table.
...index cl_sortkey on table categorylinks includes field cl_from.
...have oi_metadata field in oldimage table.
...index usertext_timestamp already set on archive table.
...index img_usertext_timestamp already set on image table.
...index oi_usertext_timestamp already set on oldimage table.
...have ar_page_id field in archive table.
...have img_sha1 field in image table.
...protected_titles table already exists.
...have ipb_by_text field in ipblocks table.
...page_props table already exists.
...updatelog table already exists.
...category table already exists.
...category table already populated.
...have ar_parent_id field in archive table.
...have user_last_timestamp field in user_newtalk table.
...protected_titles table has correct pt_title encoding.
...have ss_active_users field in site_stats table.
...ss_active_users user count set...
...have ipb_allow_usertalk field in ipblocks table.
...pl_namespace, tl_namespace, il_to indices are already UNIQUE.
...change_tag table already exists.
...tag_summary table already exists.
...valid_tag table already exists.
...user_properties table already exists.
...log_search table already exists.
...have log_user_text field in logging table.
...l10n_cache table already exists.
...external_user table already exists.
...index ls_field_val already set on log_search table.
...index change_tag_rc_tag already set on change_tag table.
...have rd_interwiki field in redirect table.
...transcache tc_time already converted.
...eu_wiki_id already renamed to eu_local_id.
...*_mime_minor fields are already long enough.
...iwlinks table already exists.
...index iwl_prefix_title_from already set on iwlinks table.
...have ul_value field in updatelog table.
...have iw_api field in interwiki table.
...iwl_prefix key doesn't exist.
...iwl_prefix_from_title key doesn't exist.
...have cl_collation field in categorylinks table.
...categorylinks up-to-date.
...collations up-to-date.
...msg_resource table already exists.
...module_deps table already exists.
...ar_page_revid key doesn't exist.
...index ar_revid already set on archive table.
...ll_lang is up-to-date.
...user_last_timestamp is already nullable.
...index user_email already set on user table.
...up_property in table user_properties already modified by patch
patch-up_property.sql.
...uploadstash table already exists.
...user_former_groups table already exists.
...index type_action already set on logging table.
...batch conversion of user_options: nothing to migrate. done.
...user table does not contain user_options field.
...have rev_sha1 field in revision table.
...have ar_sha1 field in archive table.
...index page_redirect_namespace_len already set on page table.
...ug_group in table user_groups already modified by patch
patch-ug_group-length-increase.sql.
...have us_chunk_inx field in uploadstash table.
...have job_timestamp field in job table.
...ufg_group in table user_former_groups already modified by patch
patch-ufg_group-length-increase.sql.
...index page_user_timestamp already set on revision table.
...have ipb_parent_block_id field in ipblocks table.
...index ipb_parent_block_id already set on ipblocks table.
...category table does not contain cat_hidden field.
...spoofuser table already exists.
...abuse_filter table already exists.
...abuse_filter_history table already exists.
...have afh_changed_fields field in abuse_filter_history table.
...have af_deleted field in abuse_filter table.
...have af_actions field in abuse_filter table.
...have af_global field in abuse_filter table.
...have afl_rev_id field in abuse_filter_log table.
...index filter_timestamp already set on abuse_filter_log table.
...have af_group field in abuse_filter table.
...index wiki_timestamp already set on abuse_filter_log table.
...afl_namespace in table abuse_filter_log already modified by patch
/sca-data/rsynced_files_from_cat/disk/home/sca/public_html/cunnan/extensions/AbuseFilter/db_patches/patch-afl-namespace_int.sql.
...site_stats is populated...done.
Purging caches...done.
Done.
RC_external is not mentioned at all.
Jamie
On 14 October 2014 02:41, Justin Folvarcik <jfolvarcik(a)gmail.com
<javascript:;>> wrote:
> Did you recently upgrade? Maybe someone forgot to run
> maintenance/update.php? It looks like you're missing a column in the
> AbuseFilter table. The first thing I would try is running update.php
from
> the command line. You'll find it in the
maintenance directory of your
wiki.
> If that fails, it could still provide more insight into what's wrong.
>
> ----
> Justin Folvarcik
>
> On Mon, Oct 13, 2014 at 6:36 AM, Yves de Lyle <yvesdelyle(a)gmail.com
<javascript:;>>
> wrote:
>
> > Hi All,
> >
> > Sorry if this is the wrong place for this. But I've inherited admin
of
a
> > wiki, Cunnan <http://cunnan.lochac.sca.org/wiki/Main_Page>, and it
has
> > some
> > problems with Spammers. I've setup ConfirmEdit's Question-base
CAPTCHA,
> > AntiSpoof and AbuseFilter to deal with
them. However, I can not get
> > AbuseFilter working with the wiki going blank on submitting of an
edit,
> > so
> > > it is un-implemented. I have read the Extension page, but it does
not
> > > explain what is going on.
Everytime I have attempted to Test a
simple
> >
filter the function has returned a 'Database Error'.
> >
> > ======================================
> > A database query syntax error has occurred. This may indicate a bug
in
> the
> > software. The last attempted database query was:
> >
> > (SQL query hidden)
> >
> > from within function "AbuseFilterViewTestBatch::doTest". Database
> returned
> > error "1054: Unknown column 'RC_EXTERNAL' in 'where
clause'
(localhost)".
> > ========================================
> >
> > And now when I try to mysqldump a backup I get .......
> > mysqldump: Couldn't execute 'show create table `temp`': View
> 'cunnan.temp'
> > references invalid table(s) or column(s) or function(s) or
> definer/invoker
> > of view lack rights to use them (1356)
> >
> > Or with a purgingOldText.php I get ....
> > Error: 1064 You have an error in your SQL syntax; check the manual
that
> > > corresponds to your MySQL server version for the right syntax to
use
> > near '
> > > 27687, 27751, 27752, 27757, 27817, 27821, 27816, 27818, 27829,
27828,
> >
27843, 27' at line 1 (localhost)
> >
> >
> > So I suspect there is a database error, but I don't know where to
find
> it.
> >
> >
> > Cheers,
> > Jamie
> > _______________________________________________
> > MediaWiki-l mailing list
> > To unsubscribe, go to:
> >
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> >
> _______________________________________________
> MediaWiki-l mailing list
> To unsubscribe, go to:
>
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
--
Yours in Service,
Yves de Lyle,
Company of the Black Dolphin
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
--
Yours in Service,
Yves de Lyle,
Company of the Black Dolphin
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to: