of course:
Full Log (names and hosts marked with X):
500 - {"status":-1,"exception":"Doctrine\\DBAL\\Exception\\DriverException","message":"An exception occurred while executing 'SELECT DISTINCT
s.
id,
s.
type,
s.
to,
s.
to_array,
s.
cc,
s.
bcc,
s.
content,
s.
summary,
s.
attachments,
s.
published,
s.
published_time,
s.
cache,
s.
object_id,
s.
attributed_to,
s.
in_reply_to,
s.
source,
s.
local,
s.
instances,
s.
creation,
s.
hidden_on_timeline,
f.
object_idAS
following_actor_id,
ca.
idAS
cacheactor_id,
ca.
typeAS
cacheactor_type,
ca.
accountAS
cacheactor_account,
ca.
followingAS
cacheactor_following,
ca.
followersAS
cacheactor_followers,
ca.
inboxAS
cacheactor_inbox,
ca.
shared_inboxAS
cacheactor_shared_inbox,
ca.
outboxAS
cacheactor_outbox,
ca.
featuredAS
cacheactor_featured,
ca.
urlAS
cacheactor_url,
ca.
preferred_usernameAS
cacheactor_preferred_username,
ca.
nameAS
cacheactor_name,
ca.
summaryAS
cacheactor_summary,
ca.
public_keyAS
cacheactor_public_key,
ca.
sourceAS
cacheactor_source,
ca.
creationAS
cacheactor_creation,
ca.
localAS
cacheactor_local,
sa.
idAS
streamaction_id,
sa.
actor_idAS
streamaction_actor_id,
sa.
stream_idAS
streamaction_stream_id,
sa.
valuesAS
streamaction_valuesFROM
oc_social_a2_stream
sINNER JOIN
oc_social_a2_follows
f ON ((
to = ?) OR (
to_array COLLATE utf8mb4_general_ci LIKE ?) OR (
cc COLLATE utf8mb4_general_ci LIKE ?) OR (
bcc COLLATE utf8mb4_general_ci LIKE ?)) OR (((LOWER(
s.
to) = LOWER(
f.
follow_id)) OR (
s.
to_array COLLATE utf8mb4_general_ci LIKE CONCAT(?, CONCAT(
f.
follow_id, ?))) OR (
s.
cc COLLATE utf8mb4_general_ci LIKE CONCAT(?, CONCAT(
f.
follow_id, ?))) OR (
s.
bcc COLLATE utf8mb4_general_ci LIKE CONCAT(?, CONCAT(
f.
follow_id, ?)))) AND (LOWER(
f.
actor_id) = LOWER(?)) AND (
f.
accepted= ?)) LEFT JOIN
oc_social_a2_cache_actors
ca ON LOWER(
f.
object_id) = LOWER(
ca.
id) LEFT JOIN
oc_social_a2_stream_action
sa ON ((LOWER(
s.
id) = LOWER(
sa.
stream_id)) OR (LOWER(
s.
object_id) = LOWER(
sa.
stream_id))) AND (LOWER(
sa.
actor_id) = ?) LEFT JOIN
oc_social_a2_follows
fs ON (LOWER(
fs.
actor_id) = LOWER(?)) AND (LOWER(
s.
attributed_to) = LOWER(
fs.
object_id)) AND (
fs.
accepted = ?) WHERE (
s.
published_time <= ?) AND ((
s.
hidden_on_timeline = ?) OR ((LOWER(
attributed_to) <> LOWER(?)) AND (
fs.
idIS NULL))) GROUP BY
s.
idORDER BY
s.
published_time desc LIMIT 25' with params [\"https:\\\/\\\/cloud.XXXXX.de\\\/apps\\\/social\\\/@XXXXX\\\/followers\", \"%\\\"https:\\\/\\\/cloud.XXXXX.de\\\/apps\\\/social\\\/@XXXXX\\\/followers\\\"%\", \"%\\\"https:\\\/\\\/cloud.XXXXX.de\\\/apps\\\/social\\\/@XXXXX\\\/followers\\\"%\", \"%\\\"https:\\\/\\\/cloud.XXXXX.de\\\/apps\\\/social\\\/@XXXXX\\\/followers\\\"%\", \"%\\\"\", \"\\\"%\", \"%\\\"\", \"\\\"%\", \"%\\\"\", \"\\\"%\", \"https:\\\/\\\/cloud.XXXXX.de\\\/apps\\\/social\\\/@XXXXX\", 1, \"https:\\\/\\\/cloud.XXXXX.de\\\/apps\\\/social\\\/@XXXXX\", \"https:\\\/\\\/cloud.XXXXX.de\\\/apps\\\/social\\\/@XXXXX\", 1, \"2019-06-24 09:22:25\", 0, \"https:\\\/\\\/cloud.XXXXX.de\\\/apps\\\/social\\\/@XXXXX\"]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nextcloud.s.type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"}
NC Version 16.0.1 (occ status says version 16.0.1.1)
Social App 0.2.5
running on Ubuntu + mySQL (full patched)
I’ve tried occ repair, convert-filecache-bigint and add-missing-indices before, nothing helped