Enabling polls app gives following error SQL error: Exception: Database error when running migration

ℹ️ Support
1

Yesterday I’ve updated from NC24 to NC25 using the official docker image. I noticed the polls app wasn’t enabled anymore. When I try to enable it, I receive the following error:

[settings] Fout: Exception: Database error when running migration 040102Date20230123072601 for app polls
An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3--0' for key 'UNIQ_options' at <<closure>>

0. /var/www/html/lib/private/Installer.php line 153
   OC\DB\MigrationService->migrate("latest", false)
1. /var/www/html/apps/settings/lib/Controller/AppSettingsController.php line 451
   OC\Installer->installApp("polls")
2. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 225
   OCA\Settings\Controller\AppSettingsController->enableApps(["polls"], [])
3. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 133
   OC\AppFramework\Http\Dispatcher->executeController(["OCA\\Settings\ ... "], "enableApps")
4. /var/www/html/lib/private/AppFramework/App.php line 172
   OC\AppFramework\Http\Dispatcher->dispatch(["OCA\\Settings\ ... "], "enableApps")
5. /var/www/html/lib/private/Route/Router.php line 298
   OC\AppFramework\App::main("OCA\\Settings\\ ... r", "enableApps", ["OC\\AppFramewo ... "], ["settings.AppSettings.enableApps"])
6. /var/www/html/lib/base.php line 1048
   OC\Route\Router->match("/settings/apps/enable")
7. /var/www/html/index.php line 36
   OC::handleRequest()

POST /settings/apps/enable

Everything else seems to work as normal. How could I resolve this?

2

I’ve updated my polls app to 5.0.5 and now the problem seems to be solved. I can enable it again without problems