|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
At what point did it give you the error, after filling out the email you wanted to send and submitting or somewhere before that?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, I think I found it. Line 155 of admin/dosendemail.php has a query that looks like this:
select t2.USER_REAL_EMAIL
from {$config['TABLE_PREFIX']}USERS as t1,
{$config['TABLE_PREFIX']}USER_PROFILE as t2,
{$config['TABLE_PREFIX']}USER_DATA as t3
where t1.USER_ID <> '1'
and t1.USER_ID = t2.USER_ID
and t1.USER_ID = t3.USER_ID
$removed $sterms
That needs to be:
select t2.USER_REAL_EMAIL
from {$config['TABLE_PREFIX']}USERS as t1,
{$config['TABLE_PREFIX']}USER_PROFILE as t2,
{$config['TABLE_PREFIX']}USER_DATA as t3,
{$config['TABLE_PREFIX']}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
$removed $sterms
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
At what point did it give you the error, after filling out the email you wanted to send and submitting or somewhere before that? After writing the lengthy sob and clicking send i got it lol... I'll apply your fix and fiddle in a bit...
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Rick,
Do we still need to redo the code on that file you provided?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Yes, any bug fixes that have been posted will need to be made. At some point we'll release a 7.0.1 that will contain all of the bug fixes, but until then you'll want to make the changes.
I'm posting them when possible so people don't have to wait until the 7.0.1 release.
Last edited by Rick; 10/08/2006 6:30 PM.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
0 members (),
764
guests, and
261
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|