Audience qry issue
Hi Ray,
Thanks for getting back!
Just found the instructions on how to do this. Visit:
https://stackoverflow.com/questions/23921117/disable-only-full-group-by
Scroll down to the last screenshot.
The solution is there (I hope this will help others too).
There is sql error when I try to check the audience.
SELECT SentDateTime AS EntryDateTime, COUNT( SentDateTime )AS EntryCount, HOUR( SentDateTime ) AS Hours FROM pm1_mailing_audience_members WHERE MailingID = ? AND SentDateTime IS NOT NULL AND SentDateTime <> '0000-00-00 00:00:00' GROUP BY YEAR( SentDateTime ), MONTH( SentDateTime ), DAY( SentDateTime ), HOUR( SentDateTime ) ORDER BY SentDateTime
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mdsrtrt5_yia2.pm1_mailing_audience_members.SentDatetime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by