MyBB Community Forums

Full Version: SQL Error: 1055
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
i go to http://mysite/admin/index.php?module=config

i take this error : 

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1055 - 'mybb595959.g.name' isn't in GROUP BYQuery:SELECT g.*, COUNT(s.sid) AS settingcount FROM mybb_settinggroups g LEFT JOIN mybb_settings s ON (s.gid=g.gid) WHERE g.isdefault = 1 GROUP BY g.gid ORDER BY g.disporder

php version : 7.1.0
mysql version : 5.6.32

i solved.i deleted this line 

sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY 

at my mysql conf file.

thanks.