(Schema page for reference: https://meta.wikimedia.org/wiki/Schema:PrefUpdate )
I just happened upon this observation by @Halfak from February 2017:
Since the web team is currently relying on this schema (cf. T212516 , T211197), I checked if this is still an issue. There are indeed still lots of such duplicate events as of last month, although they seem to be focused on particular properties (compare also this list of the 200 most frequent properties in the schema overall):
SELECT event.property AS property, COUNT(*) AS duplicated_events FROM ( SELECT event, COUNT(*) AS copies FROM event.prefupdate WHERE year = 2019 AND month = 2 GROUP BY event HAVING copies > 1) AS events GROUP BY event.property ORDER BY property LIMIT 10000; property duplicated_events cx 115 date 1 echo-subscriptions-email-article-linked 1 echo-subscriptions-email-edit-thank 1 echo-subscriptions-email-login-fail 1 echo-subscriptions-email-login-success 1 echo-subscriptions-email-mention 1 echo-subscriptions-email-oauth-owner 1 echo-subscriptions-email-page-review 1 echo-subscriptions-web-article-linked 2 echo-subscriptions-web-mention-failure 1 echo-subscriptions-web-mention-success 1 echo-subscriptions-web-reverted 1 editsectiononrightclick 1 enotifminoredits 1 enotifwatchlistpages 1 fileexporter 285 gender 1 lqt-watch-threads 32 lqtdisplaycount 266 lqtdisplaydepth 266 lqtnotifytalk 306 minordefault 68 php7 59 popups 1 prefershttps 9540 templatewizard-betafeature 3105 timecorrection 3 twocolconflict 192 uls-preferences 26 usecodemirror 6 visualeditor-betatempdisable 165 visualeditor-enable 705 visualeditor-findAndReplace-findText 13 visualeditor-findAndReplace-replaceText 6 visualeditor-newwikitext 3207 visualeditor-visualdiffpage 185 Time taken: 85.171 seconds, Fetched: 37 row(s)
QA steps
Verify that opt-in and out from Beta and AMC modes work properly on a mobile site. Also, please double check that saving user preferences works with, and without Javascript.
QA Results - Beta
AC | Status | Details |
---|---|---|
1 | ✅ | T218835#6905829 |
2 | ✅ | T218835#6905829 |
QA Results - Prod
AC | Status | Details |
---|---|---|
1 | ✅ | T218835#6912461 |
2 | ✅ | T218835#6912461 |
QA Results - Beta
AC | Status | Details |
---|---|---|
1 | ✅ | T218835#6941076 |
2 | ✅ | T218835#6941076 |
QA Results - Prod
AC | Status | Details |
---|---|---|
1 | ✅ | T218835#6968753 |
2 | ✅ | T218835#6968753 |