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

Home » FUDforum Development » Bug Reports » Mass Mail System - User Ranks and PM
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Mass Mail System - User Ranks and PM [message #30150] Tue, 07 February 2006 03:30 Go to next message
djzort is currently offline  djzort   Australia
Messages: 30
Registered: May 2005
Karma: 0
Member
When sending mass messages out to selecting a user rank
wither PM or email, without fail there is an SQL error as follows

Invalid group id


when i send messages via PM i always get an error similar to as follows

(/usr/local/www/sites/forum.bong.com.au/FUDforumdata/include/theme/default/db.inc:78
/usr/local/www/sites/forum.bong.com.au/FUDforumdata/include/theme/default/private.inc:127
/usr/local/www/sites/forum.bong.com.au/FUDforumdata/include/theme/default/ssu.inc:30
/usr/local/www/sites/forum.bong.com.au/htdocs/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' => '6b18635c13f239f6ca3607dac74db672', )
_POST: array ( 'SQ' => '6b18635c13f239f6ca3607dac74db672', 'pm' => '1', 'group' => '-1000000001', 'subject' => 'test', 'body' => 'test', 'btn_submit' => 'Send', )
Server Version: 4.1.12-log
[Referring Page] http://forum.bong.com.au/adm/admmassemail.php?&SQ=6b18635c13f239f6ca3607dac74db672



here are some random details that may be usefull.
System Configuration
PHP built On: 	FreeBSD kusanagi.bong.com.au 5.4-RELEASE FreeBSD 5.4-RELEASE #0: Sat Jun 4 00:30:43 EST 2005 dean(at)kusanagi(dot)bong(dot)com(dot)au.:/usr/obj/usr/src/sys/DEAN0 i386
Database Version: 	4.1.12-log
PHP Version: 	4.4.2
Web Server: 	Apache/2.0.55 (FreeBSD) PHP/4.4.2 mod_perl/2.0.2 Perl/v5.8.7
WebServer to PHP interface: 	apache2handler
WebServer User/Group: 	80 / 80
Forum Version: 	2.7.4
Relavent PHP Settings: 	
Safe Mode: 	OFF
Open basedir: 	none
Display Errors: 	ON
File Uploads: 	ON
Maximum File Upload Size: 	2M
Magic Quotes: 	ON
Register Globals: 	OFF
Output Buffering: 	No
Disabled Functions: 	none
PSpell Support: 	No
Zlib Support: 	Yes
Re: Mass Mail System - User Ranks and PM [message #30157 is a reply to message #30150] Wed, 08 February 2006 00:44 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Try applying the following patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7542


FUDforum Core Developer
Re: Mass Mail System - User Ranks and PM [message #30186 is a reply to message #30150] Thu, 09 February 2006 23:13 Go to previous messageGo to next message
djzort is currently offline  djzort   Australia
Messages: 30
Registered: May 2005
Karma: 0
Member
applied patch!

im still getting

Quote:

Invalid group id


when sending PM's or emails to a 'user rank' group

i sent PM's and then emails too 'all forum moderators' and get the following for both

Quote:

5 E-mails were sent


which would seem about right. however having the message as 'PMs' when sending PM's rather than 'E-mails' would be nice
Re: Mass Mail System - User Ranks and PM [message #30215 is a reply to message #30186] Sat, 11 February 2006 23:05 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Fixed, here is the patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7543


FUDforum Core Developer
Re: Mass Mail System - User Ranks and PM [message #30263 is a reply to message #30215] Tue, 14 February 2006 11:32 Go to previous messageGo to next message
djzort is currently offline  djzort   Australia
Messages: 30
Registered: May 2005
Karma: 0
Member
Ilia wrote on Sun, 12 February 2006 10:05

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


seems to have fixed it. would be nice for it to indicate when appropriate that 'pms' have been sent rather than emails.

cheers
Re: Mass Mail System - User Ranks and PM [message #30264 is a reply to message #30263] Tue, 14 February 2006 14:09 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Will be available in the next release.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Thread count = -1 !
Next Topic: Invisible subcategory
Goto Forum:
  

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

Current Time: Thu Jun 13 21:17:13 GMT 2024

Total time taken to generate the page: 0.04034 seconds