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
