"Failed to load more timeline entries" after update to latest NC

🍱 Features & apps social
1

recieving this error, log says

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘nextcloud.s.to’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"}

2

details on setup ?

3

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_idASfollowing_actor_id, ca.idAScacheactor_id, ca.typeAScacheactor_type, ca.accountAScacheactor_account, ca.followingAScacheactor_following, ca.followersAScacheactor_followers, ca.inboxAScacheactor_inbox, ca.shared_inboxAScacheactor_shared_inbox, ca.outboxAScacheactor_outbox, ca.featuredAScacheactor_featured, ca.urlAScacheactor_url, ca.preferred_usernameAScacheactor_preferred_username, ca.nameAScacheactor_name, ca.summaryAScacheactor_summary, ca.public_keyAScacheactor_public_key, ca.sourceAScacheactor_source, ca.creationAScacheactor_creation, ca.localAScacheactor_local, sa.idASstreamaction_id, sa.actor_idASstreamaction_actor_id, sa.stream_idASstreamaction_stream_id, sa.valuesASstreamaction_valuesFROMoc_social_a2_stream sINNER JOINoc_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 JOINoc_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 BYs.idORDER BYs.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

4

update on Social 0.2.6 solved this issue

1 Like