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
Return to the default flat view Create a new topic Submit Reply
Mass Mail System - User Ranks and PM [message #30150] Tue, 07 February 2006 03:30 Go to previous message
djzort is currently offline  djzort   Australia
Messages: 30
Registered: May 2005
Karma:
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
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Thread count = -1 !
Next Topic: Invisible subcategory
Goto Forum:
  

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

Current Time: Thu Nov 28 23:47:29 GMT 2024

Total time taken to generate the page: 0.03628 seconds