'Error loading activities' notification after clicking on any folder in files view
Steps to reproduce
- Log into owncloud server
- Click on any folder
Expected behaviour
I should see a list of activities performed on the folder
Actual behaviour
Sidebar opens, error notification received.
Server configuration
Operating system: Max OS X El Capitan
Web server: Shared reseller server on hostrocket.com - Apache Database: MySQL
PHP version: 5.6
ownCloud version: (see ownCloud admin page) 9.1
Where did you install ownCloud from: zip file, uploaded to server, manual upgrade
Signing status (ownCloud 9.0 and above):
No errors have been found.
List of activated apps:
Enabled:
- activity: 2.3.2
- comments: 0.3.0
- dav: 0.2.5
- federatedfilesharing: 0.3.0
- federation: 0.1.0
- files: 1.5.1
- files_pdfviewer: 0.8.1
- files_sharing: 0.10.0
- files_texteditor: 2.1
- files_trashbin: 0.9.0
- files_versions: 1.3.0
- files_videoplayer: 0.9.8
- firstrunwizard: 1.1
- gallery: 15.0.0
- notifications: 0.3.0
- provisioning_api: 0.5.0
- systemtags: 0.3.0
- templateeditor: 0.1
- updatenotification: 0.2.1
Disabled:
- encryption
- external
- files_antivirus
- files_external
- user_external
- user_ldap
The content of config/config.php:
{
"system": {
"instanceid": "oc4rpucjji05",
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"cloud.geligelu.com",
"geligelu.com"
],
"datadirectory": "\/home\/techfact\/public_html\/cloud\/data",
"overwrite.cli.url": "http:\/\/cloud.geligelu.com",
"dbtype": "mysql",
"version": "9.1.0.15",
"dbname": "techfact_owncloud",
"dbhost": "localhost",
"dbtableprefix": "oc_",
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"theme": "",
"loglevel": 0,
"maintenance": false,
"mail_from_address": "cloud",
"mail_smtpmode": "php",
"mail_domain": "geligelu.com",
"memcache.local": "\\OC\\Memcache\\APCu",
"trashbin_retention_obligation": "auto"
}
}
Are you using external storage, if yes which one: no
Are you using encryption: /no
Are you using an external user-backend, if yes which one: no
Client configuration
Browser: Chrome 53 Mac Operating system: Mac OS X
Logs
ownCloud log (data/owncloud.log)
[owncloud.log.txt](https://github.com/owncloud/activity/files/461279/owncloud.log.txt)
Browser log
GET https://cloud.geligelu.com/index.php/apps/activity/api/v2/activity/filter?format=json&object_type=files&object_id=4 403 (Forbidden)send @ jquery.js:8630ajax @ jquery.js:8166Backbone.ajax @ backbone.js?v=dfd5322…:1428Backbone.sync @ backbone.js?v=dfd5322…:1411sync @ backbone.js?v=dfd5322…:796fetch @ backbone.js?v=dfd5322…:1031setFileInfo @ activitytabview.js?v=dfd5322…:81setFileInfo @ detailsview.js?v=dfd5322…:237_updateDetailsView @ filelist.js?v=dfd5322…:490_onClickFile @ filelist.js?v=dfd5322…:614dispatch @ jquery.js:4435r.handle @ jquery.js:4121
Any movement on this?
Der Fehler betrifft nicht nur die Ausgabe der Aktivitäten sondern auch das Speichern. Seit dem Update auf 8.2.7 habe ich keine Einträge in der Tabelle oc_activity Und auch bei der Abfrage der Aktivitäten für eine Datei scheint ein Fehler enthalten zu sein:
An exception occurred while executing 'SELECT * FROM `oc_activity` WHERE `affecteduser` = ?
AND `type` IN (?,?,?,?,?,?,?) AND `object_type` = ? AND `object_id` = ? ORDER BY `timestamp`
DESC LIMIT 30 OFFSET 0' with params [\"superuser\", \"file_created\", \"file_changed\",
\"file_deleted\", \"file_restored\", \"shared\", \"remote_share\", \"public_links\", \"files\",
164418]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'object_type'
in 'where clause'","Code":0,"Trace":"#0
Gibt es dafür eine Lösung / Update / Workaround