al momento de entrar al Admin CP, cuando voy a Users and Group... y voy a Admin Permissions y me sale esto:
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
alguna solucion?
Busca en private.php
$query = $db->query("SELECT u.uid, u.username, u.email, u.usergroup, u.pmnotify, u.pmpopup, u.receivepms, u.ignorelist, u.lastactive, u.language, COUNT(pms.pmid) AS pms_total, g.canusepms, g.pmquota, g.cancp FROM ".TABLE_PREFIX."users u, ".TABLE_PREFIX."usergroups g LEFT JOIN ".TABLE_PREFIX."privatemessages pms ON (pms.uid=u.uid) WHERE u.username='".addslashes($mybb->input['to'])."' AND g.gid=u.usergroup GROUP BY u.uid");
y reemplazalo por...
$query = $db->query("SELECT u.uid, u.username, u.email, u.usergroup, u.pmnotify, u.pmpopup, u.receivepms, u.ignorelist, u.lastactive, u.language, COUNT(pms.pmid) AS pms_total, g.canusepms, g.pmquota, g.cancp FROM (".TABLE_PREFIX."users u, ".TABLE_PREFIX."usergroups g) LEFT JOIN ".TABLE_PREFIX."privatemessages pms ON (pms.uid=u.uid) WHERE u.username='".addslashes($mybb->input['to'])."' AND g.gid=u.usergroup GROUP BY u.uid");
eso me paso en los foros y asi se arreglo...
bueno, ia hice eso, el mensaje me sigue saliendo, pero ahora ia me da opcion de:
Administrator Permissions [edit default permissions]
es normal?