Closed Bug 1063882 Opened 8 years ago Closed 8 years ago

Get updated numbers on MozillaWiki skin users

Categories

(Infrastructure & Operations :: IT-Managed Tools, task)

task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: GPHemsley, Assigned: cliang)

References

Details

(Whiteboard: [kanban:https://kanbanize.com/ctrl_board/4/1219] )

+++ This bug was initially created as a clone of Bug #1057806 +++

Bug 1062656 purports to have reset (removed) the skin preferences for anyone using the following skins: 'cavendish', 'modern', 'cologneblue', 'standard', 'myskin', 'chick', 'sandstone', 'nostalgia', 'simple', 'gmo', ''.

It would be good to get updated numbers on skin users after the change.

As before, the query is as follows:

>>>
SELECT up_value, COUNT(up_user) AS skin_users
FROM user_properties
WHERE up_property = 'skin'
GROUP BY up_value
ORDER BY skin_users DESC, up_value ASC
<<<
Assignee: nobody → server-ops-webops
Component: wiki.mozilla.org → WebOps: IT-Managed Tools
Product: Websites → Infrastructure & Operations
QA Contact: nmaul
Version: unspecified → other
Whiteboard: [kanban:https://kanbanize.com/ctrl_board/4/1219]
Depends on: 1062656
Assignee: server-ops-webops → cliang
mysql> SELECT up_value, COUNT(up_user) AS skin_users
    -> FROM user_properties
    -> WHERE up_property = 'skin'
    -> GROUP BY up_value
    -> ORDER BY skin_users DESC, up_value ASC;
+----------+------------+
| up_value | skin_users |
+----------+------------+
| vector   |        137 |
| monobook |         81 |
+----------+------------+
2 rows in set (0.01 sec)
Status: NEW → RESOLVED
Closed: 8 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.