Error 1054 from MediaWiki\Extension\SecurePoll\Entities\Election::isTallied, {error} {sql1line} {db_server}
Closed, ResolvedPublicPRODUCTION ERROR
Actions

Description

Error

mwversion: 1.45.0-wmf.8
timestamp: 2025-07-08T00:22:24.227Z
phpversion: 8.1.32
reqId: 8f12d978-c009-44d6-857d-7f411e1ecb29
Find reqId in Logstash

normalized_message

Error 1054 from MediaWiki\Extension\SecurePoll\Entities\Election::isTallied, {error} {sql1line} {db_server}

Frame	Location	Call
from	/srv/mediawiki/php-1.45.0-wmf.8/includes/libs/rdbms/database/Database.php(1213)
#0	/srv/mediawiki/php-1.45.0-wmf.8/includes/libs/rdbms/database/Database.php(1190)	Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#1	/srv/mediawiki/php-1.45.0-wmf.8/includes/libs/rdbms/database/Database.php(647)	Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#2	/srv/mediawiki/php-1.45.0-wmf.8/includes/libs/rdbms/database/Database.php(1367)	Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#3	/srv/mediawiki/php-1.45.0-wmf.8/includes/libs/rdbms/database/Database.php(1318)	Wikimedia\Rdbms\Database->select(array, string, array, string, array, array)
#4	/srv/mediawiki/php-1.45.0-wmf.8/includes/libs/rdbms/database/DBConnRef.php(127)	Wikimedia\Rdbms\Database->selectField(array, string, array, string, array, array)
#5	/srv/mediawiki/php-1.45.0-wmf.8/includes/libs/rdbms/database/DBConnRef.php(338)	Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6	/srv/mediawiki/php-1.45.0-wmf.8/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(780)	Wikimedia\Rdbms\DBConnRef->selectField(array, string, array, string, array, array)
#7	/srv/mediawiki/php-1.45.0-wmf.8/extensions/SecurePoll/includes/Entities/Election.php(708)	Wikimedia\Rdbms\SelectQueryBuilder->fetchField()
#8	/srv/mediawiki/php-1.45.0-wmf.8/extensions/SecurePoll/includes/Pages/DumpPage.php(61)	MediaWiki\Extension\SecurePoll\Entities\Election->isTallied(Wikimedia\Rdbms\DBConnRef)
#9	/srv/mediawiki/php-1.45.0-wmf.8/extensions/SecurePoll/includes/SpecialSecurePoll.php(70)	MediaWiki\Extension\SecurePoll\Pages\DumpPage->execute(array)
#10	/srv/mediawiki/php-1.45.0-wmf.8/includes/specialpage/SpecialPage.php(732)	MediaWiki\Extension\SecurePoll\SpecialSecurePoll->execute(string)
#11	/srv/mediawiki/php-1.45.0-wmf.8/includes/specialpage/SpecialPageFactory.php(1724)	MediaWiki\SpecialPage\SpecialPage->run(string)
#12	/srv/mediawiki/php-1.45.0-wmf.8/includes/actions/ActionEntryPoint.php(499)	MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, MediaWiki\Context\RequestContext)
#13	/srv/mediawiki/php-1.45.0-wmf.8/includes/actions/ActionEntryPoint.php(143)	MediaWiki\Actions\ActionEntryPoint->performRequest()
#14	/srv/mediawiki/php-1.45.0-wmf.8/includes/MediaWikiEntryPoint.php(198)	MediaWiki\Actions\ActionEntryPoint->execute()
#15	/srv/mediawiki/php-1.45.0-wmf.8/index.php(58)	MediaWiki\MediaWikiEntryPoint->run()
#16	/srv/mediawiki/w/index.php(3)	require(string)
#17	{main}

Impact

Notes

Details

Request URL: https://te.wikiquote.org/wiki/%E0%B0%AA%E0%B1%8D%E0%B0%B0%E0%B0%A4%E0%B1%8D%E0%B0%AF%E0%B1%87%E0%B0%95:SecurePoll/dump/1

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	Create regression tests for Election::isTallied	mediawiki/extensions/SecurePoll	master	+63 -1
	Election: Simplify and fix isTallied query	mediawiki/extensions/SecurePoll	master	+5 -6

Customize query in gerrit

Related Objects

Mentioned In: T387701: Allow multiple tallies to be associated with a poll

Event Timeline

Zabe created this task.Jul 8 2025, 12:25 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 8 2025, 12:25 AM

Zabe added a project: MediaWiki-extensions-SecurePoll.Jul 8 2025, 12:26 AM

Restricted Application added a project: Trust and Safety Product Team. · View Herald TranscriptJul 8 2025, 12:26 AM

Change #1166945 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/SecurePoll@master] Election: Simplify and fix isTallied query

https://gerrit.wikimedia.org/r/1166945

gerritbot added a project: Patch-For-Review.Jul 8 2025, 12:36 AM

Novem_Linguae mentioned this in T387701: Allow multiple tallies to be associated with a poll.Jul 8 2025, 1:12 AM

Dreamy_Jazz merged a task: T398910: Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'en.en_id' in 'SELECT'Function: MediaWiki\Extension\SecurePoll\Entities\Election::isTalliedQuery: SELECT en.en_id FROM `securepoll_elections` `el` JOIN `securepoll_pr.Jul 8 2025, 6:53 AM

Change #1166945 merged by jenkins-bot:

[mediawiki/extensions/SecurePoll@master] Election: Simplify and fix isTallied query

https://gerrit.wikimedia.org/r/1166945

Dreamy_Jazz assigned this task to Zabe.Jul 8 2025, 7:11 AM

Dreamy_Jazz added a project: Trust and Safety Product Sprint (Sprint Cannoli (July 7 - July 25)).

Dreamy_Jazz moved this task from Priority Backlog to Needs QA on the Trust and Safety Product Sprint (Sprint Cannoli (July 7 - July 25)) board.

Maintenance_bot removed a project: Patch-For-Review.Jul 8 2025, 7:30 AM

Change #1167140 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/SecurePoll@master] Create regression tests for Election::isTallied

https://gerrit.wikimedia.org/r/1167140

gerritbot added a project: Patch-For-Review.Jul 8 2025, 7:31 AM

Dreamy_Jazz moved this task from Needs QA to Needs Review on the Trust and Safety Product Sprint (Sprint Cannoli (July 7 - July 25)) board.Jul 8 2025, 7:32 AM

ReleaseTaggerBot added a project: MW-1.45-notes (1.45.0-wmf.10; 2025-07-15).Jul 8 2025, 8:00 AM

Change #1167140 merged by jenkins-bot: