string(1031) "Error!: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'buzzmatepro.s.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
object(PDOStatement)#4 (1) { ["queryString"]=> string(554) "SELECT *, ROUND(AVG(s.tweetNb)) as tweetNb, ROUND(AVG(s.tweetNb)/3600*(UNIX_TIMESTAMP(stop)-UNIX_TIMESTAMP(start))) as tweetNbByBroadcast, c.id as channel_id, c.name_search as channel_name_search, c.name as channel_name, ts.name as tvshow_name FROM statsTweet s INNER JOIN channel c ON s.channel = c.id LEFT JOIN tvshow ts ON s.tvshow = ts.id LEFT JOIN broadcast b ON s.broadcast = b.id WHERE date >=:start AND date <=:stop GROUP BY broadcast ORDER BY channel_id ASC, date ASC " } array(2) { ["start"]=> &string(19) "2021-08-01 21:00:00" ["stop"]=> &string(19) "2021-08-01 23:59:59" } " object(Exception)#3 (7) { ["message":protected]=> string(146) "https://www.matelebuzz.com/api/StatsTweet/getAllByDate?params=JTI2c3RhcnQlM0QxNjI3ODQ0NDAwJTI2c3RvcCUzRDE2Mjc4NTUxOTklMjZncm91cCUzRGJyb2FkY2FzdA==" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(0) ["file":protected]=> string(31) "/var/www/mtb/controllers/WS.php" ["line":protected]=> int(58) ["trace":"Exception":private]=> array(2) { [0]=> array(5) { ["file"]=> string(39) "/var/www/mtb/controllers/Dispatcher.php" ["line"]=> int(148) ["function"]=> string(6) "callWS" ["class"]=> string(2) "WS" ["type"]=> string(2) "->" } [1]=> array(5) { ["file"]=> string(22) "/var/www/mtb/index.php" ["line"]=> int(6) ["function"]=> string(8) "dispatch" ["class"]=> string(10) "Dispatcher" ["type"]=> string(2) "::" } } ["previous":"Exception":private]=> NULL }