DBQ-60 Percentage of active editors with a date preference set on en.wikipedia.org
Closed, DeclinedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:45 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-60.
Summary: Percentage of active editors with a date preference set on en.wikipedia.org
Issue type: Task - A task that needs to be done.
Priority: Trivial
Status: Done
Assignee: (none)

From: Locke Cole <locke.cole.wiki@gmail.com>

Date: Sun, 12 Apr 2009 05:16:18

I don't have a SQL query available, but I'd like to know what percentage of active editors (editors who have made at least 150 article-space contributions and have made at least one edit in the last three months) have a date preference set (i.e., something other than the default setting when an account is created) on the English Wikipedia (en.wikipedia.org).

Version: unspecified
Severity: trivial

Details

Reference: bz59315

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:22 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59315.

JiraBugConverter created this task.Jan 3 2014, 3:45 PM

From: Brent G <overlordq@gmail.com>

Date: Sun, 12 Apr 2009 05:32:32

The toolserver does not have access to user preferences.

From: MZMcBride <mzmcbride@gmail.com>

Date: Sun, 12 Apr 2009 23:59:27

Echoing Brent's comments. Toolserver users only have access to a limited part of the user table, specifically:

mysql> DESCRIBE user;

Field
Type
Null
Key
Default
Extra

user_id
int(5) unsigned
NO

0

user_name
varchar(255)
NO

user_registration
varchar(14)
YES

NULL

user_editcount
int(11)
YES

NULL

4 rows in set (0.01 sec)

User preferences are stored in a blob and are not publicly released. Basic statistics were released a few weeks ago in bulk form here: http://flack.defau.lt/opts.txt

However, there's no way to match that data with specific users.

Resolving this as External / Upstream. It may be possible in the future to analyze user preferences, but not until the preferences system is re-done in MediaWiki core.

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: (none)
CC list: locke.cole.wiki@gmail.com, b@mzmcbride.com, overlordq@gmail.com

DBQ-60 Percentage of active editors with a date preference set on en.wikipedia.orgClosed, DeclinedPublicActions