Jump to content
Search In
  • More options...
Find results that contain...
Find results in...

User Groups page is dead.


XerShade
 Share

Recommended Posts

Page: https://eclipseorigins.com/usercp.php?action=usergroups

MyBB has experienced an internal SQL error and cannot continue.

**SQL Error:**
```
1055 - Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'eclipse.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='44597' GROUP BY l.gid
```
Please contact the MyBB Group for technical support.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...