Extension talk:WatchAnalytics

About this board

A database query error has occurred.

4
Summary by Kghbln
Kghbln (talkcontribs)
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}
Kghbln (talkcontribs)
Olson.jared.m (talkcontribs)
Kghbln (talkcontribs)
Revansx (talkcontribs)

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!

Jamesmontalvo3 (talkcontribs)

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.

Revansx (talkcontribs)

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

Revansx (talkcontribs)

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?

Reply to "Scrutiny calculations"

Special:WatchAnalytics error

2
Harry0725 (talkcontribs)

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()
Kghbln (talkcontribs)
Reply to "Special:WatchAnalytics error"

Install on MW 1.27 problem

2
Harry0725 (talkcontribs)

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!

Harry0725 (talkcontribs)

Here's my config:

require_once "$IP/extensions/WatchAnalytics/WatchAnalytics.php";
$egWatchAnalyticsPageScoreNamespaces = array( 'NS_MAIN' );
$egPendingReviewsEmphasizeDays = '0';
$egPendingReviewsNumberWatchSuggestions = '20';
$egPendingReviewsShowWatchSuggestionsIfReviewsUnder = '0';
Reply to "Install on MW 1.27 problem"
There are no older topics
Return to "WatchAnalytics" page.