That is probably the problem then, Go ahead and remove the abuse filter extension and download the 1.23 version https://www.mediawiki.org/wiki/Special:ExtensionDistributor?extdist_extension=AbuseFilter&extdist_version=REL1_23&extdist_submit=Continue and see if that works. Odds are the extension you downloaded is for 1.24 or even 1.25 alpha
On Mon, Oct 13, 2014 at 8:13 PM, Yves de Lyle <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> > > 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 <[email protected] > > > <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 <[email protected] > > > <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 < > [email protected] > > > <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: > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
