Home »
FUDforum Development »
Bug Reports »
Minor issue with older version (Mass email fails SQL query)
Minor issue with older version [message #157844] |
Fri, 05 September 2008 06:24 |
DaveQB
 Messages: 109 Registered: January 2006 Location: Sydney
Karma: 0
|
Senior Member |

|
|
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
|
|
|
Goto Forum:
Current Time: Fri Apr 04 23:37:04 GMT 2025
Total time taken to generate the page: 0.02414 seconds