Page MenuHomePhabricator

Can't edit SecurePoll poll on votewiki (DBQueryError): Error 1146: Table 'blkwiki.securepoll_elections' doesn't exist
Closed, ResolvedPublicBUG REPORT

Description

Steps to replicate the issue (include links if applicable):

  • Attempt to edit the only future poll in SecurePoll on votewiki
  • Make a change (e.g. rename a candidate)

What happens?:

I receive the error [14cc13a0-c0cc-4075-92ec-6a819bdbba00] 2022-07-28 00:42:59: Fatal exception of type "Wikimedia\Rdbms\DBQueryError" (the code here changes every time)

What should have happened instead?:

The edit should have saved.

Other information (browser name/version, screenshots, etc.):

Screenshot 2022-07-27 at 5.44.58 PM.png (366×1 px, 78 KB)

Event Timeline

jrbs triaged this task as High priority.Jul 28 2022, 12:45 AM
Error 1146: Table 'blkwiki.securepoll_elections' doesn't exist
Function: MediaWiki\Extension\SecurePoll\Pages\CreatePage::processInput
Query: SELECT  el_entity  FROM `securepoll_elections`    WHERE el_title = 'Wikimedia Foundation Board Elections 2022'  LIMIT 1

The error shows up for blkwiki, which only was created last Tuesday (19th of July).

Aklapper renamed this task from Can't edit SecurePoll poll on votewiki (DBQueryError) to Can't edit SecurePoll poll on votewiki (DBQueryError): Error 1146: Table 'blkwiki.securepoll_elections' doesn't exist.Jul 28 2022, 11:25 AM
Error 1146: Table 'blkwiki.securepoll_elections' doesn't exist
Function: MediaWiki\Extension\SecurePoll\Pages\CreatePage::processInput
Query: SELECT  el_entity  FROM `securepoll_elections`    WHERE el_title = 'Wikimedia Foundation Board Elections 2022'  LIMIT 1

The error shows up for blkwiki, which only was created last Tuesday (19th of July).

Thanks for pointing this out! I am not sure how to proceed, if I need to wait for the setup tasks there to be completed before I can edit this election?

We launch the voting in two weeks, and there are changes that must be made before then.

It depends how quickly SecurePoll can be installed on the new wiki (if that's necessary?), but perhaps there might be a way to have votewiki ignore blkwiki?

It depends how quickly SecurePoll can be installed on the new wiki (if that's necessary?), but perhaps there might be a way to have votewiki ignore blkwiki?

The SecurePoll tables should have been created by addWiki.php regardless of whether the extension is enabled for the wiki, and it is anyway (Special:Version, Special:SecurePoll). There were some problems with addWiki.php though: T313302: addWiki.php is broken (2022-07).

Maybe @Urbanecm (who was the one who ran the script) has some idea of what happened. I'll also leave a comment on that task in case anyone else knows.

Ladsgroup claimed this task.
Ladsgroup added a subscriber: Ladsgroup.

I created the tables.