Solved: 4 Years, 2 Months, 3 Weeks ago SQL Error: 1055
#1
Solved: 4 Years, 2 Months, 3 Weeks ago
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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)