Big discrepancy in voter numbers between UI and DB for election 1864
Closed, InvalidPublic
Actions

Assigned To

None

Authored By

	jrbs
	Oct 9 2025, 9:23 PM

Project Tags

Referenced Files

	F66740543: image.png
	Oct 9 2025, 9:23 PM

Subscribers

Aklapper

jrbs

Description

I'm not sure if this is a bug or not, and even if it's worth worrying about. But votewiki's UI says 671 voters have voted at the time of writing...

...but the database says the number of voters is actually 1332.

wikiadmin2023@10.192.16.41(votewiki)> select count(*) from securepoll_voters where voter_election=1864;
+----------+
| count(*) |
+----------+
|     1332 |
+----------+
1 row in set (0.002 sec)

The voters not in the list page are at P83724

I wonder if this is an issue with mobile voting?

Related Objects

Mentioned Here: P83724 Voters not in votewiki ui 1864

Event Timeline

jrbs created this task.Oct 9 2025, 9:23 PM

Restricted Application added a project: Product Safety and Integrity. · View Herald TranscriptOct 9 2025, 9:23 PM

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

This might just be me being stupid since JSutherland (WMF) is in there (that's me!) but I definitely have not voted with that account. So possibly my SQL query is incorrect.

Woops, I was querying the wrong table.

wikiadmin2023@10.192.16.41(votewiki)> select count(*) from securepoll_votes where vote_election=1864;
+----------+
| count(*) |
+----------+
|      694 |
+----------+
1 row in set (0.001 sec)

Big discrepancy in voter numbers between UI and DB for election 1864Closed, InvalidPublicActions

Description

Related Objects

Event Timeline

Big discrepancy in voter numbers between UI and DB for election 1864
Closed, InvalidPublic
Actions