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]> 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]> 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]> > > 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
