2016-12-13, 08:08 PM
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.
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.