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

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"}

details on setup ?

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 DISTINCTs.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_streamsINNER JOINoc_social_a2_followsfON ((to= ?) OR (to_arrayCOLLATE utf8mb4_general_ci LIKE ?) OR (ccCOLLATE utf8mb4_general_ci LIKE ?) OR (bccCOLLATE utf8mb4_general_ci LIKE ?)) OR (((LOWER(s.to) = LOWER(f.follow_id)) OR (s.to_arrayCOLLATE utf8mb4_general_ci LIKE CONCAT(?, CONCAT(f.follow_id, ?))) OR (s.ccCOLLATE utf8mb4_general_ci LIKE CONCAT(?, CONCAT(f.follow_id, ?))) OR (s.bccCOLLATE utf8mb4_general_ci LIKE CONCAT(?, CONCAT(f.follow_id, ?)))) AND (LOWER(f.actor_id) = LOWER(?)) AND (f.accepted= ?)) LEFT JOINoc_social_a2_cache_actorscaON LOWER(f.object_id) = LOWER(ca.id) LEFT JOINoc_social_a2_stream_actionsaON ((LOWER(s.id) = LOWER(sa.stream_id)) OR (LOWER(s.object_id) = LOWER(sa.stream_id))) AND (LOWER(sa.actor_id) = ?) LEFT JOINoc_social_a2_followsfsON (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_timedesc 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

update on Social 0.2.6 solved this issue

1 Like