it seem have a little question
SecurityCommon -> loadRoles() ->
/*
sql = SELECT r.role_id, r.name, rv.role_value, rv.role_type AS rv_type, r.role_type \
FROM jforum_roles r, jforum_role_values rv \
WHERE rv.role_id(+) = r.role_id AND r.group_id = ? \
ORDER BY r.role_id
*/
p = JForumExecutionContext.getConnection().prepareStatement(sql);
Role r = null;
String lastName = null;
rs = p.executeQuery(); // there is err !
while (rs.next()) {
...
}
before here : rs = p.executeQuery(); not set r.group_id !!!
when i debug here show err !!
[originally posted on jforum.net by jyhcyd]
