Page MenuHomePhabricator

Unpatrolled edits don't work on plwiki
Closed, InvalidPublic

Description

I created a query to check two different anonymous edits on plwiki:

USE plwiki_p;
SELECT rc_timestamp, rc_this_oldid, rc_user_text, rc_title, rc_patrolled
FROM recentchanges
WHERE rc_this_oldid IN (43923000,43909677);

but something doesn't work because unpatrolled edits don't work on the plwiki database. For more details check the query: http://quarry.wmflabs.org/query/3342

The problem is that rc_patrolled is always 0. It's wrong because it should be 0 only if the edit hasn't been reviewed. For example: the first edit (diff 43909677) has been reviewed but in the resultset is marked as unreviewed: rc_patrolled = 0 (it should be rc_patrolled = 1). In the second example everything is alright because the second edit (diff 43923000) is unreviewed and in the resultset is marked as rc_patrolled = 0.

Event Timeline

The_Polish raised the priority of this task from to Needs Triage.
The_Polish updated the task description. (Show Details)
The_Polish added projects: DBA, Quarry.
The_Polish added a subscriber: The_Polish.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 26 2015, 6:20 PM

What? select sum(rc_patrolled = 1), sum(rc_patrolled = 0) from plwiki_p.recentchanges; shows some patrolled and some unpatrolled RCs.

I very much doubt this is an issue with Quarry itself.

Krenair set Security to None.
Umherirrender added a subscriber: Umherirrender.EditedOct 27 2015, 8:47 PM

According to the logs the edit where not patrolled - https://pl.wikipedia.org/w/index.php?title=Specjalna%3ARejestr&type=patrol&user=&page=Stanis%C5%82aw+Kie%C5%82basi%C5%84ski&year=&month=-1&tagfilter=

The edits are reviewed as part of the FlaggedRevs extension, but the column you are looking is not for that feature - https://pl.wikipedia.org/w/index.php?title=Specjalna%3ARejestr&type=review&user=&page=Stanis%C5%82aw+Kie%C5%82basi%C5%84ski&year=&month=-1&tagfilter=

For flagged revs you have to use the flaggedrevs table (or some of possible other tables of that extension)

Umherirrender closed this task as Invalid.Oct 27 2015, 8:47 PM
Umherirrender edited projects, added MediaWiki-General; removed DBA.