FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Error message when Mass Emailing a Forum user group
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
icon5.gif  Re: Error message when Mass Emailing a Forum user group [message #28689 is a reply to message #28660] Sat, 05 November 2005 18:30 Go to previous messageGo to previous message
prodos is currently offline  prodos   Australia
Messages: 58
Registered: August 2005
Location: Melbourne, Australia
Karma:
Member

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

[Message index]
 
Read Message icon5.gif
Read Message
Read Message icon5.gif
Read Message
Read Message
Read Message icon5.gif
Read Message
Read Message icon5.gif
Read Message
Read Message
Read Message
Read Message icon5.gif
Read Message
Read Message icon5.gif
Read Message
Read Message
Read Message
Read Message icon5.gif
Read Message
Read Message icon5.gif
Read Message
Read Message icon5.gif
Read Message
Read Message
Read Message
Read Message
Previous Topic: Text insertion browser bug
Next Topic: COPPA text in registration form doesn't have link to underage form
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 12:12:31 GMT 2024

Total time taken to generate the page: 0.05627 seconds