owncloud / activity

:zap: Activity app for ownCloud
33 stars 40 forks source link

'Error loading activities' notification after clicking on any folder in files view #538

Open ortonomy opened 8 years ago

ortonomy commented 8 years ago
### Steps to reproduce 1. Log into owncloud server 2. Click on any folder 3. ### 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 ```
ortonomy commented 8 years ago

Any movement on this?

antilet commented 8 years ago

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