Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 3 Years, 7 Months, 3 Weeks ago [Error Message] SQL Error: 1055 - Expression #6 of SELECT list is not in GROUP BY clause
#1
Solved: 3 Years, 7 Months, 3 Weeks ago
I get this error on a new 1.8.6. installation on the /usercp.php?action=usergroups page for every user (Administratior and registered user).
No custom user groups are created.


SQL Error:
    1055 - Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mybb.l.canmanagerequests' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query:
    SELECT g.title, g.gid, g.type, COUNT(DISTINCT u.uid) AS users, COUNT(DISTINCT j.rid) AS joinrequests, l.canmanagerequests, l.canmanagemembers, l.caninvitemembers FROM mybb_groupleaders l LEFT JOIN mybb_usergroups g ON(g.gid=l.gid) LEFT JOIN mybb_users u ON(((CONCAT(',', u.additionalgroups, ',') LIKE CONCAT('%,', g.gid, ',%')) OR u.usergroup = g.gid)) LEFT JOIN mybb_joinrequests j ON(j.gid=g.gid AND j.uid != 0) WHERE l.uid='1' GROUP BY l.gid 

PHP: 5.6.18
MySQL: 5.7.10


Attached Files Thumbnail(s)
   
Reply
#2
Solved: 3 Years, 7 Months, 3 Weeks ago
Already fixed on GitHub, will be shipped with MyBB 1.8.7: https://github.com/mybb/mybb/issues/2306. You can apply these changes to make it work now: https://github.com/Stefan-ST/mybb/commit...2433afe959
devilshakerz.com/pgp (DF3A 34D9 A627 42E5 BC6A 6750 1F2F B8AA 28FF E1BC) ▪ keybase.io/devilshakerz
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)