Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [Error Message] MyBB SQL Error
#1
Not Solved Information 
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?
Reply
#2
Not Solved
What version of MySQL do you have?
[Image: ZbrcFs]
Reply
#3
Not Solved
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.
Reply
#4
Not Solved
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?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)