 Re: Error message when Mass Emailing a Forum user group [message #28703 is a reply to message #28690] |
Sun, 06 November 2005 00:28   |
|
|
| Marticus wrote on Sun, 06 November 2005 05:51 |
Thanks for the fix. Spaces are also required after the keyword SELECT.
|
I see that a new patch is now available at:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7426
[ ... time passes ... ]
I have installed this new patch, but the mass email function is still having problems.
Test 1
I send a message to "All Forum Members" without ticking "Ignore User Override"
The message goes through okay.
Test 2
I send a message to "All Forum Members" ticking "Ignore User Override"
Again, okay.
Test 3
I try sending a mass email to one of the forum user groups which has 3 members. The "Ignore User Override" box is not checked.
I get this error message:
| Quote: |
(/home/xxxxxxxxxxxx/public_html/include/theme/default/db.inc:78
/home/xxxxxxxxxxxx/public_html/adm/admmassemail.php:44
) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECTemail FROM fud26_group_members gm INNER JOIN fud26_users u
Query: SELECTemail FROM fud26_group_members gm INNER JOIN fud26_users u ON u.id=gm.user_id WHERE gm.group_id=4 AND (users_opt & 8)=0
_GET: array ( 'S' => '7a999dd8839a1486b524219bd3de052e', 'SQ' => '17c03e61530f0c01f834030cd54f44e9', )
_POST: array ( 'S' => '7a999dd8839a1486b524219bd3de052e', 'SQ' => '17c03e61530f0c01f834030cd54f44e9', 'group' => '4', 'subject' => 'test', 'body' => 'test', 'btn_submit' => 'Send', )
Server Version: 4.1.10-standard
[Referring Page] http://www.valuableskills.org/adm/admmassemail.php?S=7a999dd8839a1486b52421 9bd3de052e&SQ=17c03e61530f0c01f834030cd54f44e9
|
Test 4
I try sending a mass email to one of the forum user groups which has 3 members. The "Ignore User Override" box is checked this time.
This is the error message I get
| Quote: |
(/home/xxxxxxxxxxx/public_html/include/theme/default/db.inc:78
/home/xxxxxxxxxx/public_html/adm/admmassemail.php:44
) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECTemail FROM fud26_group_members gm INNER JOIN fud26_users u
Query: SELECTemail FROM fud26_group_members gm INNER JOIN fud26_users u ON u.id=gm.user_id WHERE gm.group_id=4
_GET: array ( 'S' => '7a999dd8839a1486b524219bd3de052e', 'SQ' => '17c03e61530f0c01f834030cd54f44e9', )
_POST: array ( 'S' => '7a999dd8839a1486b524219bd3de052e', 'SQ' => '17c03e61530f0c01f834030cd54f44e9', 'group' => '4', 'subject' => 'test', 'body' => 'test', 'ignore_override' => '1', 'btn_submit' => 'Send', )
Server Version: 4.1.10-standard
[Referring Page] http://www.valuableskills.org/adm/admmassemail.php?S=7a999dd8839a1486b52421 9bd3de052e&SQ=17c03e61530f0c01f834030cd54f44e9
|
Thank you for your attention to this issue.
CelebrateCapitalism.ORG
"Why? Because I own my life!"
* * * * * * * * * * * * * * * * *
phpBB? Invision Power Board? vBulletin?
Yes, all excellent. But The FUD is my favorite! Try it now @ http://FUDForum.org
[Updated on: Sun, 06 November 2005 01:28] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]