Nextcloud version (eg, 20.0.5): 25.0.5
Operating system and version (eg, Ubuntu 20.04): Debian 11
Apache or nginx version (eg, Apache 2.4.25): 2.4.54-1~deb11u1
PHP version (eg, 7.4): 7.4+76
The issue you are facing:
I cannot install or enable Talk because of the following error: Database error when running migration 2001Date20171031102049 for app spreed Column "oc_talk_participants"."inCall" is type Bool and also NotNull, so it can not store "false".
Is this the first time you’ve seen this error? (Y/N): yes
Steps to replicate it:
- Try installing or enabling Talk
The output of your Nextcloud log in Admin > Logging:
Exception: Database error when running migration 2001Date20171031102049 for app spreed Column "oc_talk_participants"."inCall" is type Bool and also NotNull, so it can not store "false".
/var/www/nc.gianmarco.gg/lib/private/Installer.php - line 153:
OC\DB\MigrationService->migrate()
/var/www/nc.gianmarco.gg/apps/settings/lib/Controller/AppSettingsController.php - line 451:
OC\Installer->installApp()
/var/www/nc.gianmarco.gg/lib/private/AppFramework/Http/Dispatcher.php - line 225:
OCA\Settings\Controller\AppSettingsController->enableApps()
/var/www/nc.gianmarco.gg/lib/private/AppFramework/Http/Dispatcher.php - line 133:
OC\AppFramework\Http\Dispatcher->executeController()
/var/www/nc.gianmarco.gg/lib/private/AppFramework/App.php - line 172:
OC\AppFramework\Http\Dispatcher->dispatch()
/var/www/nc.gianmarco.gg/lib/private/Route/Router.php - line 298:
OC\AppFramework\App::main()
/var/www/nc.gianmarco.gg/lib/base.php - line 1047:
OC\Route\Router->match()
/var/www/nc.gianmarco.gg/index.php - line 36:
OC::handleRequest()
Generato da InvalidArgumentException: Column "oc_talk_participants"."inCall" is type Bool and also NotNull, so it can not store "false".
/var/www/nc.gianmarco.gg/lib/private/DB/MigrationService.php - line 529:
OC\DB\MigrationService->ensureOracleConstraints()
/var/www/nc.gianmarco.gg/lib/private/DB/MigrationService.php - line 416:
OC\DB\MigrationService->executeStep()
/var/www/nc.gianmarco.gg/lib/private/Installer.php - line 153:
OC\DB\MigrationService->migrate()
/var/www/nc.gianmarco.gg/apps/settings/lib/Controller/AppSettingsController.php - line 451:
OC\Installer->installApp()
/var/www/nc.gianmarco.gg/lib/private/AppFramework/Http/Dispatcher.php - line 225:
OCA\Settings\Controller\AppSettingsController->enableApps()
/var/www/nc.gianmarco.gg/lib/private/AppFramework/Http/Dispatcher.php - line 133:
OC\AppFramework\Http\Dispatcher->executeController()
/var/www/nc.gianmarco.gg/lib/private/AppFramework/App.php - line 172:
OC\AppFramework\Http\Dispatcher->dispatch()
/var/www/nc.gianmarco.gg/lib/private/Route/Router.php - line 298:
OC\AppFramework\App::main()
/var/www/nc.gianmarco.gg/lib/base.php - line 1047:
OC\Route\Router->match()
/var/www/nc.gianmarco.gg/index.php - line 36:
OC::handleRequest()
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => 'ocx40yzu6ubu',
'passwordsalt' => 'redacted',
'secret' => 'redacted',
'trusted_domains' =>
array (
0 => 'nc.gianmarco.gg',
),
'datadirectory' => '/var/www/nc.gianmarco.gg/data',
'dbtype' => 'pgsql',
'version' => '25.0.5.1',
'overwrite.cli.url' => 'https://nc.gianmarco.gg',
'installed' => true,
'maintenance' => false,
'mail_smtpmode' => 'smtp',
'mail_smtpauthtype' => 'PLAIN',
'mail_smtpauth' => 1,
'mail_sendmailmode' => 'smtp',
'mail_from_address' => 'nc',
'mail_domain' => 'gianmarco.gg',
'mail_smtphost' => 'mail.gianmarco.gg',
'mail_smtpname' => 'nc',
'mail_smtppassword' => 'redacted',
'theme' => '',
'loglevel' => 2,
'twofactor_enforced' => 'true',
'twofactor_enforced_groups' =>
array (
),
'twofactor_enforced_excluded_groups' =>
array (
),
'app_install_overwrite' =>
array (
0 => 'ojsxc',
1 => 'twofactor_yubikey',
),
'dbname' => 'nextclouddb',
'dbhost' => '127.0.0.1',
'dbuser' => 'nextcloud',
'dbpassword' => 'redacted',
'mail_smtpport' => '587',
'mail_smtpsecure' => 'tls',
);