PHP Exception - MySqli Error: 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 search.deal_category_id order by deal

MySqli Error: 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 search.deal_category_id
   order by deal_category.priori' at line 6
Exception Type:   QMySqliDatabaseException

Rendered Page:   Click here to view contents able to be rendered

Source File:   D:\mobiles\sites\paymonthlydeals.org.uk\deals-mobile-contract.php     Line:   368

Line 363:    						   search.mobile_id = $this->intMobileId	
Line 364:    						   group by search.deal_category_id					   
Line 365:    						   order by deal_category.priority asc,deal_category.name asc";
Line 366:    				
Line 367:    				$objDatabase  = QApplication::$Database[1];
Line 368:    				$objDbResult = $objDatabase->Query($strSql);	
Line 369:    				while ($mixRow = $objDbResult->FetchArray()) {	
Line 370:    					
Line 371:    					if($mixRow["deal_category_id"] != $this->intDealCategoryId) //dont need to add deal category which he is on already
Line 372:    						$this->lstDealCategoryMain->AddItem($mixRow["deal_category_name"],$mixRow["deal_category_id"]);				
Line 373:    				}

Database Error Number: 1064

Query: Show/Hide

Select deal_category.id as deal_category_id, deal_category.name as deal_category_name
					       from search inner join deal_category on
					       search.deal_category_id = deal_category.id					       
						   where 
						   search.mobile_id = 	
						   group by search.deal_category_id					   
						   order by deal_category.priority asc,deal_category.name asc

Call Stack:

#0 D:\mobiles\sites\paymonthlydeals.org.uk\deals-mobile-contract.php(368): QMySqlDatabase->Query('Select deal_cat...')
#1 D:\mobiles\sites\paymonthlydeals.org.uk\deals-mobile-contract.php(67): ContractDeals->lstDealCategoryMain_Create()
#2 D:\mobiles\admin\qcodo\includes\qcodo\_core\qform\QFormBase.class.php(276): ContractDeals->Form_Create()
#3 D:\mobiles\sites\paymonthlydeals.org.uk\deals-mobile-contract.php(459): QFormBase::Run('ContractDeals')
#4 {main}

Variable Dump: Show/Hide

  COMSPEC
'C:\\WINDOWS\\system32\\cmd.exe'
  DOCUMENT_ROOT
'D:/mobiles/sites/paymonthlydeals.org.uk'
  GATEWAY_INTERFACE
'CGI/1.1'
  HTTP_ACCEPT
'text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5'
  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.paymonthlydeals.org.uk'
  HTTP_PRAGMA
'no-cache'
  HTTP_USER_AGENT
'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
  HTTP_X_CC_ID
'ccc01-01'
  PATH
'C:\\PHP\\;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\WINDOWS\\system32\\WindowsPowerShell\\v1.0'
  PATHEXT
'.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.PSC1'
  PATH_INFO
'/Samsung_Omnia_Pro_Scala'
  PATH_TRANSLATED
'D:\\mobiles\\sites\\paymonthlydeals.org.uk\\Samsung_Omnia_Pro_Scala'
  PHP_SELF
'/deals-mobile-contract.php/Samsung_Omnia_Pro_Scala'
  QUERY_STRING
''
  REMOTE_ADDR
'38.107.191.81'
  REMOTE_PORT
'47742'
  REQUEST_METHOD
'GET'
  REQUEST_TIME
1280477045
  REQUEST_URI
'/deals-mobile-contract.php/Samsung_Omnia_Pro_Scala'
  SCRIPT_FILENAME
'D:/mobiles/sites/paymonthlydeals.org.uk/deals-mobile-contract.php'
  SCRIPT_NAME
'/deals-mobile-contract.php'
  SERVER_ADDR
'213.175.206.208'
  SERVER_ADMIN
'admin@paymonthlydeals.org.uk'
  SERVER_NAME
'www.paymonthlydeals.org.uk'
  SERVER_PORT
'80'
  SERVER_PROTOCOL
'HTTP/1.1'
  SERVER_SIGNATURE
''
  SERVER_SOFTWARE
'Apache/2.2.11 (Win32) PHP/5.2.10'
  SystemRoot
'C:\\WINDOWS'
  WINDIR
'C:\\WINDOWS'
  _COOKIE
array (
)
  _ENV
array (
)
  _FILES
array (
)
  _GET
array (
)
  _POST
array (
)
  _REQUEST
array (
)
  _SERVER
array (
  'HTTP_X_CC_ID' => 'ccc01-01',
  'HTTP_HOST' => 'www.paymonthlydeals.org.uk',
  'HTTP_USER_AGENT' => 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5',
  'HTTP_ACCEPT_LANGUAGE' => 'en-us,en;q=0.5',
  'HTTP_ACCEPT_ENCODING' => 'gzip',
  'HTTP_ACCEPT_CHARSET' => 'ISO-8859-1,utf-8;q=0.7,*;q=0.7',
  'HTTP_CONNECTION' => 'close',
  'HTTP_CACHE_CONTROL' => 'no-cache',
  'HTTP_PRAGMA' => 'no-cache',
  'PATH' => 'C:\\PHP\\;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;C:\\WINDOWS\\system32\\WindowsPowerShell\\v1.0',
  'SystemRoot' => 'C:\\WINDOWS',
  'COMSPEC' => 'C:\\WINDOWS\\system32\\cmd.exe',
  'PATHEXT' => '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.PSC1',
  'WINDIR' => 'C:\\WINDOWS',
  'SERVER_SIGNATURE' => '',
  'SERVER_SOFTWARE' => 'Apache/2.2.11 (Win32) PHP/5.2.10',
  'SERVER_NAME' => 'www.paymonthlydeals.org.uk',
  'SERVER_ADDR' => '213.175.206.208',
  'SERVER_PORT' => '80',
  'REMOTE_ADDR' => '38.107.191.81',
  'DOCUMENT_ROOT' => 'D:/mobiles/sites/paymonthlydeals.org.uk',
  'SERVER_ADMIN' => 'admin@paymonthlydeals.org.uk',
  'SCRIPT_FILENAME' => 'D:/mobiles/sites/paymonthlydeals.org.uk/deals-mobile-contract.php',
  'REMOTE_PORT' => '47742',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'REQUEST_URI' => '/deals-mobile-contract.php/Samsung_Omnia_Pro_Scala',
  'SCRIPT_NAME' => '/deals-mobile-contract.php',
  'PATH_INFO' => '/Samsung_Omnia_Pro_Scala',
  'PATH_TRANSLATED' => 'D:\\mobiles\\sites\\paymonthlydeals.org.uk\\Samsung_Omnia_Pro_Scala',
  'PHP_SELF' => '/deals-mobile-contract.php/Samsung_Omnia_Pro_Scala',
  'REQUEST_TIME' => 1280477045,
  'argv' => 
  array (
  ),
  'argc' => 0,
)
  argc
0
  argv
array (
)

Exception Report Generated: Friday, July 30 2010, 1:04:05 AM