FUDforum: Bug Reports » Error : Invalid group id when Mass Emailing

Home » FUDforum Development » Bug Reports » Error : Invalid group id when Mass Emailing

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

Error : Invalid group id when Mass Emailing [message #29688]

Mon, 09 January 2006 20:17

blemish

Messages: 13
Registered: October 2005
Location: France

Karma: 0

Junior Member

Hello,

Have this error when Mass Email group "All Forum Moderators"

Groups select :

<select name="group"><option value="0">All Forum Members</option><option value="-1000000000">All Forum Moderators</option><option value="-1000000001">All Group Leaders</option>...</select>

Output :

Invalid group id
(/home/k1002/.fud_data/include/theme/default/db.inc:78
/home/k1002/.fud_data/include/theme/default/private.inc:112
/home/k1002/.fud_data/include/theme/default/ssu.inc:30
/home/k1002/html/forums/adm/admmassemail.php:62
) 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 ') AND users_opt>=64 AND (users_opt & 64) > 0' at line 1
Query: SELECT id, email FROM fud26_users WHERE id IN() AND users_opt>=64 AND (users_opt & 64) > 0
_GET: array ( 'SQ' => 'f07115e226ff6d6dda714332827710b7', )
_POST: array ( 'SQ' => 'f07115e226ff6d6dda714332827710b7', 'pm' => '1', 'group' => '-1000000000', 'subject' => 'Test', 'body' => 'Test', 'ignore_override' => '1', 'btn_submit' => 'Send', )
Server Version: 4.1.11-Debian
[Referring Page] http://www.site.com/forums/adm/admmassemail.php?&SQ=f07115e226ff6d6dda714332827710b7

Have :
ssu.inc.t 2005/11/13 16:12:09 1.19
admmassemail.php 2005/11/13 16:12:09 1.42

Thanks for your help !

Report message to a moderator

Re: Error : Invalid group id when Mass Emailing [message #29698 is a reply to message #29688]

Tue, 10 January 2006 03:27

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Did you rebuild the theme after deploying ssu.inc.t v1.19?

FUDforum Core Developer

Report message to a moderator

Re : Re: Error : Invalid group id when Mass Emailing [message #29709 is a reply to message #29698]

Tue, 10 January 2006 15:01

blemish

Messages: 13
Registered: October 2005
Location: France

Karma: 0

Junior Member

Yep, for sure ... Sad

Report message to a moderator

Re: Re : Re: Error : Invalid group id when Mass Emailing [message #29714 is a reply to message #29709]

Tue, 10 January 2006 15:41

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=7515

FUDforum Core Developer

Report message to a moderator

Re : Re: Re : Re: Error : Invalid group id when Mass Emailing [message #29716 is a reply to message #29714]

Tue, 10 January 2006 22:00

blemish

Messages: 13
Registered: October 2005
Location: France

Karma: 0

Junior Member

Great ! Thank you very much ! Smile

But ...

I checked PM & "Send to all forum moderators" and every modo received 1 PM per forum (4 modos, 24 forums = 96 PM !).

What do you think about adding some DISTINCT to this :

	} else if ($gid == $all_mods) {
		$c = uq('SELECT '.$fld.' FROM '.$DBHOST_TBL_PREFIX.'mod m INNER JOIN '.$DBHOST_TBL_PREFIX.'users u ON u.id=m.user_id '.(isset($_POST['ignore_override']) ? '' : ' WHERE (users_opt & 8)=0'));

like :

	} else if ($gid == $all_mods) {
		$c = uq('SELECT DISTINCT '.$fld.' FROM '.$DBHOST_TBL_PREFIX.'mod m INNER JOIN '.$DBHOST_TBL_PREFIX.'users u ON u.id=m.user_id '.(isset($_POST['ignore_override']) ? '' : ' WHERE (users_opt & 8)=0'));

And probably the same trick for group leaders ... ?
Thank you again & again for your valuable help !

Report message to a moderator