MyBB Community Forums

Forum Link: greyhatclub.me

Error:

Quote:MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1055 - 'cbasimc_mybb.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
Please contact the MyBB Group for technical support.

this error shows when i click on Configration->change settings

rest all settings works fine for me any way to fix it?

What version of MySQL do you have?

Technically the error is right; the group by clause only mentions gid (group id). You should add g.name to the group by clause to be compliant. This shouldn't be an issue because each gid only has a single name.

using latest version


You should add g.name to the group by clause to be compliant. This shouldn't be an issue because each gid only has a single name.

how?