Extension talk:WatchAnalytics/Flow

For 1.35 one needs to checkout current master of the extension: https://github.com/enterprisemediawiki/WatchAnalytics/commit/adf3421bde0547540ea4605495890c46a317bc22

Issue

After upgrading from MW 1.27 to MW 1.35 as well as to version 3.2.0 of this extension and Approved Revs in version 1.6 I get database errors. We are now on PHP 7.4 and MySQL 8.0.15.

[YVwhneaiTeL15Llc2pRsnAAAAAg] /index.php/Special:PendingReviews Wikimedia\Rdbms\DBQueryError from line 1699 of /mediawiki/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Error

Error 1054: Unknown column 'l.log_user' in 'field list' (mysql.database.example.com)

Function: PendingReview::getDeletionLog

Query: SELECT l.log_id,l.log_type,l.log_action,l.log_timestamp,l.log_user,l.log_user_text,l.log_namespace,l.log_title,l.log_page,l.log_comment_id,l.log_params,l.log_deleted,c.comment_id,c.comment_text AS log_comment FROM `logging` `l` INNER JOIN `comment` `c` ON ((l.log_comment_id=c.comment_id)) WHERE l.log_title='UserName' AND l.log_namespace=2 AND l.log_timestamp>=20201015052826

AND l.log_type IN ('delete','move') ORDER BY l.log_timestamp ASC

Backtrace

#0 /mediawiki/w/includes/libs/rdbms/database/Database.php(1683): Wikimedia\Rdbms\Database->getQueryException()
#1 /mediawiki/w/includes/libs/rdbms/database/Database.php(1658): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#2 /mediawiki/w/includes/libs/rdbms/database/Database.php(1227): Wikimedia\Rdbms\Database->reportQueryError()
#3 /mediawiki/w/includes/libs/rdbms/database/Database.php(1907): Wikimedia\Rdbms\Database->query()
#4 /mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select()
#5 /mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call()
#6 /mediawiki/w/extensions/WatchAnalytics/includes/PendingReview.php(288): Wikimedia\Rdbms\DBConnRef->select()
#7 /mediawiki/w/extensions/WatchAnalytics/includes/PendingReview.php(116): PendingReview->getDeletionLog()
#8 /mediawiki/w/extensions/WatchAnalytics/includes/PendingReview.php(187): PendingReview->__construct()
#9 /mediawiki/w/extensions/WatchAnalytics/specials/SpecialPendingReviews.php(126): PendingReview::getPendingReviewsList()
#10 /mediawiki/w/includes/specialpage/SpecialPage.php(600): SpecialPendingReviews->execute()
#11 /mediawiki/w/includes/specialpage/SpecialPageFactory.php(635): SpecialPage->run()
#12 /mediawiki/w/includes/MediaWiki.php(307): MediaWiki\SpecialPage\SpecialPageFactory->executePath()
#13 /mediawiki/w/includes/MediaWiki.php(940): MediaWiki->performRequest()
#14 /mediawiki/w/includes/MediaWiki.php(543): MediaWiki->main()
#15 /mediawiki/w/index.php(53): MediaWiki->run()
#16 /mediawiki/w/index.php(46): wfIndexMain()
#17 {main}

Also reported on GitHub with issue 119

Hi Karsten, @revansx and I ran into this issue too, me on 1.35.5. It's resolved by #113 which is waiting to be merged. If you want to help you could try the changes in this commit locally and comment on the pull request if it works for you.

Commented on GitHub:https://github.com/enterprisemediawiki/WatchAnalytics/issues/119#issuecomment-1110283180

In the meantime the fix was merged. I replied here: https://github.com/enterprisemediawiki/WatchAnalytics/issues/119#issuecomment-1110512607

Watch Analytics provides two numbers:

1. Reviews, and
2. Scrutiny

Reviews is clearly the number of reviews limited by the number of reviewers,

My users are asking me how Scrutiny is calculated. Is this stated somewhere in the documentation and I have missed it? or is this something you can explain a little better here? Thanks!

It's calculated based upon how many watchers and how "good" at watching those watchers are. IIRC, how good they are is based entirely upon how big/old their list of pending reviews is. Ideally it'd take into account historically how good they've been, and perhaps other factors like how many thanks they've gotten, what groups they're in, etc. A highly active sysop being more effective at watching a page than an inactive newbie...so the sysop gives more to the scrutiny score.

I understand your answer, but, assuming a page has a scrutiny value of "X", the basic question I keep getting is, "X on a scale of what? X out of 5? X our of 100?". My audience is a lot of engineers :-P

what is the highest value of scrutiny possible by the extension? or is it's max value a function of the total number of users?

Another question, I got this error at Special:WatchAnalytics:

WatchAnalytics Error from line 28 of /var/lib/mediawiki/extensions/WatchAnalytics/specials/SpecialWatchAnalytics.php: Call to undefined function wfCheckLimits()

I'd report this on GitHub

I try to installl this extension on MW 1.27. Since that, I always got a bigger shaking string on top-right toolbar saying "28 reviews (oldest: 131 days)". The value never changed and show up the same content at every page, even in Special pages. That's not what I want.

Setting config as mentioned in article seems like NOT to work.

And I'm wondering how to get score icon on top-right just like following pic.

Or I got something wrong, pls somebody help.

Thanks!

Here's my config:

require_once "$IP/extensions/WatchAnalytics/WatchAnalytics.php";
$egWatchAnalyticsPageScoreNamespaces = array( 'NS_MAIN' );
$egPendingReviewsEmphasizeDays = '0';
$egPendingReviewsNumberWatchSuggestions = '20';
$egPendingReviewsShowWatchSuggestionsIfReviewsUnder = '0';