FUDforum: Bug Reports » Error message when Mass Emailing a Forum user group

Home » FUDforum Development » Bug Reports » Error message when Mass Emailing a Forum user group

Show: Today's Messages :: Polls :: Message Navigator

Error message when Mass Emailing a Forum user group [message #28643]

Thu, 03 November 2005 11:40

prodos

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

Member

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

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28648 is a reply to message #28643]

Thu, 03 November 2005 15:10

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Fixed in CVS, here is the patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7422

FUDforum Core Developer

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28658 is a reply to message #28648]

Thu, 03 November 2005 19:42

prodos

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

Member

Ilia wrote on Fri, 04 November 2005 02:10

Fixed in CVS, here is the patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7422

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?

In my WS_FTP I found a folder called "adm". I transfered it to my computer, but when I look inside it with TextPad I can't see anything inside it.

Or is this "fix" supposed to be applied via the ACP of my message board? If so, could you please tell me where?

Question: If I re-install version 2.7.3 will this fix be included?

Thank you for any assistance. Apologies for my ignorance.

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

Report message to a moderator

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

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

Member

prodos wrote on Fri, 04 November 2005 06:42

Ilia wrote on Fri, 04 November 2005 02:10

Fixed in CVS, here is the patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7422

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? Shocked

Shocked

Thank you for any assistance, compassion, and mercy you would like to show this wretched and humble ignoramus Rolling Eyes

Rolling Eyes

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

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28660 is a reply to message #28659]

Thu, 03 November 2005 23:17

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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.

FUDforum Core Developer

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28689 is a reply to message #28660]

Sat, 05 November 2005 18:30

prodos

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

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

Re: Error message when Mass Emailing a Forum user group [message #28690 is a reply to message #28689]

Sat, 05 November 2005 18:51

Marticus

Messages: 272
Registered: June 2002

Karma: 1

Senior Member

Thanks for the fix. Spaces are also required after the keyword SELECT.

[Updated on: Sat, 05 November 2005 18:54]

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

prodos

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

Member

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 #28729 is a reply to message #28703]

Mon, 07 November 2005 15:54

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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.

FUDforum Core Developer

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

prodos

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

Member

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

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28759 is a reply to message #28738]

Thu, 10 November 2005 00:36

Marticus

Messages: 272
Registered: June 2002

Karma: 1

Senior Member

I did not apply the most recent patch. I modified the file when I noticed the other spaces were missing and it works fine for group mailings.

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28762 is a reply to message #28759]

Thu, 10 November 2005 05:06

prodos

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

Member

Marticus wrote on Thu, 10 November 2005 11:36

I did not apply the most recent patch. I modified the file when I noticed the other spaces were missing and it works fine for group mailings.

Good afternoon.

I'm not sure what to do, unfortunately: What is the problem or what is the solution.

I don't know what modification to apply to the existing or previous patch or whether it is wise for me to even try to do so since this is not something I'm familiar with and I don't want to make the problem even worse.

Is the the modification at:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7426
... faulty? Can you tell from looking at that page?

Thank you for any assistance with this matter.

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

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28797 is a reply to message #28762]

Fri, 11 November 2005 14:57

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Download the full file from:
http://cvs.prohost.org/c/index.cgi/FUDforum/getfile/install/www_root/adm/ad mmassemail.php?v=1.40
and replace your copy with it.

FUDforum Core Developer

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28829 is a reply to message #28797]

Sat, 12 November 2005 05:15

prodos

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

Member

Ilia wrote on Sat, 12 November 2005 01:57

Download the full file from:
http://cvs.prohost.org/c/index.cgi/FUDforum/getfile/install/www_root/adm/ad mmassemail.php?v=1.40
and replace your copy with it.

Thanks. I have done this.
But unfortunately I still get what looks like the same error message.

I'm really stumped about this one. I can't see what I'm doing wrong.

I have even compared - line by line - the new file with the existing one (which was the one I downloaded from http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7426

They look identical to me. Yet I continue to get the error message. Confused

Confused

Any further thoughts on this?

Thank you for your help. I'm sorry for the hassle.

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

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28832 is a reply to message #28829]

Sat, 12 November 2005 05:34

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

I've tested it and it works on my test system, not sure why yours reports the error.

FUDforum Core Developer

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28834 is a reply to message #28832]

Sat, 12 November 2005 09:43

prodos

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

Member

Ilia wrote on Sat, 12 November 2005 16:34

I've tested it and it works on my test system, not sure why yours reports the error.

Ahhhhh!!!

Shocked

Shocked

Shocked

I just worked out what I've been doing wrong!

I was saving the "admmassemail.php" file to the wrong place!

It's supposed to go within the "adm" folder!

Everything works great now.

http://www.iloveprodos.com/animatedclipart/little_blue_fishy_swimming_sm_nwm.gif

Thanks for your help.

Thanks also to Marticus for his help via PM.

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

Report message to a moderator

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.

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28848 is a reply to message #28845]

Sat, 12 November 2005 21:24

prodos

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

Member

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

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28851 is a reply to message #28848]

Sun, 13 November 2005 16:14

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Fixed in CVS.
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7430

FUDforum Core Developer

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28862 is a reply to message #28851]

Sun, 13 November 2005 23:46

prodos

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

Member

Ilia wrote on Mon, 14 November 2005 03:14

Fixed in CVS.
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7430

Thanks.

At the above URL there are two items listed:

install/forum_data/src/ssu.inc.t ... 1.18->1.19
install/www_root/adm/admmassemail.php ... 1.41->1.42

I presume that means both have to be updated, right?

I had no problem with downloading the 1.42 file to my computer and then uploading this into the message board via the File Adminstration System.

But when I click the "1.19" at http://cvs.prohost.org/c/index.cgi/FUDforum/rlog?f=install/forum_data/src/s su.inc.t
... it doesn't offer me a file I can save to my computer.

Instead, it takes me to a page:

http://cvs.prohost.org/c/index.cgi/FUDforum/getfile/install/forum_data/src/ ssu.inc.t?v=1.19

... which seems to have the corrected code on it.

I'm unclear about what I should do next. Could someone please advise?

Thank you for your 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

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28864 is a reply to message #28862]

Mon, 14 November 2005 04:00

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You can save that page.

FUDforum Core Developer

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28865 is a reply to message #28864]

Mon, 14 November 2005 05:19

prodos

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

Member

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

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28868 is a reply to message #28865]

Mon, 14 November 2005 13:54

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Did you rebuild the theme?

FUDforum Core Developer

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #28869 is a reply to message #28868]

Mon, 14 November 2005 14:03

prodos

Messages: 58
Registered: August 2005
Location: Melbourne, Australia

Karma: 0

Member

Ilia wrote on Tue, 15 November 2005 00:54

Did you rebuild the theme?

So that's it!

I just did so by going to Template Manager >> Theme Manager >> Theme Management [ Rebuild all Themes ]

... and clicking on "Rebuild all Themes".

It's all working now!

Thanks very much. I appreciate your help. Smile

Smile

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

Report message to a moderator

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.

Report message to a moderator

Re: Error message when Mass Emailing a Forum user group [message #30544 is a reply to message #30536]

Thu, 02 March 2006 14:05

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

This is something that is fixed in CVS, you can grab the latest copy of the script from there and update your forum with it. Search the archives for instructions.

FUDforum Core Developer

Report message to a moderator

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) ] [

]

Current Time: Fri Nov 08 22:38:29 GMT 2024

Total time taken to generate the page: 0.03453 seconds