Exception Occurred

The following exception has occurred:

Exception:

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 'GROUP BY t.orderBy ORDER BY t.orderBy, t.name' at line 3 (error number: 1064)

SQL query: SELECT t.* FROM SportsTeams t, SportsSeasons c, SportsSports s WHERE t.sportID=s.id AND s.urlName='racquetball' AND t.seasonID=c.id AND c.orderBy=1 AND t.seasonID = GROUP BY t.orderBy ORDER BY t.orderBy, t.name

Connection: pnmgsluh@localhost/pnmg

FILE:	/VolumesROOTDIR/grunt/lib/DB.php
LINE:	507

BACKTRACE:
 #1: error() in /VolumesROOTDIR/grunt/lib/DB.php on line 438 
 #2: query() in /VolumesAPPDIR/views/main.php on line 2145 
 #3: setSeasonClass() in /VolumesAPPDIR/views/main.php on line 2366 
 #4: team() 
 #5: call_user_func() in /VolumesROOTDIR/grunt/lib/ViewResponder.php on line 94 
 #6: getResponse() in /VolumesROOTDIR/grunt/lib/ViewResponder.php on line 169 
 #7: getResponse() in /VolumesROOTDIR/grunt/lib/Application.php on line 901 
 #8: start() in /VolumesAPPDIR/app.php on line 17 
 #9: include_once() in /VolumesROOTDIR/public_html/sports.php on line 1 

PHP INCLUDE PATH:
.:/usr/lib/php:ROOTDIR/:APPDIR/

Session Data

NameValue

Variables

$_GET
array (
)
$_POST
array (
)
$_SERVER
array (
  'DOCUMENT_ROOT' => '/wwwdata/www.sluh.org/public_html',
  'HTTP_ACCEPT' => 'Accept: application/xhtml+xml,text/html;q=0.9,text/plain;',
  'HTTP_ACCEPT_CHARSET' => 'ISO-8859-1,utf-8;q=0.7,*;q=0.7',
  'HTTP_ACCEPT_ENCODING' => 'gzip',
  'HTTP_ACCEPT_LANGUAGE' => 'en-us,en;q=0.5',
  'HTTP_CACHE_CONTROL' => 'no-cache',
  'HTTP_CONNECTION' => 'close',
  'HTTP_HOST' => 'www.sluh.org',
  'HTTP_PRAGMA' => 'no-cache',
  'HTTP_USER_AGENT' => 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
  'PATH' => '/bin:/sbin:/usr/bin:/usr/sbin:/usr/libexec:/System/Library/CoreServices',
  'REDIRECT_SCRIPT_URI' => 'http://www.sluh.org/athletics/2007/spring/racquetball/jv/',
  'REDIRECT_SCRIPT_URL' => '/athletics/2007/spring/racquetball/jv/',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_URL' => '/athletics/2007/spring/racquetball/jv/',
  'REMOTE_ADDR' => '38.103.63.60',
  'REMOTE_PORT' => '55181',
  'SCRIPT_FILENAME' => '/wwwdata/www.sluh.org/public_html/sports.php',
  'SCRIPT_URI' => 'http://www.sluh.org/athletics/2007/spring/racquetball/jv/',
  'SCRIPT_URL' => '/athletics/2007/spring/racquetball/jv/',
  'SERVER_ADDR' => '70.143.27.115',
  'SERVER_ADMIN' => 'dumont@sluh.org',
  'SERVER_NAME' => 'www.sluh.org',
  'SERVER_PORT' => '80',
  'SERVER_SIGNATURE' => '
Apache/1.3.33 Server at www.sluh.org Port 80
', 'SERVER_SOFTWARE' => 'Apache/1.3.33 (Darwin) PHP/5.1.4 mod_ssl/2.8.24 OpenSSL/0.9.7l', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'REQUEST_URI' => '/athletics/2007/spring/racquetball/jv/', 'SCRIPT_NAME' => '/sports.php', 'PATH_INFO' => '/2007/spring/racquetball/jv/', 'PATH_TRANSLATED' => '/wwwdata/www.sluh.org/public_html/2007/spring/racquetball/jv/', 'PHP_SELF' => '/sports.php/2007/spring/racquetball/jv/', 'REQUEST_TIME' => 1223841863, 'argv' => array ( ), 'argc' => 0, )
PHP Version
5.1.4
Operating Env.
Darwin shelob.sluh.org 8.11.0 Darwin Kernel Version 8.11.0: Wed Oct 10 18:26:00 PDT 2007; root:xnu-792.24.17~1/RELEASE_PPC Power Macintosh

Error message generated by Grunt.
10/12/2008 15:04:23