Page MenuHomeMiraheze

$wgAddGroups and $wgRemoveGroups listed twice in MWP
Closed, ResolvedPublic

Description

In Special:ManageWikiPermissions on Weather Wiki, for some reason, both the $wgAddGroups and the $wgRemoveGroups checkboxes are listed twice - meaning that each group has a duplicate checkbox. @Paladox said on IRC that a task should be filed for @John.

Kind of high priority since its affecting the functionality of MWP (I don’t dare touch the checkboxes while this issue exists).

{F847535}

Event Timeline

AmandaCath triaged this task as High priority.Sep 8 2018, 21:36
AmandaCath created this task.
AmandaCath updated the task description. (Show Details)
John removed John as the assignee of this task.Sep 9 2018, 10:48
John lowered the priority of this task from High to Low.

They’ll be in the DB twice on weatherwiki, wiki1776wiki, metawiki, testwiki and test1wiki.

Nothing major, dupes need to be removed @Paladox or @Reception123

@John how do we fix the dupes though (command?).

I don't see any duplicates in metas table:

| metawiki                              | *                                                                  | ["createaccount","read","edit","createpage","createtalk","writeapi","viewmywatchlist","editmywatchlist","viewmyprivateinfo","editmyprivateinfo","editmyoptions","abusefilter-log","abusefilter-log-detail","abusefilter-view","centralauth-autoaccount","centralauth-merge","oathauth-enable"]

Yet i can reproduce at https://meta.miraheze.org/wiki/Special:ManageWikiPermissions/*

I don't see any duplicates in metas table:

| metawiki                              | *                                                                  | ["createaccount","read","edit","createpage","createtalk","writeapi","viewmywatchlist","editmywatchlist","viewmyprivateinfo","editmyprivateinfo","editmyoptions","abusefilter-log","abusefilter-log-detail","abusefilter-view","centralauth-autoaccount","centralauth-merge","oathauth-enable"]

Yet i can reproduce at https://meta.miraheze.org/wiki/Special:ManageWikiPermissions/*

I do. (as you can see with "wikicreator")

| metawiki    | wikicreator      | ["createwiki","managewiki"]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | []                                                                                                                                                                         | []                                                                                                                                                                                                                                                                 |
| metawiki    | autopatrolled    | ["autopatrol","patrol","skipcaptcha"]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | []                                                                                                                                                                         | []                                                                                                                                                                                                                                                                 |
| metawiki    | rollbacker       | ["rollback"]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | []                                                                                                                                                                         | []                                                                                                                                                                                                                                                                 |
| metawiki    | *                | ["createaccount","read","edit","createpage","                                                                                        createtalk","writeapi","viewmywatchlist","editmywatchlist","viewmyprivateinfo","                                                                                        editmyprivateinfo","editmyoptions","abusefilter-log","abusefilter-log-detail","a                                                                                        busefilter-view","centralauth-autoaccount","centralauth-merge","oathauth-enable"                                                                                        ]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | []                                                                                                                                                                         | []                                                                                                                                                                                                                                                                 |
| metawiki    | confirmed        | ["mwoauthproposeconsumer","mwoauthupdateownco                                                                                        nsumer","move","createpage","translate","editsemiprotected","autoconfirmed","ski                                                                                        pcaptcha"]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | []                                                                                                                                                                         | []                                                                                                                                                                                                                                                                 |
| metawiki    | cvt              | ["abusefilter-modify-global","centralauth-loc                                                                                        k","globalblock","abusefilter-modify","abusefilter-log","abusefilter-log-detail"                                                                                        ,"abusefilter-modify-restricted","abusefilter-view","block"]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | []                                                                                                                                                                         | []                                                                                                                                                                                                                                                                 |
| metawiki    | proxybot         | ["globalblock","centralauth-lock","editprotec                                                                                        ted","block"]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | []                                                                                                                                                                         | []                                                                                                                                                                                                                                                                 |
| metawiki    | sysop            | ["interwiki","block","createaccount","delete"                                                                                        ,"deletedhistory","deletedtext","undelete","editinterface","editusercss","editus                                                                                        erjson","edituserjs","import","importupload","move","move-subpages","move-rootus                                                                                        erpages","move-categorypages","patrol","autopatrol","protect","editprotected","r                                                                                        ollback","upload","reupload","reupload-shared","unwatchedpages","autoconfirmed",                                                                                        "editsemiprotected","ipblock-exempt","blockemail","markbotedits","apihighlimits"                                                                                        ,"browsearchive","noratelimit","movefile","unblockself","suppressredirect","merg                                                                                        ehistory","managechangetags","deletechangetags","oathauth-enable","abusefilter-m                                                                                        odify","abusefilter-modify-restricted","abusefilter-revert","deletelogentry","de                                                                                        leterevision","pagetranslation","translate-import","translate-manage","abusefilt                                                                                        er-log-detail","override-antispoof","skipcaptcha","globalblock-whitelist","massm                                                                                        essage","nuke","tboverride","titleblacklistlog","centralnotice-admin"] | ["flood                                                                                        ","translator","translationadmin","autopatrolled","confirmed","rollbacker"] | ["                                                                                        flood","translator","translationadmin","autopatrolled","confirmed","rollbacker"]                                                                                         |
| metawiki    | user             | ["requestwiki","user","move","move-subpages",                                                                                        "move-rootuserpages","move-categorypages","movefile","read","edit","createtalk",                                                                                        "writeapi","upload","reupload","reupload-shared","minoredit","editmyusercss","ed                                                                                        itmyuserjson","editmyuserjs","purge","sendemail","applychangetags","changetags",                                                                                        "editcontentmodel","translate-messagereview","mwoauthmanagemygrants"]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | []                                                                                                                                                                         | []                                                                                                                                                                                                                                                                 |
| metawiki    | wikicreator      | ["createwiki","managewiki"]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | []                                                                                                                                                                         | []

It's a duplicate column. Now how do we remove the duplicate one without removing both?

I did this

MariaDB [metawiki]> DELETE FROM `mw_permissions` WHERE perm_dbname = 'test1wiki' AND perm_group = '*';
Query OK, 2 rows affected (0.12 sec)

and

INSERT INTO  `mw_permissions` (`perm_dbname`, `perm_group`, `perm_permissions`, `perm_addgroups`, `perm_removegroups`) VALUES ('test1wiki', '*', '["createaccount","read","createtalk","writeapi","viewmywatchlist","editmywatchlist","viewmyprivateinfo","editmyprivateinfo","editmyoptions","abusefilter-log","abusefilter-log-detail","abusefilter-view","centralauth-autoaccount","ajaxpoll-view-results","ajaxpoll-view-results-before-vote","poll-score","translate","item-term","property-term","item-merge","item-redirect","property-create","centralauth-merge","oathauth-enable","ArticleToCategory2","comment","ep-bereviewer","flow-hide","viewedittab","pollny-vote","aft-reader"]', '[]', '[]');

But it's still showing the duplicates through the ui (but i can confirm * is no longer duplicated in the db for test1wiki)

https://test1.miraheze.org/wiki/Special:ManageWikiPermissions/*

Ok, i fixed the duplicates in test1 now. You have to do it for the rest of duplicates even if * is not duplicated anymore.

metawiki and weatherwiki have been fixed, just have wiki1776wiki and testwiki to fix.

Paladox claimed this task.

I have fixed it on wiki1776wiki and testwiki now.