Error message when Mass Emailing a Forum user group [message #28643] |
Thu, 03 November 2005 11:40 |
|
Good evening.
I've just set up a new FUDForum-based message board and was testing the mass email function.
When I tried to send a mass email "test" message to the user group of one of the forums, I received the following error message (I've replaced the username with "xxxxxxxxxxx")
Quote: | (/home/xxxxxxxxxxxxxxxxx/public_html/include/theme/default/db.inc:78
/home/xxxxxxxxxxxxxxx/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 'SELECTemailFROM fud26_group_members gm INNER JOIN fud26_users u
Query: SELECTemailFROM 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' => 'bd4630e5ffea0e5094c1169dcabcd47f', 'SQ' => 'ee1ad96894b82e2b022b45816405ee0d', )
_POST: array ( 'S' => 'bd4630e5ffea0e5094c1169dcabcd47f', 'SQ' => 'ee1ad96894b82e2b022b45816405ee0d', 'group' => '4', 'subject' => 'Help need with Graphics', 'body' => 'The Polish CPL needs assistance with fixing up a logo for a campaign flyer. Can you help? ', 'btn_submit' => 'Send', )
Server Version: 4.1.10-standard
[Referring Page] http://www.valuableskills.org/adm/admmassemail.php?S=bd4630e5ffea0e5094c116 9dcabcd47f&SQ=ee1ad96894b82e2b022b45816405ee0d
|
I have had no trouble sending mass emails using my other "test site" with the FUDForum script. So I don't understand why this one should cause a problem.
In case it's relevant, my test forum uses an earlier version: FUDforum 2.7.2.
The problem site uses: 2.7.3.
Thank you for any assistance with 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
|
|
|
|
|
Re: Error message when Mass Emailing a Forum user group [message #28659 is a reply to message #28658] |
Thu, 03 November 2005 20:13 |
|
prodos wrote on Fri, 04 November 2005 06:42 |
Thanks.
Sorry to be such a dummy but I don't know what to do.
I see the following item at the above page:
Quote: |
install/www_root/adm/admmassemail.php 1.38 -> 1.39
|
So, that means I have to replace an existing section of the FUDForum script with this new script, right?
But how is this done?
|
Reporting some tiny progress ...
In my ACP, under "General Management" I found "File Manager".
Within this I found a table with an item called "adm".
Clicking on this I found another table which included an item called "admmassemail.php".
One of the options offered was "download". I clicked this and saved the file to my computer.
I then opened this file and, lo behold, I found the script. Examining this script I saw a section in it which resembled the file referred to above @ http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7422
I suppose the next thing to do is delete a portion of this and replace it with the script that fixes the problem. Yes? No? Maybe?
And then?
Thank you for any assistance, compassion, and mercy you would like to show this wretched and humble ignoramus
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
|
|
|
|
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
|
|
|
|
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
|
|
|
|
Re: Error message when Mass Emailing a Forum user group [message #28738 is a reply to message #28729] |
Tue, 08 November 2005 13:15 |
|
Ilia wrote on Tue, 08 November 2005 02:54 | Did you apply the new patch on top of the old one? The error implies a missing space, but the code in CVS has all the proper spaces.
|
I believe I did save the new patch over the old one. In fact I've done so over and over.
Here is what the line within my file manager looks like:
-rw-rw-rw-- (666) apache apache 6 KB Nov 08 08:02:17 admmassemail.php chmod download delete
See? The time is most recent. I've tried this over and over again and tested it many times.
Is it possible that there need to be yet more spaces in the CVS?
I see @
http://cvs.prohost.org/c/index.cgi/FUDforum/filediff?f=install/www_root/adm /admmassemail.php&v1=1.39&v2=1.40
... that this line:
$c = uq('SELECT'.$fld.' FROM '.$DBHOST_TBL_PREFIX. [etc.]
... has been replaced by this line:
$c = uq('SELECT '.$fld.' FROM '.$DBHOST_TBL_PREFIX. [etc.]
Maybe it should be:
$c = uq(' SELECT '.$fld.' FROM '.$DBHOST_TBL_PREFIX. [etc.] ?
No?
Question: Has anyone tested to see whether mass emailing the user group of a specific forum actually works correctly? (My apologies if this is a presumptuos thing for a non-techie to ask.)
I've spent several hours trying to work out whether I'm doing something wrong. But so far without any luck.
Any further help on this would be GREATLY appreciated.
Thank you for your attention.
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
|
|
|
|
|
|
|
|
|
Re: Error message when Mass Emailing a Forum user group [message #28845 is a reply to message #28834] |
Sat, 12 November 2005 19:16 |
Marticus
Messages: 272 Registered: June 2002
Karma: 1
|
Senior Member |
|
|
I know I got this to work once, but now receive the following error when trying to send mail with the PM box checked and with/without the ignore user override box checked.
) 1109: Unknown table 'fud26_users' in field list
Query: SELECT fud26_users.id FROM fud26_group_members gm INNER JOIN fud26_users u ON u.id=gm.user_id WHERE gm.group_id=18 AND (users_opt & 8)=0
This didn't make a lot of sense to me. Maybe it will to you.
|
|
|
Re: Error message when Mass Emailing a Forum user group [message #28848 is a reply to message #28845] |
Sat, 12 November 2005 21:24 |
|
Marticus wrote on Sun, 13 November 2005 06:16 | I know I got this to work once, but now receive the following error when trying to send mail with the PM box checked and with/without the ignore user override box checked.
Quote: |
) 1109: Unknown table 'fud26_users' in field list
Query: SELECT fud26_users.id FROM fud26_group_members gm INNER JOIN fud26_users u ON u.id=gm.user_id WHERE gm.group_id=18 AND (users_opt & 8)=0
|
This didn't make a lot of sense to me. Maybe it will to you.
|
Hmm ... I just tried mass emailing via PM and got this error message (username replaced with "xxxxxxx") ...
Quote: | Fatal error: Cannot instantiate non-existent class: fud_pmsg in /home/xxxxxxxx/public_html/include/theme/default/ssu.inc on line 22
|
Then I installed update 1.41 from
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7429
... and tried mass emailing via PM again. Now the error message is:
Quote: |
(/home/xxxxxxx/public_html/include/theme/default/db.inc:73
/home/xxxxxxx/public_html/include/theme/default/db.inc:177
/home/xxxxxxx/public_html/include/theme/default/private.inc:108
/home/xxxxxxx/public_html/include/theme/default/ssu.inc:30
/home/xxxxxxx/public_html/adm/admmassemail.php:61
) 1054: Unknown column 'Array' in 'field list'
Query: INSERT INTO fud26_pmsg ( to_list, ouser_id, ip_addr, host_name, post_stamp, icon, fldr, subject, attach_cnt, foff, length, duser_id, ref_msg_id, pmsg_opt ) VALUES ( NULL, 2, '0.0.0.0', NULL, 1131830178, NULL, 1, 'test', 0, 0, 4, Array, NULL, 48)
_GET: array ( 'S' => 'aad83d4b28c8ab3db4b275dff3e6b007', 'SQ' => '8325c7100a4665f01462eaa7d58e88fb', )
_POST: array ( 'S' => 'aad83d4b28c8ab3db4b275dff3e6b007', 'SQ' => '8325c7100a4665f01462eaa7d58e88fb', 'pm' => '1', 'group' => '0', 'subject' => 'test', 'body' => 'test', 'btn_submit' => 'Send', )
Server Version: 4.1.10-standard
[Referring Page] http://the1776.org/adm/admmassemail.php?S=aad83d4b28c8ab3db4b275dff3e6b007& amp;SQ=8325c7100a4665f01462eaa7d58e88fb
|
Any thoughts on this? 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
|
|
|
|
|
|
Re: Error message when Mass Emailing a Forum user group [message #28865 is a reply to message #28864] |
Mon, 14 November 2005 05:19 |
|
Ilia wrote on Mon, 14 November 2005 15:00 | You can save that page.
|
I see.
Okay, I saved it as a text file.
Then I opened it in TextPad and saved it as "ssu.inc.t"
Then went to the File Adminstration System, clicked on the "src" folder, browsed for "ssu.inc.t", then clicked on "Upload File". I believe this uploaded the file into the correct spot.
I then tried to mass email by PM and got this error message (username replaced with "xxxxxxxx")
Quote: |
(/home/xxxxxx/public_html/include/theme/default/db.inc:73
/home/xxxxxxx/public_html/include/theme/default/db.inc:177
/home/xxxxxx/public_html/include/theme/default/private.inc:108
/home/xxxxxx/public_html/include/theme/default/ssu.inc:30
/home/xxxxxx/public_html/adm/admmassemail.php:62
) 1054: Unknown column 'Array' in 'field list'
Query: INSERT INTO fud26_pmsg ( to_list, ouser_id, ip_addr, host_name, post_stamp, icon, fldr, subject, attach_cnt, foff, length, duser_id, ref_msg_id, pmsg_opt ) VALUES ( NULL, 2, '0.0.0.0', NULL, 1131945103, NULL, 1, 'test', 0, 20, 4, Array, NULL, 48)
_GET: array ( 'S' => 'aad83d4b28c8ab3db4b275dff3e6b007', 'SQ' => '9210bb6603fa3520a5f434696c094813', )
_POST: array ( 'S' => 'aad83d4b28c8ab3db4b275dff3e6b007', 'SQ' => '9210bb6603fa3520a5f434696c094813', 'pm' => '1', 'group' => '0', 'subject' => 'test', 'body' => 'test', 'btn_submit' => 'Send', )
Server Version: 4.1.10-standard
[Referring Page] http://the1776.org/adm/admmassemail.php?S=aad83d4b28c8ab3db4b275dff3e6b007& amp;SQ=9210bb6603fa3520a5f434696c094813
|
What have I done wrong this time?
Thank you for any advice or assistance.
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
|
|
|
|
|
Re: Error message when Mass Emailing a Forum user group [message #30536 is a reply to message #28869] |
Wed, 01 March 2006 20:15 |
Everfree
Messages: 36 Registered: December 2005 Location: Los Angeles, CA
Karma: 0
|
Member |
|
|
I have followed the above tips, which worked on a test site but on my real forum, i am using another theme and default is disabled.
When sending via pm:
(/usr/local/4admin/apache/vhosts/dxstrategies.com/httpdocs/forums/include/t heme/default/db.inc:73
/usr/local/4admin/apache/vhosts/dxstrategies.com/httpdocs/forums/include/th eme/default/db.inc:177
/usr/local/4admin/apache/vhosts/dxstrategies.com/httpdocs/forums/include/th eme/default/private.inc:108
/usr/local/4admin/apache/vhosts/dxstrategies.com/httpdocs/forums/include/th eme/default/ssu.inc:30
/usr/local/4admin/apache/vhosts/dxstrategies.com/httpdocs/forums/adm/admmas semail.php:62
) 1054: Unknown column 'Array' in 'field list'
Query: INSERT INTO fud26_pmsg ( to_list, ouser_id, ip_addr, host_name, post_stamp, icon, fldr, subject, attach_cnt, foff, length, duser_id, ref_msg_id, pmsg_opt ) VALUES ( NULL, 3, '0.0.0.0', NULL, 1141242785, NULL, 1, 'from admin', 0, 6632, 97, Array, NULL, 48)
_GET: array ( 'rid' => '3', 'S' => '24585035d3947094e77cbd93fddd37e1', 'SQ' => 'c261df15f33862738d72d6f1d39159d4', )
_POST: array ( 'S' => '24585035d3947094e77cbd93fddd37e1', 'SQ' => 'c261df15f33862738d72d6f1d39159d4', 'pm' => '1', 'group' => '35', 'subject' => 'from admin', 'body' => 'to admin testing group from /forums/ admin ignore user override send via pm', 'btn_submit' => 'Send', )
Server Version: 5.0.18-Debian_1
[Referring Page] http://www.dxstrategies.com/forums/adm/admmassemail.php?rid=3&S=2458503 5d3947094e77cbd93fddd37e1&SQ=c261df15f33862738d72d6f1d39159d4
Now what should i do... spelled out please, i'm not very programming smart.
Thanks for all the help so far.
|
|
|
|