[Bug 57617] watchlist table not available on labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=57617 Dispenser dispen...@toolserver.org changed: What|Removed |Added Blocks||66868 -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 57617] watchlist table not available on labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=57617 Rodrigo Sampaio Primo rodrigospr...@gmail.com changed: What|Removed |Added CC||rodrigospr...@gmail.com --- Comment #9 from Rodrigo Sampaio Primo rodrigospr...@gmail.com --- Any progress on this? I would like to get the average number of watchers for the Portuguese Wikipedia and the number of watchers for a group of articles. So the solution proposed by MZMcBride works in my case. While we don't have access to the watchlist table, is there an alternative way to get this information? -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 57617] watchlist table not available on labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=57617 Silke Meyer (WMDE) silke.me...@wikimedia.de changed: What|Removed |Added CC||silke.me...@wikimedia.de Blocks||58791 -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 57617] watchlist table not available on labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=57617 --- Comment #8 from Tim Landscheidt t...@tim-landscheidt.de --- (In reply to MZMcBride from comment #7) [...] If we split out ts_wl_user_touched_cropped to a separate ticket, there shouldn't be any issue with exposing only wl_namespace and wl_title (for now). This allows users to count the number of rows (to determine the number of page watchers of a particular title), but gives away no personal data. In my mind, exposing wl_namespace and wl_title alone don't rise to the level of requiring legal approval, but I guess it can't hurt to ask. :-) If an equivalent for ts_wl_user_touched_cropped wouldn't be approved leaving only (wl_namespace, wl_title), from a performance perspective it would probably be very useful to not expose that table at all, but provide those count aggregates as hourly/daily snapshots (or optimize the indexes/views for this specific query). -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 57617] watchlist table not available on labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=57617 MZMcBride b...@mzmcbride.com changed: What|Removed |Added CC||b...@mzmcbride.com --- Comment #7 from MZMcBride b...@mzmcbride.com --- (In reply to Luis Villa (WMF Legal) from comment #6) Am I correct in understanding that the sanitization here is (1) remove wl_user and (2) the sanitized user_touch? (But that as with bug 58196, this is on a per-wiki basis, so the sanitization of user_touch to a particular date may not be strong enough for particular wikis?) Yes, wl_user is definitely unavailable. And yes, ts_wl_user_touched_cropped has similar issues as those mentioned in bug 58196. If we split out ts_wl_user_touched_cropped to a separate ticket, there shouldn't be any issue with exposing only wl_namespace and wl_title (for now). This allows users to count the number of rows (to determine the number of page watchers of a particular title), but gives away no personal data. In my mind, exposing wl_namespace and wl_title alone don't rise to the level of requiring legal approval, but I guess it can't hurt to ask. :-) -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 57617] watchlist table not available on labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=57617 --- Comment #6 from Luis Villa (WMF Legal) lvi...@wikimedia.org --- I have been handling these generally, but wasn't cc'd on this one so didn't know about it. Andre, lets discuss separately if some other approach makes sense for consistent notifications around bugzilla/legal. May also want to see discussion at bug 58196. Am I correct in understanding that the sanitization here is (1) remove wl_user and (2) the sanitized user_touch? (But that as with bug 58196, this is on a per-wiki basis, so the sanitization of user_touch to a particular date may not be strong enough for particular wikis?) -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 57617] watchlist table not available on labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=57617 Steinsplitter steinsplitter-w...@live.com changed: What|Removed |Added CC||steinsplitter-w...@live.com --- Comment #3 from Steinsplitter steinsplitter-w...@live.com --- *???* no reply since 2013-12-04... -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 57617] watchlist table not available on labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=57617 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added CC||lvi...@wikimedia.org --- Comment #4 from Andre Klapper aklap...@wikimedia.org --- Michelle / Luis: Any legal updates here? Steinsplitter: Asking a specific question to a specific person is likely more effective. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 57617] watchlist table not available on labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=57617 --- Comment #5 from mpaul...@wikimedia.org --- I think Luis was handling this issue, not me. I'll ping him about it. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 57617] watchlist table not available on labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=57617 Marc A. Pelletier m...@uberbox.org changed: What|Removed |Added Status|NEW |ASSIGNED CC||mpaul...@wikimedia.org --- Comment #2 from Marc A. Pelletier m...@uberbox.org --- This needs an okay from Legal; adding Michelle Paulson as CC. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 57617] watchlist table not available on labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=57617 Kunal Mehta (Legoktm) legoktm.wikipe...@gmail.com changed: What|Removed |Added CC||benap...@gmail.com, ||legoktm.wikipe...@gmail.com ||, sprin...@wikimedia.org, ||t...@tim-landscheidt.de Component|Infrastructure |tools See Also|https://bugzilla.wikimedia. | |org/show_bug.cgi?id=55708 | Blocks||48930 Assignee|rlan...@gmail.com |m...@uberbox.org Summary|dewiki_p.watchlist missing |watchlist table not |at labs |available on labs --- Comment #1 from Kunal Mehta (Legoktm) legoktm.wikipe...@gmail.com --- Toolserver view: mysql describe watchlist; +++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +++--+-+-+---+ | wl_namespace | int(11)| NO | | 0 | | | wl_title | varbinary(255) | NO | | | | | ts_wl_user_touched_cropped | varbinary(8) | NO | | | | +++--+-+-+---+ 3 rows in set (0.00 sec) ts_wl_user_touched_cropped is an abbreviated form of that user's user_touched value so users running queries can filter out inactive users. It included year, month and day. Example: 20131126. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
