Getting the following error on a live site:
JDatabaseMySQLi::query: 1054 - Unknown column 'c.cb_birthday' in 'field list' SQL=SELECT DISTINCT u.id, u.username, u.name, s.userid as s4jonline , DATE_FORMAT(c.cb_birthday, '%Y-%m-%d %T') AS s4jbirthday, (YEAR(CURDATE()) - YEAR(c.cb_birthday)) -(RIGHT(CURDATE(),5) < RIGHT(c.cb_birthday,5)) AS s4jage, c.lastupdatedate FROM ( rpji9_users u INNER JOIN rpji9_comprofiler c ON u.id = c.user_id AND u.block =0 AND c.confirmed =1 AND c.approved =1 ) LEFT JOIN rpji9_session s ON s.userid = u.id AND s.guest = 0 WHERE u.registerDate >= '2012-09-13' AND u.id NOT IN (0) ORDER BY u.registerDate DESC LIMIT 0, 6
Can anyone assist?!
krileon
