I've just tried to send a mail message through UBB.7 to my members, I'm greeted with:

select t2.USER_REAL_EMAIL from forums_USERS as t1, forums_USER_PROFILE as t2, forums_USER_DATA as t3 where t1.USER_ID <> '1' and t1.USER_ID = t2.USER_ID and t1.USER_ID = t3.USER_ID and t1.USER_IS_BANNED = '0' and t4.GROUP_ID IN (3) and t4.GROUP_ID IN (3) and t4.GROUP_ID IN (3) and t4.GROUP_ID IN (3) and t4.GROUP_ID IN (3) and t4.GROUP_ID IN (3) and t4.GROUP_ID IN (3) and t4.GROUP_ID IN (3) and t4.GROUP_ID IN (3) and t4.GROUP_ID IN (3) and t4.GROUP_ID IN (3)GROUP BY t1.USER_ID ORDER BY t1.USER_ID ASC

Unknown table 't4' in where clause

Last edited by Rick; 10/09/2006 10:52 AM.
I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!