Fix an error with mysql after server migration
The error upon running a script is:
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '####.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Googling seems to suggest its related to moving from an old version of mysql to a new one. The script itself is very old also.
33 freelancers estão ofertando em média $24 nesse trabalho
i fixed similar issue few times. it shows when the old script run in mysql new version. group by needs to modify in that query. in 1-2 places may there..where it needs to modify query.
Hi I can start your project right away and can fix the query issue. Please send me a message in a chat so we can discuss your requirements in detail. Thank you!
i can fix your error right now,i can fix your error right now,i can fix your error right nowi can fix your error right now,i can fix your error right now
I have some queries in relation to the specifications of the project. Could we please have a word? My Skills: PHP, Database Administration, MySQL and Linux
Hi. Hope are doing fine. I have high level expertise in MYSQL. I can fix this issue right away. Will provide you top quality work for sure. I can start right now.