Update fails due to SQL exception [25.0.8]

ℹ️ Support
1

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t1.poll_option_hash’ in ‘where clause’

Happens while updating to version 25.0.8.

Any idea how to resolve that one?

Thanks
Regards
nobody

2

Looks like a known issue with a fix to the migrator pending. Solution for you is likely occ polls:db:rebuild:

3

Ok, but where do i have to executed this command?

4

On the command line.

5

Was able to execute occ upgrade.
Which only solved it partially, but now i get:

An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_polls_watch' doesn't exist

root@1_nextcloud-25:/var/www/html# su -s /bin/sh -c "/var/www/html/occ polls:db:rebuild" www-data
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade


  There are no commands defined in the "polls:db" namespace.

Repair error: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_polls_watch' doesn't exist
An unhandled exception has been thrown:
Error: Call to undefined method OCA\Polls\Db\OptionMapper::getAll() in /var/www/html/custom_apps/polls/lib/Db/TableManager.php:410
Stack trace:
#0 /var/www/html/custom_apps/polls/lib/Migration/RepairSteps/UpdateHashes.php(43): OCA\Polls\Db\TableManager->migrateOptionsToHash()
#1 /var/www/html/lib/private/Repair.php(127): OCA\Polls\Migration\RepairSteps\UpdateHashes->run(Object(OC\Repair))
#2 /var/www/html/lib/private/legacy/OC_App.php(1068): OC\Repair->run()
#3 /var/www/html/lib/private/legacy/OC_App.php(1010): OC_App::executeRepairSteps('polls', Array)
#4 /var/www/html/lib/private/Installer.php(200): OC_App::updateApp('polls')
#5 /var/www/html/lib/private/Updater.php(423): OC\Installer->updateAppstoreApp('polls')
#6 /var/www/html/lib/private/Updater.php(282): OC\Updater->upgradeAppStoreApps(Array)
#7 /var/www/html/lib/private/Updater.php(141): OC\Updater->doUpgrade('25.0.8.2', '25.0.3.2')
#8 /var/www/html/core/Command/Upgrade.php(225): OC\Updater->upgrade()
#9 /var/www/html/3rdparty/symfony/console/Command/Command.php(255): OC\Core\Command\Upgrade->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#10 /var/www/html/3rdparty/symfony/console/Application.php(1009): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#11 /var/www/html/3rdparty/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(OC\Core\Command\Upgrade), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /var/www/html/3rdparty/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 /var/www/html/lib/private/Console/Application.php(214): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#14 /var/www/html/console.php(100): OC\Console\Application->run()
#15 /var/www/html/occ(11): require_once('/var/www/html/c...')
#16 {main}