i get this when i go to User and Groups > Admin Permission
mySQL error: 1054
Unknown column 'u.uid' in 'on clause'
Query: SELECT u.uid, u.username, u.lastactive, g.cancp, a.permsset FROM mybb_users u, mybb_usergroups g LEFT JOIN mybb_adminoptions a ON (a.uid=u.uid) WHERE u.usergroup=g.gid AND g.cancp='yes' ORDER BY u.username ASC
To fix it open
admin/adminoptions.php
find
$query = $db->query("SELECT u.uid, u.username, u.lastactive, g.cancp, a.permsset FROM ".TABLE_PREFIX."users u, ".TABLE_PREFIX."usergroups g LEFT JOIN ".TABLE_PREFIX."adminoptions a ON (a.uid=u.uid) WHERE u.usergroup=g.gid AND g.cancp='yes' ORDER BY u.username ASC");
replace with
$query = $db->query("SELECT u.uid, u.username, u.lastactive, g.cancp, a.permsset FROM (".TABLE_PREFIX."users u, ".TABLE_PREFIX."usergroups g) LEFT JOIN ".TABLE_PREFIX."adminoptions a ON (a.uid=u.uid) WHERE u.usergroup=g.gid AND g.cancp='yes' ORDER BY u.username ASC");
and it's already fixed in 1.2
regards
This bug is already fixed in MyBB 1.1.
