Exception in PHP Script
/mobile-phone-simfree-deals.php/Nokia_2220_Blue
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.monthlyphonedeals.co.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\monthlyphonedeals.co.uk\mobile-phone-simfree-deals.php     Line:   317

Line 312:    						   search.mobile_id = $this->intMobileId	
Line 313:    						   group by search.deal_category_id					   
Line 314:    						   order by deal_category.priority asc,deal_category.name asc";
Line 315:    				
Line 316:    				$objDatabase  = QApplication::$Database[1];
Line 317:    				$objDbResult = $objDatabase->Query($strSql);	
Line 318:    				while ($mixRow = $objDbResult->FetchArray()) {	
Line 319:    					
Line 320:    					if($mixRow["deal_category_id"] != $this->intDealCategoryId) //dont need to add deal category which he is on already
Line 321:    						$this->lstDealCategoryMain->AddItem($mixRow["deal_category_name"],$mixRow["deal_category_id"]);				
Line 322:    				}

Database Error Number:  1064

Query:   Show/Hide


Call Stack:

#0 D:\mobiles\sites\monthlyphonedeals.co.uk\mobile-phone-simfree-deals.php(317): QMySqlDatabase->Query('Select deal_cat...')
#1 D:\mobiles\sites\monthlyphonedeals.co.uk\mobile-phone-simfree-deals.php(64): SimFreeDeals->lstDealCategoryMain_Create()
#2 D:\mobiles\admin\qcodo\includes\qcodo\_core\qform\QFormBase.class.php(276): SimFreeDeals->Form_Create()
#3 D:\mobiles\sites\monthlyphonedeals.co.uk\mobile-phone-simfree-deals.php(400): QFormBase::Run('SimFreeDeals')
#4 {main}

Variable Dump:   Show/Hide



Exception Report Generated:  Wednesday, February 8 2012, 4:25:34 PM