Topic on Extension talk:AbuseFilter

Special:AbuseLog not showing actions taken

11
Justin C Lloyd (talkcontribs)

I just upgraded our wikis from 1.30 to 1.34 and now the Special:AbuseLog page (e.g. when clicking a value in the Hit count column on Special:AbuseFilter) is not showing any results. There are no errors anywhere I can find, and examining the database tables (i.e. select afl_filter, count(afl_filter) from abuse_filter_log group by afl_filter) does show the results there and the row counts correspond to the filter ids. Is this possibly a bug or perhaps is there something I may have missed doing during the upgrade procedure?


Daimona Eaytoy (talkcontribs)

As long as you followed the usual update procedure (notably, update core, update AbuseFilter, run update.php), this could indicate some sort of bug. However, I'm not aware of similar bugs. Could you please check (e.g. by using the debugging toolbar) what query is being executed on Special:AbuseLog, and try executing it manually on the DB?

Justin C Lloyd (talkcontribs)

I enabled the variable, along with $wgDebugDumpSql and even $wgDebugLogFile for good measure. However, I'm not even seeing the toolbar that should be there (which I've never used, so this is good to know about in general).


Daimona Eaytoy (talkcontribs)

Hmmm, weird. In theory, $wgDebugToolbar should be enough to enable the toolbar. Without knowing what query is being executed, it's hard to determine where the problem lies. Perhaps you could try other methods to inspect what queries are reaching your DB, like with pure mysql logging, although that could be a bit noisy. Of note, what RDBMS are you using?

Justin C Lloyd (talkcontribs)

Ah it's because I'm using Varnish so $wgUseSquid is enabled.


Justin C Lloyd (talkcontribs)

I'm using AWS Aurora MySQL (5.6 compatible).

Justin C Lloyd (talkcontribs)

I think this may be the query in question:

SELECT  *  FROM `abuse_filter_log` LEFT JOIN `abuse_filter` ON ((af_id=afl_filter))   WHERE afl_filter = '28' AND afl_deleted = '0'  ORDER BY afl_timestamp DESC LIMIT 51

I noticed that in the debug log.


Apparently if I take out the afl_deleted check, it seems to work.

Seems that all of the afl_deleted values are NULL.

Justin C Lloyd (talkcontribs)

Ok it seems like I need to add abuse-filter-hidden-log group permissions, that seems to resolve it. Just curious why that would be needed now, if you might have any idea.


Daimona Eaytoy (talkcontribs)

Ahhh, this is T240895... It should really be fixed and backported. In the meanwhile, you can manually run the SQL commands here to unbreak the world.

Justin C Lloyd (talkcontribs)

Thanks! I've tested the SQL queries against one of my dev wikis and it looks to have worked. Appreciate the help!

Reply to "Special:AbuseLog not showing actions taken"