Skip to content

FIX: aggregated query error in MYSQL

M. Dent requested to merge dentm42/core:patch-20190113b into dev

Report:

2019-01-13T18:06:19Z:LOG_INFO:6ac86dc90d:queue_fn.php:65:remove_queue_item: queue: remove queue item 39b94b4f283cbc18e0b4908433f88af31ab8b4635a3679949feef61739e7174e
2019-01-13T18:06:19Z:LOG_ERR:6ac86dc90d:dba_driver.php:459:db_logger: dba_pdo: ERROR: select *,min(outq_created) as earliest from outq where outq_posturl = 'https://zot.social/post'
SQLSTATE[42000]: Syntax error or access violation: 1140 In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'hubzilla.outq.outq_hash'; this is incompatible with sql_mode=only_full_group_by

Merge request reports