error in logs, expects array gets string about activity HOT 11 CLOSED

Ok, database operations are not my forte, and I don't know what you are looking for, so see if this is what you wanted me to do:

MariaDB [owncloud]> SELECT `subject` FROM `oc_activity` WHERE `subjectparams` NOT LIKE '%}]'  AND `subjectparams` NOT LIKE '[{%' AND `app` = 'files' GROUP BY `subject`;
+--------------+
| subject      |
+--------------+
| changed_by   |
| changed_self |
| created_by   |
| created_self |
| deleted_by   |
| deleted_self |
+--------------+
6 rows in set (0.56 sec)

from activity.

Can you try to put the following files into apps/files_sharing/lib/Activity/Providers:
Providers.zip

from activity.

Can you please execute the following query on your database, to provide a bit more details?

SELECT `subject`
FROM `oc_activity`
WHERE `subjectparams` NOT LIKE '%}]'
    AND `subjectparams` NOT LIKE '[{%'
    AND `app` = 'files'
GROUP BY `subject`

from activity.

Seems to be related to nextcloud/server#3344 just want to make sure it's only the same entries.

from activity.

Thats good, thanks!

from activity.

Can you make the following change and see if that fixes your issue?
nextcloud/server@c031c77

from activity.

Note, my 11.0.1 installation (database / config file) was updated from OC8.2.2 to OC8.2.9 then NC9.something then NC10.0.3 then NC11.0.1

from activity.

I can try it later today, thanks...

from activity.

Ok, I patched my file (by hand!) looking at the diff in github, I think I did it correctly, but maybe for next time please tell me how to get a copy of the complete file with your pull request incorporated. Unfortunately the result is not what we hoped for. Upon loading the Activity page in the web interface, I now get this error, repeated:

{"reqId":"WJnxlAaiGR061yT36sOm8wAAAAU","remoteAddr":"myremoteIP","app":"PHP","message":"key() expects parameter 1 to be array, string given at \/var\/www\/html\/nextcloud\/apps\/files_sharing\/lib\/Activity\/Providers\/PublicLinks.php#216","level":3,"time":"2017-02-07T16:11:01+00:00","method":"GET","url":"\/nextcloud\/index.php\/apps\/activity\/api\/v2\/activity\/all?format=json&previews=true&since=0","user":"me","version":"11.0.1.2"}

{"reqId":"WJnxlAaiGR061yT36sOm8wAAAAU","remoteAddr":"myremoteIP","app":"PHP","message":"String offset cast occurred at \/var\/www\/html\/nextcloud\/apps\/files_sharing\/lib\/Activity\/Providers\/PublicLinks.php#218","level":3,"time":"2017-02-07T16:11:01+00:00","method":"GET","url":"\/nextcloud\/index.php\/apps\/activity\/api\/v2\/activity\/all?format=json&previews=true&since=0","user":"me","version":"11.0.1.2"}

from activity.

need to patch another file also, I guess???

from activity.

Works perfectly now, thank you!

from activity.