I imported my forum from classic 7.2. When I go into the group editor I see the correct number of people in the group. But when I click on the number I receive the following message:
Control panel message
select COUNT(t1.USER_ID) from ubbt_USERS as t1, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3, ubbt_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 and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5)GROUP BY t1.USER_ID ORDER BY t2.USER_DISPLAY_NAME ASC
Unknown column 't2.USER_DISPLAY_NAME' in 'order clause'
Last edited by Rick; 10/12/2006 1:21 PM.