Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › count AS with group by causing error locally

count AS with group by causing error locally

Thread began 3/02/2023 4:39 am by s.joiner74419001 | Last modified 8/23/2023 4:39 am by s.joiner74419001 | 2446 views | 8 replies

8/23/2023 4:39 ams.joiner74419001

Just to update this feed as I have managed to resolve the issue using ChatGPT ,Bard and Stack overflow.

I had to adjust the my.cnf file located here:

TOP MENU - file/open template/MySQL(my.cnf)/5.7.39

The in the file add the line - sql_mode="" .. to the [mysqld] section as follows

# The MySQL server
[mysqld]
sql_mode=""
user = MAMP_system_user_MAMP
#port = 9999
socket = /Applications/MAMP/tmp/mysql/mysql.sock

My SQL Query in #1 post above now works!

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.