Activated activity app breaks file-(un)sharing and downloading

[stonie08]

I'm running a Nextcloud installation that has been updates several times and up until now I always had the activity app deactivated. When activating it now it breaks unsharing of files and results in an Internal Server Error when pressing the download button at a shared link. Everythings working fine as long as the activity app is disabled.

Steps to reproduce

1. Activate Activity App
2. In the web-interface select a file and make the sharing sidemenu come up -> (Non displayed internal server error)
3. Press "Share Link" (Second part of non displayed server error)
4. Paste the shared link in a new window and try to download the file (Results in an internal Server Error)
5. Try to unshare the link (does not work, results in a little pop-up with Invalid query, please check the syntax. API specifications are here: http://www.freedesktop.org/wiki/Specifications/open-collaboration-services.

Expected behaviour

Activating the Activity app should still allow me to share, unshare and download shared files

Actual behaviour

Mutlitple server server errors, prevents downloading and unsharing files.

Server configuration

Operating system:
Debian Stretch
Web server:
Apache/2.4.25 (Debian)
Database:
mariadb Ver 15.1 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
PHP version:
PHP 7.0.27-0+deb9u1 (cli)
Nextcloud version: (see Nextcloud admin page)
13.0.2.1
Where did you install Nextcloud from:
Archive from website
Signing status:

No errors have been found.

List of activated apps:

Enabled:
  - activity: 2.6.1
  - admin_audit: 1.3.0
  - bookmarks: 0.11.0
  - bruteforcesettings: 1.0.3
  - calendar: 1.6.1
  - comments: 1.3.0
  - contacts: 2.1.3
  - dav: 1.4.6
  - end_to_end_encryption: 1.0.5
  - external: 3.0.2
  - federatedfilesharing: 1.3.1
  - federation: 1.3.0
  - files: 1.8.0
  - files_external: 1.4.1
  - files_pdfviewer: 1.2.1
  - files_sharing: 1.5.0
  - files_texteditor: 2.5.1
  - files_videoplayer: 1.2.0
  - firstrunwizard: 2.2.1
  - gallery: 18.0.0
  - gpxedit: 0.0.8
  - gpxmotion: 0.0.6
  - gpxpod: 2.2.2
  - logreader: 2.0.0
  - lookup_server_connector: 1.1.0
  - nextcloud_announcements: 1.2.0
  - notes: 2.3.2
  - notifications: 2.1.2
  - oauth2: 1.1.0
  - password_policy: 1.3.0
  - provisioning_api: 1.3.0
  - qownnotesapi: 17.5.0
  - serverinfo: 1.3.0
  - systemtags: 1.3.0
  - tasks: 0.9.6
  - theming: 1.4.1
  - twofactor_backupcodes: 1.2.3
  - updatenotification: 1.3.0
  - workflowengine: 1.3.0
Disabled:
  - encryption
  - files_trashbin
  - files_versions
  - sharebymail
  - spreed
  - survey_client
  - user_external
  - user_ldap
  - user_usage_report

Nextcloud configuration:

{
    "system": {
        "preview_libreoffice_path": "\/usr\/bin\/libreoffice",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "13.0.2.1",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "loglevel": 3,
        "log_rotate_size": 104857600,
        "maintenance": false,
        "forcessl": true,
        "theme": "",
        "allowZipDownload": true,
        "maxZipInputSize": 838860800,
        "trusted_domains": [***REMOVED SENSITIVE VALUE***],
        "overwrite.cli.url": "\/owncloud",
        "overwritewebroot": "\/owncloud",
        "htaccess.RewriteBase": "\/owncloud",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "php",
        "appstore.experimental.enabled": true,
        "updatechecker": true,
        "updater.release.channel": "stable",
        "memcache.local": "\\OC\\Memcache\\APCu"
    }
}

Client configuration

Browser:
Firefox 59.0.2

Operating system:
Windows 7

Logs

Nextcloud log (data/nextcloud.log)

opening share menue and pressing "Share Link"

{"reqId":"8aABlXht4NnTI4JdGnjd","level":3,"time":"2018-04-26T13:53:16+00:00","remoteAddr":"10.0.2.250","user":"stonie","app":"no app in context","method":"GET","url":"\/owncloud\/ocs\/v2.php\/apps\/activity\/api\/v2\/activity\/filter?format=json&object_type=files&object_id=429631","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\InvalidFieldNameException\",\"Message\":\"An exception occurred while executing 'SELECT * FROM `oc_activity` WHERE (`affecteduser` = ?) AND (`type` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`object_type` = ?) AND (`object_id` = ?) ORDER BY `timestamp` DESC, `activity_id` DESC LIMIT 51' with params [\\\"stonie\\\", \\\"personal_settings\\\", \\\"security\\\", \\\"favorite\\\", \\\"file_changed\\\", \\\"file_created\\\", \\\"file_deleted\\\", \\\"file_restored\\\", \\\"comments\\\", \\\"calendar\\\", \\\"calendar_event\\\", \\\"calendar_todo\\\", \\\"shared\\\", \\\"remote_share\\\", \\\"public_links\\\", \\\"systemtags\\\", \\\"files\\\", 429631]:\\n\\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'object_type' in 'where clause'\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(855): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'SELECT * FROM `...', Array)\\n#2 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(195): Doctrine\\\\DBAL\\\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\\n#3 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(206): OC\\\\DB\\\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\\n#4 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(214): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/Data.php(257): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/Controller\\\/APIv2.php(272): OCA\\\\Activity\\\\Data->get(Object(OCA\\\\Activity\\\\GroupHelper), Object(OCA\\\\Activity\\\\UserSettings), 'stonie', 0, 50, 'desc', 'filter', 'files', 429631)\\n#7 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/Controller\\\/APIv2.php(208): OCA\\\\Activity\\\\Controller\\\\APIv2->get('filter', 0, 50, false, 'files', 429631, 'desc')\\n#8 [internal function]: OCA\\\\Activity\\\\Controller\\\\APIv2->getFilter('filter', 0, 50, false, 'files', 429631, 'desc')\\n#9 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(161): call_user_func_array(Array, Array)\\n#10 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(91): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OCA\\\\Activity\\\\Controller\\\\APIv2), 'getFilter')\\n#11 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/App.php(115): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OCA\\\\Activity\\\\Controller\\\\APIv2), 'getFilter')\\n#12 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Routing\\\/RouteActionHandler.php(47): OC\\\\AppFramework\\\\App::main('APIv2Controller', 'getFilter', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer), Array)\\n#13 [internal function]: OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler->__invoke(Array)\\n#14 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/Route\\\/Router.php(297): call_user_func(Object(OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler), Array)\\n#15 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/ocs\\\/v1.php(78): OC\\\\Route\\\\Router->match('\\\/ocsapp\\\/apps\\\/ac...')\\n#16 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/ocs\\\/v2.php(24): require_once('\\\/var\\\/www\\\/home.s...')\\n#17 {main}\",\"File\":\"\\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":71}","userAgent":"Mozilla\/5.0 (Windows NT 6.1; Win64; x64; rv:59.0) Gecko\/20100101 Firefox\/59.0","version":"13.0.2.1"}
{"reqId":"FMJpxPfSgJwqGCxqeN2G","level":3,"time":"2018-04-26T13:53:19+00:00","remoteAddr":"10.0.2.250","user":"stonie","app":"no app in context","method":"POST","url":"\/owncloud\/ocs\/v2.php\/apps\/files_sharing\/api\/v1\/shares?format=json","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\InvalidFieldNameException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_activity` (`app`, `subject`, `subjectparams`, `message`, `messageparams`, `file`, `link`, `user`, `affecteduser`, `timestamp`, `priority`, `type`, `object_type`, `object_id`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\\\"files_sharing\\\", \\\"shared_link_self\\\", \\\"[{\\\\\\\"429631\\\\\\\":\\\\\\\"\\\\\\\\\\\\\\\/clientsync\\\\\\\\\\\\\\\/2017-05-18 18-00-39 6441.jpg\\\\\\\"}]\\\", \\\"\\\", \\\"[]\\\", \\\"\\\\\\\/clientsync\\\\\\\/2017-05-18 18-00-39 6441.jpg\\\", \\\"https:\\\\\\\/\\\\\\\/example.com\\\\\\\/owncloud\\\\\\\/apps\\\\\\\/files\\\\\\\/?dir=\\\\\\\/clientsync\\\", \\\"stonie\\\", \\\"stonie\\\", 1524750799, 30, \\\"shared\\\", \\\"files\\\", 429631]:\\n\\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'object_type' in 'field list'\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(216): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(208): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#4 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(214): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/Data.php(100): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/FilesHooks.php(1088): OCA\\\\Activity\\\\Data->send(Object(OC\\\\Activity\\\\Event))\\n#7 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/FilesHooks.php(763): OCA\\\\Activity\\\\FilesHooks->addNotificationsForUser('stonie', 'shared_link_sel...', Array, 429631, '\\\/clientsync\\\/201...', true, true, false)\\n#8 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/FilesHooks.php(681): OCA\\\\Activity\\\\FilesHooks->shareByLink(429631, 'file', 'stonie')\\n#9 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/FilesHooksStatic.php(95): OCA\\\\Activity\\\\FilesHooks->share(Array)\\n#10 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/legacy\\\/hook.php(106): OCA\\\\Activity\\\\FilesHooksStatic::share(Array)\\n#11 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/Share20\\\/LegacyHooks.php(170): OC_Hook::emit('OCP\\\\\\\\Share', 'post_shared', Array)\\n#12 [internal function]: OC\\\\Share20\\\\LegacyHooks->postShare(Object(Symfony\\\\Component\\\\EventDispatcher\\\\GenericEvent), 'OCP\\\\\\\\Share::post...', Object(Symfony\\\\Component\\\\EventDispatcher\\\\EventDispatcher))\\n#13 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/symfony\\\/event-dispatcher\\\/EventDispatcher.php(212): call_user_func(Array, Object(Symfony\\\\Component\\\\EventDispatcher\\\\GenericEvent), 'OCP\\\\\\\\Share::post...', Object(Symfony\\\\Component\\\\EventDispatcher\\\\EventDispatcher))\\n#14 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/symfony\\\/event-dispatcher\\\/EventDispatcher.php(44): Symfony\\\\Component\\\\EventDispatcher\\\\EventDispatcher->doDispatch(Array, 'OCP\\\\\\\\Share::post...', Object(Symfony\\\\Component\\\\EventDispatcher\\\\GenericEvent))\\n#15 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/Share20\\\/Manager.php(669): Symfony\\\\Component\\\\EventDispatcher\\\\EventDispatcher->dispatch('OCP\\\\\\\\Share::post...', Object(Symfony\\\\Component\\\\EventDispatcher\\\\GenericEvent))\\n#16 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/files_sharing\\\/lib\\\/Controller\\\/ShareAPIController.php(488): OC\\\\Share20\\\\Manager->createShare(Object(OC\\\\Share20\\\\Share))\\n#17 [internal function]: OCA\\\\Files_Sharing\\\\Controller\\\\ShareAPIController->createShare(Object(OC\\\\Files\\\\Node\\\\File), 3, 3, NULL, 'false', '', Object(DateTime))\\n#18 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(161): call_user_func_array(Array, Array)\\n#19 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(91): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OCA\\\\Files_Sharing\\\\Controller\\\\ShareAPIController), 'createShare')\\n#20 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/App.php(115): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OCA\\\\Files_Sharing\\\\Controller\\\\ShareAPIController), 'createShare')\\n#21 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Routing\\\/RouteActionHandler.php(47): OC\\\\AppFramework\\\\App::main('OCA\\\\\\\\Files_Shari...', 'createShare', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer), Array)\\n#22 [internal function]: OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler->__invoke(Array)\\n#23 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/Route\\\/Router.php(297): call_user_func(Object(OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler), Array)\\n#24 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/ocs\\\/v1.php(78): OC\\\\Route\\\\Router->match('\\\/ocsapp\\\/apps\\\/fi...')\\n#25 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/ocs\\\/v2.php(24): require_once('\\\/var\\\/www\\\/home.s...')\\n#26 {main}\",\"File\":\"\\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":71}","userAgent":"Mozilla\/5.0 (Windows NT 6.1; Win64; x64; rv:59.0) Gecko\/20100101 Firefox\/59.0","version":"13.0.2.1"}

Downloading

{"reqId":"vanq88U3G8VU3TJYwd43","level":3,"time":"2018-04-26T13:41:36+00:00","remoteAddr":"10.0.2.250","user":"--","app":"index","method":"GET","url":"\/owncloud\/index.phpEyBDe6bo\/download","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\InvalidFieldNameException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_activity` (`app`, `subject`, `subjectparams`, `message`, `messageparams`, `file`, `link`, `user`, `affecteduser`, `timestamp`, `priority`, `type`, `object_type`, `object_id`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\\\"files_sharing\\\", \\\"public_shared_file_downloaded\\\", \\\"[\\\\\\\"\\\\\\\\\\\\\\\/clientsync\\\\\\\\\\\\\\\/2017-05-18 18-00-39 6441.jpg\\\\\\\"]\\\", \\\"\\\", \\\"[]\\\", \\\"\\\\\\\/clientsync\\\\\\\/2017-05-18 18-00-39 6441.jpg\\\", \\\"\\\", \\\"\\\", \\\"stonie\\\", 1524750096, 30, \\\"public_links\\\", \\\"files\\\", 429631]:\\n\\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'object_type' in 'field list'\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(216): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(208): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#4 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(214): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/Data.php(100): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/Consumer.php(76): OCA\\\\Activity\\\\Data->send(Object(OC\\\\Activity\\\\Event))\\n#7 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/Activity\\\/Manager.php(196): OCA\\\\Activity\\\\Consumer->receive(Object(OC\\\\Activity\\\\Event))\\n#8 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/files_sharing\\\/lib\\\/Controller\\\/ShareController.php(645): OC\\\\Activity\\\\Manager->publish(Object(OC\\\\Activity\\\\Event))\\n#9 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/files_sharing\\\/lib\\\/Controller\\\/ShareController.php(616): OCA\\\\Files_Sharing\\\\Controller\\\\ShareController->publishActivity('public_shared_f...', Array, 'stonie', 429631, '\\\/clientsync\\\/201...')\\n#10 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/files_sharing\\\/lib\\\/Controller\\\/ShareController.php(496): OCA\\\\Files_Sharing\\\\Controller\\\\ShareController->singleFileDownloaded(Object(OC\\\\Share20\\\\Share), Object(OC\\\\Files\\\\Node\\\\File))\\n#11 [internal function]: OCA\\\\Files_Sharing\\\\Controller\\\\ShareController->downloadShare('kA2aRrSEyBDe6bo', NULL, '', '')\\n#12 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(161): call_user_func_array(Array, Array)\\n#13 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(91): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OCA\\\\Files_Sharing\\\\Controller\\\\ShareController), 'downloadShare')\\n#14 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/App.php(115): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OCA\\\\Files_Sharing\\\\Controller\\\\ShareController), 'downloadShare')\\n#15 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/public\\\/AppFramework\\\/App.php(138): OC\\\\AppFramework\\\\App::main('ShareController', 'downloadShare', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer))\\n#16 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/core\\\/routes.php(136): OCP\\\\AppFramework\\\\App->dispatch('ShareController', 'downloadShare')\\n#17 [internal function]: OC\\\\Route\\\\Router->{closure}(*** sensitive parameters replaced ***)\\n#18 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/Route\\\/Router.php(297): call_user_func(Object(Closure), Array)\\n#19 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/base.php(999): OC\\\\Route\\\\Router->match('\\\/s\\\/kA2aRrSEyBDe...')\\n#20 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/index.php(37): OC::handleRequest()\\n#21 {main}\",\"File\":\"\\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":71}","userAgent":"Mozilla\/5.0 (Windows NT 6.1; Win64; x64; rv:59.0) Gecko\/20100101 Firefox\/59.0","version":"13.0.2.1"}

Unsharing

{"reqId":"sPITBofD3kOQCtmUW1za","level":3,"time":"2018-04-26T13:42:22+00:00","remoteAddr":"10.0.2.250","user":"stonie","app":"no app in context","method":"DELETE","url":"\/owncloud\/ocs\/v2.php\/apps\/files_sharing\/api\/v1\/shares\/406?format=json","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\InvalidFieldNameException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_activity` (`app`, `subject`, `subjectparams`, `message`, `messageparams`, `file`, `link`, `user`, `affecteduser`, `timestamp`, `priority`, `type`, `object_type`, `object_id`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\\\"files_sharing\\\", \\\"unshared_link_self\\\", \\\"[{\\\\\\\"429631\\\\\\\":\\\\\\\"\\\\\\\\\\\\\\\/2017-05-18 18-00-39 6441.jpg\\\\\\\"}]\\\", \\\"\\\", \\\"[]\\\", \\\"\\\\\\\/2017-05-18 18-00-39 6441.jpg\\\", \\\"https:\\\\\\\/\\\\\\\/example.com\\\\\\\/owncloud\\\\\\\/apps\\\\\\\/files\\\\\\\/?dir=\\\\\\\/\\\", \\\"stonie\\\", \\\"stonie\\\", 1524750142, 30, \\\"shared\\\", \\\"files\\\", 429631]:\\n\\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'object_type' in 'field list'\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1015): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/DB\\\/Connection.php(216): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(208): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#4 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(214): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/Data.php(100): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/FilesHooks.php(1088): OCA\\\\Activity\\\\Data->send(Object(OC\\\\Activity\\\\Event))\\n#7 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/FilesHooks.php(857): OCA\\\\Activity\\\\FilesHooks->addNotificationsForUser('stonie', 'unshared_link_s...', Array, 429631, '\\\/2017-05-18 18-...', true, true, false)\\n#8 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/FilesHooks.php(779): OCA\\\\Activity\\\\FilesHooks->unshareLink(Object(OC\\\\Share20\\\\Share))\\n#9 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/activity\\\/lib\\\/FilesHooksStatic.php(105): OCA\\\\Activity\\\\FilesHooks->unShare(Object(OC\\\\Share20\\\\Share))\\n#10 [internal function]: OCA\\\\Activity\\\\FilesHooksStatic::unShare(Object(Symfony\\\\Component\\\\EventDispatcher\\\\GenericEvent), 'OCP\\\\\\\\Share::preU...', Object(Symfony\\\\Component\\\\EventDispatcher\\\\EventDispatcher))\\n#11 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/symfony\\\/event-dispatcher\\\/EventDispatcher.php(212): call_user_func(Array, Object(Symfony\\\\Component\\\\EventDispatcher\\\\GenericEvent), 'OCP\\\\\\\\Share::preU...', Object(Symfony\\\\Component\\\\EventDispatcher\\\\EventDispatcher))\\n#12 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/symfony\\\/event-dispatcher\\\/EventDispatcher.php(44): Symfony\\\\Component\\\\EventDispatcher\\\\EventDispatcher->doDispatch(Array, 'OCP\\\\\\\\Share::preU...', Object(Symfony\\\\Component\\\\EventDispatcher\\\\GenericEvent))\\n#13 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/Share20\\\/Manager.php(944): Symfony\\\\Component\\\\EventDispatcher\\\\EventDispatcher->dispatch('OCP\\\\\\\\Share::preU...', Object(Symfony\\\\Component\\\\EventDispatcher\\\\GenericEvent))\\n#14 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/apps\\\/files_sharing\\\/lib\\\/Controller\\\/ShareAPIController.php(302): OC\\\\Share20\\\\Manager->deleteShare(Object(OC\\\\Share20\\\\Share))\\n#15 [internal function]: OCA\\\\Files_Sharing\\\\Controller\\\\ShareAPIController->deleteShare('406')\\n#16 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(161): call_user_func_array(Array, Array)\\n#17 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(91): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OCA\\\\Files_Sharing\\\\Controller\\\\ShareAPIController), 'deleteShare')\\n#18 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/App.php(115): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OCA\\\\Files_Sharing\\\\Controller\\\\ShareAPIController), 'deleteShare')\\n#19 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Routing\\\/RouteActionHandler.php(47): OC\\\\AppFramework\\\\App::main('OCA\\\\\\\\Files_Shari...', 'deleteShare', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer), Array)\\n#20 [internal function]: OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler->__invoke(Array)\\n#21 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/lib\\\/private\\\/Route\\\/Router.php(297): call_user_func(Object(OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler), Array)\\n#22 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/ocs\\\/v1.php(78): OC\\\\Route\\\\Router->match('\\\/ocsapp\\\/apps\\\/fi...')\\n#23 \\\/var\\\/www\\\/example.com\\\/owncloud\\\/ocs\\\/v2.php(24): require_once('\\\/var\\\/www\\\/home.s...')\\n#24 {main}\",\"File\":\"\\\/var\\\/www\\\/example.com\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":71}","userAgent":"Mozilla\/5.0 (Windows NT 6.1; Win64; x64; rv:59.0) Gecko\/20100101 Firefox\/59.0","version":"13.0.2.1"}

Browser log

--

[segv2]

I can confirm this bug, I just ran into it.

[nickvergessen]

Unknown column 'object_type' in 'field list'

Duplicate of nextcloud/server#13549