Re: Error message when Mass Emailing a Forum user group [message #28689 is a reply to message #28660] |
Sat, 05 November 2005 18:30 |
|
Ilia wrote on Fri, 04 November 2005 10:17 | The web cvs allows you to download a complete copy of the file, so just do that and replace your file with the new one.
|
I went to:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7422
I clicked on:
install/www_root/adm/admmassemail.php
I then went to the line that read as:
2005-Nov-03 10:10 1.39 Check-in [7422]: Fixed typo in the query (missing space). By hackie. (diff)
I clicked on the "1.39"
This offered me a file called "admmassemail.php"
I saved this file to my computer.
I then went to the Admin Control Panel of my site >> File Manager.
I clicked on the "browse" button and found the newly saved file on my computer. I clicked on it.
Within the field called:
File Name:
(leave blank if want the uploaded filename to remain unchanged)
I entered "admmassemail.php" (without the quotes)
Then I clicked the "Upload File" button.
After the uploading finished I went back to the mass email page and again tried sending a test message.
Here is the error message I received (with the username replaced with "xxxxxxxxx" )
Quote: | (/home/xxxxxxxxxx/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 AND (users_opt & 8)=0
_GET: array ( 'S' => '7a999dd8839a1486b524219bd3de052e', 'SQ' => 'b6e8fcbd04b5626250c686b160dfb8d9', )
_POST: array ( 'S' => '7a999dd8839a1486b524219bd3de052e', 'SQ' => 'b6e8fcbd04b5626250c686b160dfb8d9', '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=b6e8fcbd04b5626250c686b160dfb8d9
|
Have I done something wrong? Or is there still some sort of error in the update?
Your advice would be greatly appreciated. Thanks.
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: Sat, 05 November 2005 18:32] Report message to a moderator
|
|
|