[MediaWiki-l] Wiki problems: spam + MySQL errors

Bill Traynor btraynor at gmail.com
Tue Oct 14 03:10:52 UTC 2014


I think you'll want to "git checkout REL1_23" from the AbuseFilter
directory.  Then run update.php again.

On Mon, Oct 13, 2014 at 8:13 PM, Yves de Lyle <yvesdelyle at gmail.com> 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 <phoenixoverride at 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 at 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 at 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 at 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 at 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:
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l



More information about the MediaWiki-l mailing list