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
Closed, DuplicatePublicPRODUCTION ERROR
Actions

Assigned To

None

Authored By

	Aklapper
	Jul 8 2025, 6:52 AM

Description

Error

service.version: 1.45.0-wmf.8
timestamp: 2025-07-08T00:30:50.950Z
labels.phpversion: 8.1.32
trace.id: 4c26976e-7fdd-4c17-a71b-72bd652ecde4
Find trace.id in Logstash

labels.normalized_message

[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'en.en_id' in 'SELECT'
Function: MediaWiki\Extension\SecurePoll\Entities\Election::isTallied
Query: SELECT  en.en_id  FROM `securepoll_elections` `el` JOIN `securepoll_pr

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

Impact

Happens on multiple wikis.

Notes

https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/SecurePoll/+/df6f6f43bccec55fa7f3c8e23b3ac3c943488508/ on 2025-06-24 introduced ->select( 'en.en_id' ). Cannot subscribe the author as I cannot find an account in Phab for that name.

Details

Request URL: https://sv.wikipedia.org/wiki/Special:SecurePoll/dump/*

Event Timeline

Aklapper created this task.Jul 8 2025, 6:52 AM

Dreamy_Jazz closed this task as a duplicate of T398901: Error 1054 from MediaWiki\Extension\SecurePoll\Entities\Election::isTallied, {error} {sql1line} {db_server}.Jul 8 2025, 6:53 AM

Cannot subscribe the author as I cannot find an account in Phab for that name.

That would be @Amdrel. Please consider setting an AKA.

OKryva-WMF added a project: Essential-Work.Oct 3 2025, 3:53 PM

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_prClosed, DuplicatePublicPRODUCTION ERRORActions