Adding a task results in exception: Unknown column 'classification' in 'field list'

[rasos]

When adding a task to a task list we get an exception: Unknown column 'classification' in 'field list'.

 Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT `id`, `uri`, `lastmodified`, `etag`, `calendarid`, `size`, `calendardata`, `componenttype`, `classification` FROM `oc_calendarobjects` WHERE (`calendarid` = ?) AND (`uri` = ?)' with params ["1345", "system-LDAP:robby.villa@usgeek.org.vcf.ics"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'classification' in 'field list'
 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 855: Doctrine\DBAL\DBALException driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'SELECT `id`, `u...', Array)
 /var/www/nextcloud/lib/private/DB/Connection.php - line 195: Doctrine\DBAL\Connection->executeQuery('SELECT `id`, `u...', Array, Array, NULL)
 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 206: OC\DB\Connection->executeQuery('SELECT `id`, `u...', Array, Array)
 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214: Doctrine\DBAL\Query\QueryBuilder->execute()
 /var/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php - line 890: OC\DB\QueryBuilder\QueryBuilder->execute()
 /var/www/nextcloud/apps/dav/lib/CalDAV/BirthdayService.php - line 302: OCA\DAV\CalDAV\CalDavBackend->getCalendarObject('1345', 'system-LDAP rob...')
 /var/www/nextcloud/apps/dav/lib/CalDAV/BirthdayService.php - line 99: OCA\DAV\CalDAV\BirthdayService->updateCalendar('LDAP robby.vill...', 'BEGIN VCARD\r\nVE...', Array, '1345', Array)
 /var/www/nextcloud/apps/dav/lib/AppInfo/Application.php - line 119: OCA\DAV\CalDAV\BirthdayService->onCardChanged('5', 'LDAP robby.vill...', 'BEGIN VCARD\r\nVE...')
 [internal function] OCA\DAV\AppInfo\Application->OCA\DAV\AppInfo\{closure}(*** sensitive parameters replaced ***)
 /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php - line 212: call_user_func(Object(Closure), Object(Symfony\Component\EventDispatcher\GenericEvent), '\\OCA\\DAV\\CardDA...', Object(Symfony\Component\EventDispatcher\EventDispatcher))
 /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php - line 44: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch(Array, '\\OCA\\DAV\\CardDA...', Object(Symfony\Component\EventDispatcher\GenericEvent))
 /var/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php - line 633: Symfony\Component\EventDispatcher\EventDispatcher->dispatch('\\OCA\\DAV\\CardDA...', Object(Symfony\Component\EventDispatcher\GenericEvent))
 /var/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php - line 278: OCA\DAV\CardDAV\CardDavBackend->createCard('5', 'LDAP robby.vill...', 'BEGIN VCARD\r\nVE...')
 /var/www/nextcloud/apps/dav/lib/HookManager.php - line 124: OCA\DAV\CardDAV\SyncService->updateUser(Object(OC\User\User))
 /var/www/nextcloud/lib/private/legacy/hook.php - line 106: OCA\DAV\HookManager->changeUser(Array)
 /var/www/nextcloud/lib/private/Server.php - line 409: OC_Hook emit('OC_User', 'changeUser', Array)
 [internal function] OC\Server->OC\{closure}(*** sensitive parameters replaced ***)
 /var/www/nextcloud/lib/private/Hooks/EmitterTrait.php - line 99: call_user_func_array(Object(Closure), Array)
 /var/www/nextcloud/lib/private/Hooks/PublicEmitter.php - line 36: OC\Hooks\BasicEmitter->emit('\\OC\\User', 'changeUser', Array)
 /var/www/nextcloud/lib/private/User/User.php - line 456: OC\Hooks\PublicEmitter->emit('\\OC\\User', 'changeUser', Array)
 /var/www/nextcloud/lib/private/User/User.php - line 170: OC\User\User->triggerChange('eMailAddress', 'robby.villa@usg...', NULL)
 /var/www/nextcloud/apps/user_ldap/lib/User/User.php - line 475: OC\User\User->setEMailAddress('robby.villa@usg...')
 /var/www/nextcloud/apps/user_ldap/lib/User/User.php - line 219: OCA\User_LDAP\User\User->updateEmail('robby.villa@usg...')
 /var/www/nextcloud/apps/user_ldap/lib/Access.php - line 900: OCA\User_LDAP\User\User->processAttributes(Array)
 /var/www/nextcloud/apps/user_ldap/lib/Access.php - line 874: OCA\User_LDAP\Access->batchApplyUserAttributes(Array)
 /var/www/nextcloud/apps/user_ldap/lib/User_LDAP.php - line 292: OCA\User_LDAP\Access->fetchListOfUsers('(&(&(|(objectcl...', Array, 500, '3500')
 /var/www/nextcloud/apps/user_ldap/lib/User_Proxy.php - line 159: OCA\User_LDAP\User_LDAP->getUsers('', 500, '3500')
 /var/www/nextcloud/lib/private/User/Manager.php - line 225: OCA\User_LDAP\User_Proxy->getUsers('', 500, '3500')
 /var/www/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php - line 101: OC\User\Manager->search('', 500, '3500')
 /var/www/nextcloud/lib/private/BackgroundJob/Job.php - line 61: OCA\Files\BackgroundJob\ScanFiles->run(NULL)
 /var/www/nextcloud/lib/private/BackgroundJob/TimedJob.php - line 55: OC\BackgroundJob\Job->execute(Object(OC\BackgroundJob\JobList), Object(OC\Log))
 /var/www/nextcloud/cron.php - line 123: OC\BackgroundJob\TimedJob->execute(Object(OC\BackgroundJob\JobList), Object(OC\Log))
 {main}

oc_calendarobjects has the following rows:

calendardata
calendarid
componenttype
etag
firstoccurence
id
lastmodified
lastoccurence
size
uid
uri

Did we miss an upgrade script?

Version: nextcloud 13.0.5 (has been upgraded in singular steps from owncloud 8.2 -> nc 9 -> 10 -> 11 -> 12 -> 13), users are connected via LDAP, the app "Tasks" is restricted to some groups.

[nextcloud-bot]

GitMate.io thinks possibly related issues are #3057 (Exception When Creating Task List In macOS Reminder App (CalDAV)), #3851 (Add a new calendar from client results in error), #2566 (Exception: Repair step 'OCA\DAV\Migration\GenerateBirthdays' is unknown), #9962 (Added icons to users list and improved design), and #6860 (appstoreFetcher Exception).

[rasos]

Seems related to /issues/1025#issuecomment-254637252

[rasos]

alter table oc_calendarobjects add classification int(10) unsigned DEFAULT 0;

solved the issue.