0

I am getting the following error in PHPMyAdmin when I attempt to do click "Databases" tab:

#1055 - 'information_schema.s.SCHEMA_NAME' isn't in GROUP BY

Please advise on what code in phpmyadmin file needs to be updated to fix this query and how to re-write it... Seems to be a bug in PHPMyAdmin, but I don't wanna wait around until they fix in a "later" release.

Mihai Iorga
  • 39,330
  • 16
  • 106
  • 107
SM-admin
  • 1
  • 2
  • I found this with a quick search in google, this might solve your issue. http://mgelbana.wordpress.com/2012/08/01/mysql-error-code-1055-yourschema-yourtable-yourcolumn-isnt-in-group-by-error/ – Harry Jul 08 '14 at 08:39
  • in MySQL 5.7 sql mode is set by default to ONLY_FULL_GROUP_BY – madeuz Feb 25 '15 at 11:26
  • Possible duplicate of [MySQL : isn't in GROUP BY](http://stackoverflow.com/questions/25800411/mysql-isnt-in-group-by) – Jocelyn Jul 03 '16 at 22:04

0 Answers0