Exception in PHP Script
/contract-mobilephonedeals.php/Sony_Ericsson_Satio_Silver_Clearance
PHP Version: 5.2.9-1;  Zend Engine Version: 2.2.0;  Qcubed Version: 1.0.0 RC2 (QCubed 1.0 RC2)
Application: Apache/2.2.18 (Win32) PHP/5.2.9-1;  Server Name: www.freelinerentalphones.org.uk
HTTP User Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
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

Source File:   D:\mobiles\sites\freelinerentalphones.org.uk\contract-mobilephonedeals.php     Line:   393

Line 388:    						   search.mobile_id = $this->intMobileId	
Line 389:    						   group by search.deal_category_id					   
Line 390:    						   order by deal_category.priority asc,deal_category.name asc";
Line 391:    				
Line 392:    				$objDatabase  = QApplication::$Database[1];
Line 393:    				$objDbResult = $objDatabase->Query($strSql);	
Line 394:    				while ($mixRow = $objDbResult->FetchArray()) {	
Line 395:    					
Line 396:    					if($mixRow["deal_category_id"] != $this->intDealCategoryId) //dont need to add deal category which he is on already
Line 397:    						$this->lstDealCategoryMain->AddItem($mixRow["deal_category_name"],$mixRow["deal_category_id"]);				
Line 398:    				}

Database Error Number:  1064

Query:   Show/Hide


Call Stack:

#0 D:\mobiles\sites\freelinerentalphones.org.uk\contract-mobilephonedeals.php(393): QMySqlDatabase->Query('Select deal_cat...')
#1 D:\mobiles\sites\freelinerentalphones.org.uk\contract-mobilephonedeals.php(68): ContractDeals->lstDealCategoryMain_Create()
#2 D:\mobiles\admin\qcodo\includes\qcodo\_core\qform\QFormBase.class.php(276): ContractDeals->Form_Create()
#3 D:\mobiles\sites\freelinerentalphones.org.uk\contract-mobilephonedeals.php(484): QFormBase::Run('ContractDeals')
#4 {main}

Variable Dump:   Show/Hide



Exception Report Generated:  Sunday, February 12 2012, 8:55:08 AM