After upgrading the calendar database table seems to be gone.
Fixes from github doesnât seem to work or I executed them wrong.
opened 02:29PM - 23 Aug 16 UTC
closed 12:57PM - 19 Oct 16 UTC
bug
needs info
feature: install and update
``` json
{
"app": "webdav",
"level": 4,
"message": "Exception: {\"Me⊠ssage\":\"An exception occurred while executing 'SELECT `id`, `uri`, `lastmodified`, `etag`, `calendarid`, `size`, `calendardata`, `componenttype`, `classification` FROM `oc_calendarobjects` WHERE (`calendarid` = ?) AND (`uri` = ?)' with params [\\\"1\\\", \\\"0f84a47c-5cc9-445d-9f01-2c86c15f8b10.ics\\\"]:\\n\\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'classification' in 'field list'\",\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\InvalidFieldNameException\",\"Code\":0,\"Trace\":\"#0 \\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/DBALException.php(116): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php(836): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT `id`, `u...', Array)\\n#2 \\/var\\/www\\/nextcloud\\/htdocs\\/lib\\/private\\/DB\\/Connection.php(188): Doctrine\\\\DBAL\\\\Connection->executeQuery('SELECT `id`, `u...', Array, Array, NULL)\\n#3 \\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Query\\/QueryBuilder.php(206): OC\\\\DB\\\\Connection->executeQuery('SELECT `id`, `u...', Array, Array)\\n#4 \\/var\\/www\\/nextcloud\\/htdocs\\/lib\\/private\\/DB\\/QueryBuilder\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\/var\\/www\\/nextcloud\\/htdocs\\/apps\\/dav\\/lib\\/CalDAV\\/CalDavBackend.php(537): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\/var\\/www\\/nextcloud\\/htdocs\\/apps\\/dav\\/lib\\/CalDAV\\/Calendar.php(168): OCA\\\\DAV\\\\CalDAV\\\\CalDavBackend->getCalendarObject('1', '0f84a47c-5cc9-4...')\\n#7 \\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/sabre\\/dav\\/lib\\/DAV\\/Tree.php(76): OCA\\\\DAV\\\\CalDAV\\\\Calendar->getChild('0f84a47c-5cc9-4...')\\n#8 \\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(903): Sabre\\\\DAV\\\\Tree->getNodeForPath('calendars\\/uzivatel...')\\n#9 \\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/sabre\\/dav\\/lib\\/CalDAV\\/Plugin.php(605): Sabre\\\\DAV\\\\Server->getPropertiesForPath('calendars\\/uzivatel...', Array)\\n#10 \\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/sabre\\/dav\\/lib\\/CalDAV\\/Plugin.php(236): Sabre\\\\CalDAV\\\\Plugin->calendarQueryReport(Object(Sabre\\\\CalDAV\\\\Xml\\\\Request\\\\CalendarQueryReport))\\n#11 [internal function]: Sabre\\\\CalDAV\\\\Plugin->report('{urn:ietf:param...', Object(Sabre\\\\CalDAV\\\\Xml\\\\Request\\\\CalendarQueryReport), 'calendars\\/uzivatel...')\\n#12 \\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/sabre\\/event\\/lib\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#13 \\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/sabre\\/dav\\/lib\\/DAV\\/CorePlugin.php(716): Sabre\\\\Event\\\\EventEmitter->emit('report', Array)\\n#14 [internal function]: Sabre\\\\DAV\\\\CorePlugin->httpReport(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#15 \\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/sabre\\/event\\/lib\\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\\n#16 \\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(459): Sabre\\\\Event\\\\EventEmitter->emit('method:REPORT', Array)\\n#17 \\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(248): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#18 \\/var\\/www\\/nextcloud\\/htdocs\\/apps\\/dav\\/lib\\/Server.php(176): Sabre\\\\DAV\\\\Server->exec()\\n#19 \\/var\\/www\\/nextcloud\\/htdocs\\/apps\\/dav\\/appinfo\\/v2\\/remote.php(29): OCA\\\\DAV\\\\Server->exec()\\n#20 \\/var\\/www\\/nextcloud\\/htdocs\\/remote.php(164): require_once('\\/var\\/www\\/nextcloud\\/...')\\n#21 {main}\",\"File\":\"\\/var\\/www\\/nextcloud\\/htdocs\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/AbstractMySQLDriver.php\",\"Line\":71,\"User\":\"uzivatel\"}",
"method": "REPORT",
"remoteAddr": "186.9.12.13",
"reqId": "4RsVBm5CZTbywN7vH8MV",
"time": "2016-08-23T14:23:34+00:00",
"url": "/remote.php/dav/calendars/uzivatel/defaultcalendar/",
"user": "uzivatel"
}
```
Actual version 10.0_rc
PHP 5.6 & 7 tested
10.0.26-MariaDB
I can see calendars, I cannot synchronize and load entries.
log:
Fatal webdav Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing âSELECT id
, uri
, lastmodified
, etag
, calendarid
, size
, calendardata
, componenttype
, classification
FROM oc_calendarobjects
WHERE (calendarid
= ?) AND (uri
IN (?))â with params [â9â, â0452506d-401d-4813-ba5c-ccb2bdd47c85.1478112800473.icsâ]: SQLSTATE[42S02]: Base table or view not found: 1146 Table ânextcloud_db.oc_calendarobjectsâ doesnât exist
/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 116: 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 836: 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 189: 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 142: Doctrine\DBAL\Query\QueryBuilder->execute()
/var/www/nextcloud/apps/dav/lib/CalDAV/CalDavBackend.php - line 577: OC\DB\QueryBuilder\QueryBuilder->execute()
/var/www/nextcloud/apps/dav/lib/CalDAV/Calendar.php - line 202: OCA\DAV\CalDAV\CalDavBackend->getMultipleCalendarObjects(â9â, Array)
/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php - line 272: OCA\DAV\CalDAV\Calendar->getMultipleChildren(Array)
/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 960: Sabre\DAV\Tree->getMultipleNodes(Array)
/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Sync/Plugin.php - line 172: Sabre\DAV\Server->getPropertiesForMultiplePaths(Array, Array)
/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Sync/Plugin.php - line 144: Sabre\DAV\Sync\Plugin->sendSyncCollectionResponse(â134â, âcalendars/fannyâŠâ, Array, Array, Array, Array)
/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Sync/Plugin.php - line 65: Sabre\DAV\Sync\Plugin->syncCollection(âcalendars/fannyâŠâ, Object(Sabre\DAV\Xml\Request\SyncCollectionReport))
[internal function] Sabre\DAV\Sync\Plugin->Sabre\DAV\Sync{closure}(â{DAV }sync-collâŠâ, Object(Sabre\DAV\Xml\Request\SyncCollectionReport), âcalendars/fannyâŠâ)
/var/www/nextcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php - line 105: call_user_func_array(Object(Closure), Array)
/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php - line 716: Sabre\Event\EventEmitter->emit(âreportâ, Array)
[internal function] Sabre\DAV\CorePlugin->httpReport(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))
/var/www/nextcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php - line 105: call_user_func_array(Array, Array)
/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 459: Sabre\Event\EventEmitter->emit(âmethod REPORTâ, Array)
/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 248: Sabre\DAV\Server->invokeMethod(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))
/var/www/nextcloud/apps/dav/lib/Server.php - line 184: Sabre\DAV\Server->exec()
/var/www/nextcloud/apps/dav/appinfo/v2/remote.php - line 30: OCA\DAV\Server->exec()
/var/www/nextcloud/remote.php - line 165: require_once(â/var/www/nextclâŠâ)
{main}
tflidd
November 23, 2016, 9:07pm
2
You already linked the bugtracker issue, I think this is where it belongs.
sure⊠thanks anyone else has this problem?
my calendar is experiencing issues too, not show stopping ones though. Users whom I had deleted months ago, their subscribed calendars appear in my current users screens. It would let me delete them from the web gui, and I canât delete them from my calendar app on my mac pro either, so I have three extra checkboxes I canât get rid of which is kindof annoying.