Hi!
I have a problem on my website
after the update
from mysqll
my website presents the following error
Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'server002_latino.a.id_attach' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
You only have to run that command once, before running the queries that give you errors. Usually it is best to add it to a file that is included with every script (in the ideal case, your application may have a library that it uses for MySQL, and you could add it to an initialization routine there).
Changing the query itself to add ANY_VALUE() around the columns that MySQL has told you that it has a problem with. For instance, this query:
SELECT name, ANY_VALUE(address), MAX(age) FROM t GROUP BY name;
In your specific case, id_attach appears to be the column that you would need to add ANY_VALUE() around. But, there may also be others. Basically, you have to put it around any column that MySQL would have to pick its final value from (because it can't deterministically decide what to select among the members of the group) before returning the result.