DB function failed with error number 1054
Unknown column 'd.id' in 'on clause' SQL=SELECT a.*, a.name AS groupname, DATE_FORMAT(date_s, '%Y-%m-%d %H:%i:%s') AS date_s, b.catname, b.id AS catid, c.category_id, d.name, e.category_id AS category_id_el FROM jos_gj_groups as a INNER JOIN jos_gj_grcategory AS b ON a.category = b.id INNER JOIN jos_users as d ON a.user_id = d.id LEFT JOIN jos_gj_jb as c ON a.id = c.group_id LEFT JOIN jos_gj_eventlist as e ON a.id = e.group_id WHERE a.id='10' AND a.active='1' AND b.access <=0
Unknown column 'd.id' in 'on clause' SQL=SELECT a.*, a.name AS groupname, DATE_FORMAT(date_s, '%Y-%m-%d %H:%i:%s') AS date_s, b.catname, b.id AS catid, c.category_id, d.name, e.category_id AS category_id_el FROM jos_gj_groups as a INNER JOIN jos_gj_grcategory AS b ON a.category = b.id INNER JOIN jos_users as d ON a.user_id = d.id LEFT JOIN jos_gj_jb as c ON a.id = c.group_id LEFT JOIN jos_gj_eventlist as e ON a.id = e.group_id WHERE a.id='10' AND a.active='1' AND b.access <=0
My Group
My Groups
| You are not a member of any group. |
