This is a control panel message error produced after sorting by LAST ONLINE in my control panel (Member Management).
Probably another data base field missing.


Control panel message
select COUNT(t1.USER_ID) from advp_USERS as t1, advp_USER_PROFILE as t2, advp_USER_DATA as t3, advp_USER_GROUPS as t4 WHERE t1.USER_ID <> '1' and t1.USER_ID = t2.USER_ID and t1.USER_ID = t3.USER_ID and t1.USER_ID = t4.USER_ID ORDER BY t1.USER_LAST_ON ASC

Unknown column 't1.USER_LAST_ON' in 'order clause'


Last edited by Rick; 09/19/2006 2:52 PM.