MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
- SQL Error:
- 1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'KL1316201.p.view' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
- Query:
-
SELECT
c.ID_CAT, c.title, p.view, c.roworder, c.description, c.image, c.filename,
c.redirect, c.total, l.ID_PICTURE, l.title pictitle, l.date,
m.uid, m.username, mg.namestyle
FROM mybb_gallery_cat AS c
LEFT JOIN mybb_gallery_catperm AS p ON (p.ID_GROUP = 1 AND c.ID_CAT = p.ID_CAT)
LEFT JOIN mybb_gallery_pic AS l ON (c.LAST_ID_PICTURE = l.ID_PICTURE)
LEFT JOIN mybb_users AS m ON (m.uid = l.ID_MEMBER)
LEFT JOIN mybb_usergroups AS mg ON (m.usergroup = mg.gid)
WHERE c.ID_PARENT = 0 GROUP BY c.ID_CAT ORDER BY c.roworder ASC