Previous Thread
Next Thread
Print Thread
Hop To
Joined: Oct 2006
Posts: 51
Likes: 1
M
Journeyman
Journeyman
M Offline
Joined: Oct 2006
Posts: 51
Likes: 1
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:
Quote
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

Last edited by Rick; 11/16/2006 11:29 AM.
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Fix is spread out over a couple of scripts, so I can't post the fix, but fixed for 7.0.2.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Add a post to additional forums
by Larry Miller - 01/27/2023 2:58 PM
What happens to modified templates during the upgrade
by Michael_E6D9 - 01/13/2023 2:11 AM
Attachments broken after server migration
by jgeoff - 12/22/2022 3:33 PM
Post Moderation Issue
by FREAK - 11/24/2022 1:07 PM
Users cannot register
by - 07/04/2022 8:42 PM
Who's Online Now
3 members (Larry Miller, Ruben, 1 invisible), 209 guests, and 136 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221228)