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
Calendar
Search
Help
Members
Register
Login
Home
]