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.priorit' at line 6
Exception Type:   QMySqliDatabaseException

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

Source File:   /home/cashpayd/public_html/newmobilephonedeals.org.uk/contract-mobile-phone-deals.php     Line:   361

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

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 /home/cashpayd/public_html/newmobilephonedeals.org.uk/contract-mobile-phone-deals.php(361): QMySqlDatabase->Query('Select deal_cat...')
#1 /home/cashpayd/public_html/newmobilephonedeals.org.uk/contract-mobile-phone-deals.php(67): ContractDeals->lstDealCategoryMain_Create()
#2 /home/cashpayd/public_html/qcodo/includes/qcodo/_core/qform/QFormBase.class.php(276): ContractDeals->Form_Create()
#3 /home/cashpayd/public_html/newmobilephonedeals.org.uk/contract-mobile-phone-deals.php(452): QFormBase::Run('ContractDeals')
#4 {main}

Variable Dump: Show/Hide

  HTTP_COOKIE_VARS
array (
  'PHPSESSID' => 'b9c499e14ce1d95b10d4fd4aae5d1468',
)
  HTTP_ENV_VARS
array (
  'DOCUMENT_ROOT' => '/home/cashpayd/public_html/newmobilephonedeals.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_COOKIE' => 'PHPSESSID=b9c499e14ce1d95b10d4fd4aae5d1468',
  'HTTP_HOST' => 'www.newmobilephonedeals.org.uk',
  'HTTP_PRAGMA' => 'no-cache',
  'HTTP_USER_AGENT' => 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
  'HTTP_X_CC_ID' => 'ccc04-02',
  'PATH' => '/bin:/usr/bin',
  'PATH_INFO' => '/Sony_Ericsson_W715_Silver',
  'PATH_TRANSLATED' => '/home/cashpayd/public_html/newmobilephonedeals.org.uk/contract-mobile-phone-deals.php',
  'QUERY_STRING' => '',
  'REDIRECT_STATUS' => '200',
  'REMOTE_ADDR' => '38.107.191.118',
  'REMOTE_PORT' => '53618',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_URI' => '/contract-mobile-phone-deals.php/Sony_Ericsson_W715_Silver',
  'SCRIPT_FILENAME' => '/home/cashpayd/public_html/newmobilephonedeals.org.uk/contract-mobile-phone-deals.php',
  'SCRIPT_NAME' => '/contract-mobile-phone-deals.php',
  'SERVER_ADDR' => '78.129.212.2',
  'SERVER_ADMIN' => 'webmaster@newmobilephonesdfdeals.cashpayday.me.uk',
  'SERVER_NAME' => 'www.newmobilephonedeals.org.uk',
  'SERVER_PORT' => '80',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'SERVER_SIGNATURE' => '',
  'SERVER_SOFTWARE' => 'Apache',
  'UNIQUE_ID' => 'TFKpbk6B1AIAAF08PsIAAAFP',
)
  HTTP_GET_VARS
array (
)
  HTTP_POST_FILES
array (
)
  HTTP_POST_VARS
array (
)
  HTTP_SERVER_VARS
array (
  'DOCUMENT_ROOT' => '/home/cashpayd/public_html/newmobilephonedeals.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_COOKIE' => 'PHPSESSID=b9c499e14ce1d95b10d4fd4aae5d1468',
  'HTTP_HOST' => 'www.newmobilephonedeals.org.uk',
  'HTTP_PRAGMA' => 'no-cache',
  'HTTP_USER_AGENT' => 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
  'HTTP_X_CC_ID' => 'ccc04-02',
  'PATH' => '/bin:/usr/bin',
  'PATH_INFO' => '/Sony_Ericsson_W715_Silver',
  'PATH_TRANSLATED' => '/home/cashpayd/public_html/newmobilephonedeals.org.uk/contract-mobile-phone-deals.php',
  'QUERY_STRING' => '',
  'REDIRECT_STATUS' => '200',
  'REMOTE_ADDR' => '38.107.191.118',
  'REMOTE_PORT' => '53618',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_URI' => '/contract-mobile-phone-deals.php/Sony_Ericsson_W715_Silver',
  'SCRIPT_FILENAME' => '/home/cashpayd/public_html/newmobilephonedeals.org.uk/contract-mobile-phone-deals.php',
  'SCRIPT_NAME' => '/contract-mobile-phone-deals.php',
  'SERVER_ADDR' => '78.129.212.2',
  'SERVER_ADMIN' => 'webmaster@newmobilephonesdfdeals.cashpayday.me.uk',
  'SERVER_NAME' => 'www.newmobilephonedeals.org.uk',
  'SERVER_PORT' => '80',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'SERVER_SIGNATURE' => '',
  'SERVER_SOFTWARE' => 'Apache',
  'UNIQUE_ID' => 'TFKpbk6B1AIAAF08PsIAAAFP',
  'PHP_SELF' => '/contract-mobile-phone-deals.php/Sony_Ericsson_W715_Silver',
  'REQUEST_TIME' => 1280485743,
  'argv' => 
  array (
  ),
  'argc' => 0,
)
  HTTP_SESSION_VARS
array (
  'RenderedPageForError' => '	 ',
)
  _COOKIE
array (
  'PHPSESSID' => 'b9c499e14ce1d95b10d4fd4aae5d1468',
)
  _ENV
array (
  'DOCUMENT_ROOT' => '/home/cashpayd/public_html/newmobilephonedeals.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_COOKIE' => 'PHPSESSID=b9c499e14ce1d95b10d4fd4aae5d1468',
  'HTTP_HOST' => 'www.newmobilephonedeals.org.uk',
  'HTTP_PRAGMA' => 'no-cache',
  'HTTP_USER_AGENT' => 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
  'HTTP_X_CC_ID' => 'ccc04-02',
  'PATH' => '/bin:/usr/bin',
  'PATH_INFO' => '/Sony_Ericsson_W715_Silver',
  'PATH_TRANSLATED' => '/home/cashpayd/public_html/newmobilephonedeals.org.uk/contract-mobile-phone-deals.php',
  'QUERY_STRING' => '',
  'REDIRECT_STATUS' => '200',
  'REMOTE_ADDR' => '38.107.191.118',
  'REMOTE_PORT' => '53618',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_URI' => '/contract-mobile-phone-deals.php/Sony_Ericsson_W715_Silver',
  'SCRIPT_FILENAME' => '/home/cashpayd/public_html/newmobilephonedeals.org.uk/contract-mobile-phone-deals.php',
  'SCRIPT_NAME' => '/contract-mobile-phone-deals.php',
  'SERVER_ADDR' => '78.129.212.2',
  'SERVER_ADMIN' => 'webmaster@newmobilephonesdfdeals.cashpayday.me.uk',
  'SERVER_NAME' => 'www.newmobilephonedeals.org.uk',
  'SERVER_PORT' => '80',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'SERVER_SIGNATURE' => '',
  'SERVER_SOFTWARE' => 'Apache',
  'UNIQUE_ID' => 'TFKpbk6B1AIAAF08PsIAAAFP',
)
  _FILES
array (
)
  _GET
array (
)
  _POST
array (
)
  _REQUEST
array (
  'PHPSESSID' => 'b9c499e14ce1d95b10d4fd4aae5d1468',
)
  _SERVER
array (
  'DOCUMENT_ROOT' => '/home/cashpayd/public_html/newmobilephonedeals.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_COOKIE' => 'PHPSESSID=b9c499e14ce1d95b10d4fd4aae5d1468',
  'HTTP_HOST' => 'www.newmobilephonedeals.org.uk',
  'HTTP_PRAGMA' => 'no-cache',
  'HTTP_USER_AGENT' => 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
  'HTTP_X_CC_ID' => 'ccc04-02',
  'PATH' => '/bin:/usr/bin',
  'PATH_INFO' => '/Sony_Ericsson_W715_Silver',
  'PATH_TRANSLATED' => '/home/cashpayd/public_html/newmobilephonedeals.org.uk/contract-mobile-phone-deals.php',
  'QUERY_STRING' => '',
  'REDIRECT_STATUS' => '200',
  'REMOTE_ADDR' => '38.107.191.118',
  'REMOTE_PORT' => '53618',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_URI' => '/contract-mobile-phone-deals.php/Sony_Ericsson_W715_Silver',
  'SCRIPT_FILENAME' => '/home/cashpayd/public_html/newmobilephonedeals.org.uk/contract-mobile-phone-deals.php',
  'SCRIPT_NAME' => '/contract-mobile-phone-deals.php',
  'SERVER_ADDR' => '78.129.212.2',
  'SERVER_ADMIN' => 'webmaster@newmobilephonesdfdeals.cashpayday.me.uk',
  'SERVER_NAME' => 'www.newmobilephonedeals.org.uk',
  'SERVER_PORT' => '80',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'SERVER_SIGNATURE' => '',
  'SERVER_SOFTWARE' => 'Apache',
  'UNIQUE_ID' => 'TFKpbk6B1AIAAF08PsIAAAFP',
  'PHP_SELF' => '/contract-mobile-phone-deals.php/Sony_Ericsson_W715_Silver',
  'REQUEST_TIME' => 1280485743,
  'argv' => 
  array (
  ),
  'argc' => 0,
)

Exception Report Generated: Friday, July 30 2010, 11:29:03 AM