Hi , after installed the plugin i tried to access the setting page(ajaylulia/ostorelocator/branchhits) and came to this error
`SQLSTATE: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cms.b.date_hits' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select s.id as storeid,name, date_hits, SUM(hits) as hits, DATE_ADD(date_hits, INTERVAL(1-DAYOFWEEK(date_hits)) DAY) as startdate, DATE_ADD(date_hits, INTERVAL(7-DAYOFWEEK(date_hits)) DAY) as enddate from `ajaylulia_ostorelocator_branch_hit` as `b` inner join `ajaylulia_ostorelocator_jsp_stores` as `s` on `b`.`store_id` = `s`.`id` where MONTH(date_hits) = 07 and YEAR(date_hits) = 2021 group by WEEK(date_hits), s.id)`
I search and found there is 2 solution which i already tried both
`SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));`
We are proud to announce that the stable release of the October CMS 2 is now available! The release represents over a year of design, research and development effort, which resulted in multiple new features and changes.