Update to 17.0.3 failed

ℹ️ Support
1

Hello everyone

I just launched an update of my nextcloud instance to 17.0.3 using the web updater as it always had worked well for me.

But the process is stuck now.
The web page ask for a Polls (polls) update. When i click “start the update” i always get the following error message :

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO `oc_polls_polls` (`id`, `type`, `title`, `description`, `owner`, `created`, `expire`, `deleted`, `access`, `anonymous`, `full_anonymous`, `allow_maybe`, `options`, `settings`, `vote_limit`, `show_results`, `admin_access`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["ck2dqu34rka30kzk", "textPoll", "Something private", "_none_", "Some name", 0, 0, 0, "hidden", 0, null, "1", "[\"yes\",\"no\",\"maybe\"]", "", 0, "always", 0]: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'ck2dqu34rka30kzk' for column 'id' at row 1

Nextcloud version (eg, 12.0.2): 17.0.3
Operating system and version (eg, Ubuntu 17.04): Ubuntu 18.04.3 LTS
Apache or nginx version (eg, Apache 2.4.25): Apache/2.4.29
PHP version (eg, 7.1): 7.3

The issue you are facing:

Stuck with a SQL error : SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘ck2dqu34rka30kzk’ for column ‘id’ at row 1

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. Go to the nextcloud URL in a browser
  2. Clic the “start the update” button with Polls (polls) app update required displayed
  3. Get the error page

The output of your Nextcloud log in Admin > Logging: can’t access the web interface

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => '',
  'passwordsalt' => '',
  'secret' => '',
  'trusted_domains' => 
  array (
    0 => 'localhost',
    1 => 'my.domain,
  ),
  'datadirectory' => '/var/nextclouddata',
  'overwrite.cli.url' => 'my.domain',
  'dbtype' => 'mysql',
  'version' => '17.0.3.1',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'nextcloud',
  'dbpassword' => '',
  'installed' => true,
  'forcessl' => true,
  'forceSSLforSubdomains' => true,
  'loglevel' => 2,
  'log_rotate_size' => 104857600,
  'mail_from_address' => 'contact',
  'mail_smtpmode' => 'smtp',
  'mail_domain' => 'my.domain',
  'mail_smtphost' => 'my.smtp',
  'mail_smtpport' => '25',
  'theme' => '',
  'maintenance' => false,
  'mail_smtpsecure' => 'tls',
  'trashbin_retention_obligation' => 'auto',
  'updatechecker' => false,
  'htaccess.RewriteBase' => '/nextcloud',
  'updater.release.channel' => 'stable',
  'app_install_overwrite' => 
  array (
    0 => 'calendar',
    1 => 'weather',
  ),
  'updater.secret' => '',
);

The output of your Apache/nginx/system log in /var/log/____: Nothing that seems relevant.

Could some please help me ?

Thanks for reading me.