Exception in PHP Script
/contract-deals-mobilephone.php/Samsung_SHW-A130S
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.mobilephonesdeals.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\mobilephonesdeals.org.uk\contract-deals-mobilephone.php     Line:   407

Line 402:    						   search.mobile_id = $this->intMobileId	
Line 403:    						   group by search.deal_category_id					   
Line 404:    						   order by deal_category.priority asc,deal_category.name asc";
Line 405:    				
Line 406:    				$objDatabase  = QApplication::$Database[1];
Line 407:    				$objDbResult = $objDatabase->Query($strSql);	
Line 408:    				while ($mixRow = $objDbResult->FetchArray()) {	
Line 409:    					
Line 410:    					if($mixRow["deal_category_id"] != $this->intDealCategoryId) //dont need to add deal category which he is on already
Line 411:    						$this->lstDealCategoryMain->AddItem($mixRow["deal_category_name"],$mixRow["deal_category_id"]);				
Line 412:    				}

Database Error Number:  1064

Query:   Show/Hide


Call Stack:

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

Variable Dump:   Show/Hide



Exception Report Generated:  Wednesday, February 8 2012, 3:08:46 PM