Web App cannot query DB
I recently migrated my DB to the DO VPS, all went well, I’ve updated my webapp to query the localhost DB instead of the old one but I get error like this:
SQLSTATE: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘myDB.p0.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sqlmode=onlyfullgroup_by"
My app is developed on the Symfony 3 framework, with Doctrine ORM.
Please let me know what I can do to fix that error.