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

Home » FUDforum Development » Bug Reports » Minor issue with older version (Mass email fails SQL query)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Minor issue with older version [message #157844] Fri, 05 September 2008 02:24
DaveQB is currently offline  DaveQB   Australia
Messages: 109
Registered: January 2006
Location: Sydney
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user

Now this is an older version of FUD [I must get around to updating] and MySQL "mysql Ver 14.12 Distrib 5.0.51a, for redhat-linux-gnu (x86_64) using readline 5.0" and I think I have FUD version "2-7-3"

So maybe an update would fix it, but anyone know whats wrong with the query and 'gm' ?

Query
SELECT email FROM a group_members gm INNER JOIN ausers u ON u.id=gm.user_id WHERE gm.group_id=66




(/home/wspirates/domains/forums.wspirates.com/FUDforumwsp/include/theme/default/db.inc:78
/home/wspirates/domains/forums.wspirates.com/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 'gm INNER JOIN ausers u ON u.id=gm.user_id WHERE gm.group_id=66' at line 1
Query: SELECT email FROM a group_members gm INNER JOIN ausers u ON u.id=gm.user_id WHERE gm.group_id=66
_GET: array ( 'S' => 'e7702df76b1490dc9f087cba0833404b', 'SQ' => '2a659521ad79bb2322141ade172a30c0', )
_POST: array ( 'S' => 'e7702df76b1490dc9f087cba0833404b', 'SQ' => 'd942842b3963caa942757a72811a6c37', 'group' => '66', 'subject' => 'Week 1 postponed', 'body' => 'Dear All, It is with great disappointment that I advise that Craig Park has been closed for the weekend and all Round 1 games scheduled for that venue are now postponed to the wash out weekend of Sat, 8th November 2008 This affects the following games: Outlaws Vs Seahawks (4pm) Pirates vs Predators (7pm) At this stage the Mascot Venue is still open but I will advise as soon as any further information is received. Regards Jason ', 'ignore_override' => '1', 'btn_submit' => 'Send', )
Server Version: 5.0.51a
[Referring Page] http://forums.wspirates.com/adm/admmassemail.php?S=e7702df76b1490dc9f087cba0833404b&SQ=2a659521ad79bb2322141ade172a30c0
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Memory error running forum consistency
Next Topic: Bust-a-punk sent for temporary bans as well as permanent ones
Goto Forum:
  

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

Current Time: Mon Dec 18 04:09:46 EST 2017

Total time taken to generate the page: 0.00717 seconds