activity icon indicating copy to clipboard operation
activity copied to clipboard

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

Open ortonomy opened this issue 9 years ago • 2 comments

Steps to reproduce

  1. Log into owncloud server
  2. 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

ortonomy avatar Sep 08 '16 09:09 ortonomy

Any movement on this?

ortonomy avatar Sep 21 '16 14:09 ortonomy

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

antilet avatar Nov 18 '16 11:11 antilet