I initially posted this in the General Assistance forum but didn't receive any solutions, so I'm wondering if this might be a bug. I am using UBB.threads 7.0.1. When trying to create an email list based on members that belong to a specific group, I receive an error. Here are the steps that I followed that resulted in the error message:
I went to
Control Panel >>
Membership >>
Member Management and opened the
Advanced Search Options. I clicked one of the boxes in
Member Group, then clicked "Submit".
The
Search Results gave all of the members that I expected to see. Under
All Members or Selected Members? I selected "All Members in Search", and under
Action I selected "Email".
Under
Available Email Options: I selected
Export List of Addresses, then clicked "Generate Emails". Under
Address Export Options: I selected
Show List in Browser Window, and under
Output Format: I chose
One Address per Line, then clicked on "Create Email List".
I received the following message:
SELECT t2.USER_REAL_EMAIL FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3 WHERE t1.USER_ID <> '1' AND t1.USER_ID = t2.USER_ID AND t1.USER_ID = t3.USER_ID AND t2.USER_ACCEPT_ADMIN_EMAILS <> 'Off' and t4.GROUP_ID IN (6)GROUP BY t1.USER_ID ORDER BY t1.USER_ID ASC
Unknown table 't4' in where clause
