App update failed - Collectives

🍱 Features & apps collectives
,
1

Hi,

i have the following setup:

Nextcloud 27.1.1.
Ubuntu Linux 22.04.3
Apache Version 2.4.52
MySQL-Version 8.0.34-0

After updating the Nextcloud apps, the Collectives app failed. The following protocol describes the error. Can anybody help me?

[settings] Fehler: Exception: Database error when running migration 020800Date20230911000000 for app collectives
An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'settings' can't have a default value at <<closure>>

0. /var/www/nextcloud/lib/private/Installer.php line 153
   OC\DB\MigrationService->migrate()
1. /var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php line 451
   OC\Installer->installApp()
2. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
   OCA\Settings\Controller\AppSettingsController->enableApps()
3. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
   OC\AppFramework\Http\Dispatcher->executeController()
4. /var/www/nextcloud/lib/private/AppFramework/App.php line 183
   OC\AppFramework\Http\Dispatcher->dispatch()
5. /var/www/nextcloud/lib/private/Route/Router.php line 315
   OC\AppFramework\App::main()
6. /var/www/nextcloud/lib/base.php line 1068
   OC\Route\Router->match()
7. /var/www/nextcloud/index.php line 36
   OC::handleRequest()

Caused by:

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'settings' can't have a default value at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1814
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1749
    Doctrine\DBAL\Connection->handleDriverException()
 2. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1055
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /var/www/nextcloud/lib/private/DB/Connection.php line 262
    Doctrine\DBAL\Connection->executeQuery()
 4. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1843
    OC\DB\Connection->executeQuery()
 5. /var/www/nextcloud/lib/private/DB/Migrator.php line 162
    Doctrine\DBAL\Connection->query()
 6. /var/www/nextcloud/lib/private/DB/Migrator.php line 68
    OC\DB\Migrator->applySchema()
 7. /var/www/nextcloud/lib/private/DB/Connection.php line 589
    OC\DB\Migrator->migrate()
 8. /var/www/nextcloud/lib/private/DB/MigrationService.php line 532
    OC\DB\Connection->migrateToSchema()
 9. /var/www/nextcloud/lib/private/DB/MigrationService.php line 417
    OC\DB\MigrationService->executeStep()
10. /var/www/nextcloud/lib/private/Installer.php line 153
    OC\DB\MigrationService->migrate()
11. /var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php line 451
    OC\Installer->installApp()
12. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Settings\Controller\AppSettingsController->enableApps()
13. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
14. /var/www/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
15. /var/www/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
16. /var/www/nextcloud/lib/base.php line 1068
    OC\Route\Router->match()
17. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

Caused by:

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'settings' can't have a default value at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php line 77
    Doctrine\DBAL\Driver\PDO\Exception::new()
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1050
    Doctrine\DBAL\Driver\PDO\Connection->query()
 2. /var/www/nextcloud/lib/private/DB/Connection.php line 262
    Doctrine\DBAL\Connection->executeQuery()
 3. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1843
    OC\DB\Connection->executeQuery()
 4. /var/www/nextcloud/lib/private/DB/Migrator.php line 162
    Doctrine\DBAL\Connection->query()
 5. /var/www/nextcloud/lib/private/DB/Migrator.php line 68
    OC\DB\Migrator->applySchema()
 6. /var/www/nextcloud/lib/private/DB/Connection.php line 589
    OC\DB\Migrator->migrate()
 7. /var/www/nextcloud/lib/private/DB/MigrationService.php line 532
    OC\DB\Connection->migrateToSchema()
 8. /var/www/nextcloud/lib/private/DB/MigrationService.php line 417
    OC\DB\MigrationService->executeStep()
 9. /var/www/nextcloud/lib/private/Installer.php line 153
    OC\DB\MigrationService->migrate()
10. /var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php line 451
    OC\Installer->installApp()
11. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Settings\Controller\AppSettingsController->enableApps()
12. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
13. /var/www/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
14. /var/www/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
15. /var/www/nextcloud/lib/base.php line 1068
    OC\Route\Router->match()
16. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

Caused by:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'settings' can't have a default value at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php line 72
    PDO->query()
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1050
    Doctrine\DBAL\Driver\PDO\Connection->query()
 2. /var/www/nextcloud/lib/private/DB/Connection.php line 262
    Doctrine\DBAL\Connection->executeQuery()
 3. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1843
    OC\DB\Connection->executeQuery()
 4. /var/www/nextcloud/lib/private/DB/Migrator.php line 162
    Doctrine\DBAL\Connection->query()
 5. /var/www/nextcloud/lib/private/DB/Migrator.php line 68
    OC\DB\Migrator->applySchema()
 6. /var/www/nextcloud/lib/private/DB/Connection.php line 589
    OC\DB\Migrator->migrate()
 7. /var/www/nextcloud/lib/private/DB/MigrationService.php line 532
    OC\DB\Connection->migrateToSchema()
 8. /var/www/nextcloud/lib/private/DB/MigrationService.php line 417
    OC\DB\MigrationService->executeStep()
 9. /var/www/nextcloud/lib/private/Installer.php line 153
    OC\DB\MigrationService->migrate()
10. /var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php line 451
    OC\Installer->installApp()
11. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Settings\Controller\AppSettingsController->enableApps()
12. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController()
13. /var/www/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch()
14. /var/www/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main()
15. /var/www/nextcloud/lib/base.php line 1068
    OC\Route\Router->match()
16. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

POST /settings/apps/enable
from xx.xx.xx.xx by xxx at 2023-10-02T21:44:44+02:00```
2

I guess I have something similar here:

Database error when running migration 020800Date20230911000000 for app collectives An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'settings' can't have a default value

I have disabled the app via .occ commandline for now, everything else is running smoothly - but the collectives app is causing headaches…

Any advice how to fix this?

3

To those who got caught by this bug and have a broken Collectives app now: this got fixed in Collectives version 2.8.2… Upgrading to this version should solve the issue. Please report back if you still encounter problems.