the sql statement for the for the details pare that is meant to handle is saying its invalid
I am trying to generate details page with MRT elements.
I am using code manually clonened from working entity generate ore PHP7 & DA v2 changing table names as required
SELECT dbmADI.*, GROUP_CONCAT(dbmSite.dbmSite ORDER BY dbmSite.dbmSite ASC SEPARATOR ', ') AS SelSites FROM dbmADI LEFT OUTER JOIN MRT07 ON dbmADI.dbmADIID = MRT07.MRT07dbmADIID LEFT OUTER JOIN dbmSite ON dbmSite.dbmSiteID = MRT07.MRT07dbmSiteID WHERE dbmADI.dbmADIID = ?
In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'local_dbm.dbmADI.dbmADIID'; this is incompatible with sql_mode=only_full_group_by
Any suggestion.
NB this is currently on localhost