Exception in PHP Script
/contract-deals-mobile-phone.php/Nokia_6303_Classic_Black_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.mobile-phones-deals.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\mobile-phones-deals.org.uk\contract-deals-mobile-phone.php     Line:   365

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

Database Error Number:  1064

Query:   Show/Hide


Call Stack:

#0 D:\mobiles\sites\mobile-phones-deals.org.uk\contract-deals-mobile-phone.php(365): QMySqlDatabase->Query('Select deal_cat...')
#1 D:\mobiles\sites\mobile-phones-deals.org.uk\contract-deals-mobile-phone.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\mobile-phones-deals.org.uk\contract-deals-mobile-phone.php(456): QFormBase::Run('ContractDeals')
#4 {main}

Variable Dump:   Show/Hide



Exception Report Generated:  Thursday, February 9 2012, 5:17:36 AM