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/easyweig/public_html/cheapmonthlymobilephones.co.uk/pay-monthly-mobile-deals.php     Line:   384

Line 379:    						   search.mobile_id = $this->intMobileId	
Line 380:    						   group by search.deal_category_id					   
Line 381:    						   order by deal_category.priority asc,deal_category.name asc";
Line 382:    				
Line 383:    				$objDatabase  = QApplication::$Database[1];
Line 384:    				$objDbResult = $objDatabase->Query($strSql);	
Line 385:    				while ($mixRow = $objDbResult->FetchArray()) {	
Line 386:    					
Line 387:    					if($mixRow["deal_category_id"] != $this->intDealCategoryId) //dont need to add deal category which he is on already
Line 388:    						$this->lstDealCategoryMain->AddItem($mixRow["deal_category_name"],$mixRow["deal_category_id"]);				
Line 389:    				}

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/easyweig/public_html/cheapmonthlymobilephones.co.uk/pay-monthly-mobile-deals.php(384): QMySqlDatabase->Query('Select deal_cat...')
#1 /home/easyweig/public_html/cheapmonthlymobilephones.co.uk/pay-monthly-mobile-deals.php(68): ContractDeals->lstDealCategoryMain_Create()
#2 /home/easyweig/public_html/mobiles_qcodo/includes/qcodo/_core/qform/QFormBase.class.php(276): ContractDeals->Form_Create()
#3 /home/easyweig/public_html/cheapmonthlymobilephones.co.uk/pay-monthly-mobile-deals.php(477): QFormBase::Run('ContractDeals')
#4 {main}

Variable Dump: Show/Hide

  HTTP_COOKIE_VARS
array (
  'PHPSESSID' => 'f126c1f0bfdcba8e24d3c296ed4b9f5c',
)
  HTTP_ENV_VARS
array (
  'MANPATH' => '/usr/lib/courier-imap/man:',
  'HOSTNAME' => 'kent.webhosting.uk.com',
  'TERM' => 'xterm',
  'SHELL' => '/bin/bash',
  'HISTSIZE' => '1000',
  'USER' => 'root',
  'LD_LIBRARY_PATH' => '/usr/local/apache/lib:',
  'LS_COLORS' => 'no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.avi=01;35:*.fli=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.flac=01;35:*.mp3=01;35:*.mpc=01;35:*.ogg=01;35:*.wav=01;35:',
  'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/courier-imap/sbin:/usr/lib/courier-imap/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin',
  'MAIL' => '/var/spool/mail/root',
  'PWD' => '/home/bazi/public_html',
  'INPUTRC' => '/etc/inputrc',
  'JAVA_HOME' => '/usr/local/jdk',
  'EDITOR' => 'pico',
  'LANG' => 'en_GB.UTF-8',
  'HOME' => '/root',
  'SHLVL' => '2',
  'LS_OPTIONS' => '--color=tty -F -a -b -T 0',
  'LOGNAME' => 'root',
  'CVS_RSH' => 'ssh',
  'VISUAL' => 'pico',
  'CLASSPATH' => '.:/usr/local/jdk/lib/classes.zip',
  'LESSOPEN' => '|/usr/bin/lesspipe.sh %s',
  'G_BROKEN_FILENAMES' => '1',
  '_' => '/usr/local/apache/bin/httpd',
)
  HTTP_GET_VARS
array (
)
  HTTP_POST_FILES
array (
)
  HTTP_POST_VARS
array (
)
  HTTP_SERVER_VARS
array (
  'UNIQUE_ID' => 'TFMetdXlWwYAAFOrjxAAAAAw',
  'HTTP_X_CC_ID' => 'ccc03-02',
  'HTTP_HOST' => 'www.cheapmonthlymobilephones.co.uk',
  'HTTP_USER_AGENT' => 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5',
  'HTTP_ACCEPT_LANGUAGE' => 'en-us,en;q=0.5',
  'HTTP_ACCEPT_ENCODING' => 'gzip',
  'HTTP_ACCEPT_CHARSET' => 'ISO-8859-1,utf-8;q=0.7,*;q=0.7',
  'HTTP_CONNECTION' => 'close',
  'HTTP_CACHE_CONTROL' => 'no-cache',
  'HTTP_PRAGMA' => 'no-cache',
  'HTTP_COOKIE' => 'PHPSESSID=f126c1f0bfdcba8e24d3c296ed4b9f5c',
  'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/courier-imap/sbin:/usr/lib/courier-imap/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin',
  'SERVER_SIGNATURE' => '',
  'SERVER_SOFTWARE' => 'Apache',
  'SERVER_NAME' => 'www.cheapmonthlymobilephones.co.uk',
  'SERVER_ADDR' => '91.186.0.9',
  'SERVER_PORT' => '80',
  'REMOTE_ADDR' => '38.107.191.108',
  'DOCUMENT_ROOT' => '/home/easyweig/public_html/cheapmonthlymobilephones.co.uk',
  'SERVER_ADMIN' => 'webmaster@cheapmonthlymobilephones.easyweightlosstips.co.uk',
  'SCRIPT_FILENAME' => '/home/easyweig/public_html/cheapmonthlymobilephones.co.uk/pay-monthly-mobile-deals.php',
  'REMOTE_PORT' => '62711',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'REQUEST_URI' => '/pay-monthly-mobile-deals.php/Nokia_N97_32',
  'SCRIPT_NAME' => '/pay-monthly-mobile-deals.php',
  'PATH_INFO' => '/Nokia_N97_32',
  'PATH_TRANSLATED' => '/home/easyweig/public_html/cheapmonthlymobilephones.co.uk/Nokia_N97_32',
  'PHP_SELF' => '/pay-monthly-mobile-deals.php/Nokia_N97_32',
  'REQUEST_TIME' => 1280515765,
  'argv' => 
  array (
  ),
  'argc' => 0,
)
  HTTP_SESSION_VARS
array (
  'RenderedPageForError' => '	 ',
)
  _COOKIE
array (
  'PHPSESSID' => 'f126c1f0bfdcba8e24d3c296ed4b9f5c',
)
  _ENV
array (
  'MANPATH' => '/usr/lib/courier-imap/man:',
  'HOSTNAME' => 'kent.webhosting.uk.com',
  'TERM' => 'xterm',
  'SHELL' => '/bin/bash',
  'HISTSIZE' => '1000',
  'USER' => 'root',
  'LD_LIBRARY_PATH' => '/usr/local/apache/lib:',
  'LS_COLORS' => 'no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.avi=01;35:*.fli=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.flac=01;35:*.mp3=01;35:*.mpc=01;35:*.ogg=01;35:*.wav=01;35:',
  'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/courier-imap/sbin:/usr/lib/courier-imap/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin',
  'MAIL' => '/var/spool/mail/root',
  'PWD' => '/home/bazi/public_html',
  'INPUTRC' => '/etc/inputrc',
  'JAVA_HOME' => '/usr/local/jdk',
  'EDITOR' => 'pico',
  'LANG' => 'en_GB.UTF-8',
  'HOME' => '/root',
  'SHLVL' => '2',
  'LS_OPTIONS' => '--color=tty -F -a -b -T 0',
  'LOGNAME' => 'root',
  'CVS_RSH' => 'ssh',
  'VISUAL' => 'pico',
  'CLASSPATH' => '.:/usr/local/jdk/lib/classes.zip',
  'LESSOPEN' => '|/usr/bin/lesspipe.sh %s',
  'G_BROKEN_FILENAMES' => '1',
  '_' => '/usr/local/apache/bin/httpd',
)
  _FILES
array (
)
  _GET
array (
)
  _POST
array (
)
  _REQUEST
array (
  'PHPSESSID' => 'f126c1f0bfdcba8e24d3c296ed4b9f5c',
)
  _SERVER
array (
  'UNIQUE_ID' => 'TFMetdXlWwYAAFOrjxAAAAAw',
  'HTTP_X_CC_ID' => 'ccc03-02',
  'HTTP_HOST' => 'www.cheapmonthlymobilephones.co.uk',
  'HTTP_USER_AGENT' => 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5',
  'HTTP_ACCEPT_LANGUAGE' => 'en-us,en;q=0.5',
  'HTTP_ACCEPT_ENCODING' => 'gzip',
  'HTTP_ACCEPT_CHARSET' => 'ISO-8859-1,utf-8;q=0.7,*;q=0.7',
  'HTTP_CONNECTION' => 'close',
  'HTTP_CACHE_CONTROL' => 'no-cache',
  'HTTP_PRAGMA' => 'no-cache',
  'HTTP_COOKIE' => 'PHPSESSID=f126c1f0bfdcba8e24d3c296ed4b9f5c',
  'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/courier-imap/sbin:/usr/lib/courier-imap/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin',
  'SERVER_SIGNATURE' => '',
  'SERVER_SOFTWARE' => 'Apache',
  'SERVER_NAME' => 'www.cheapmonthlymobilephones.co.uk',
  'SERVER_ADDR' => '91.186.0.9',
  'SERVER_PORT' => '80',
  'REMOTE_ADDR' => '38.107.191.108',
  'DOCUMENT_ROOT' => '/home/easyweig/public_html/cheapmonthlymobilephones.co.uk',
  'SERVER_ADMIN' => 'webmaster@cheapmonthlymobilephones.easyweightlosstips.co.uk',
  'SCRIPT_FILENAME' => '/home/easyweig/public_html/cheapmonthlymobilephones.co.uk/pay-monthly-mobile-deals.php',
  'REMOTE_PORT' => '62711',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'REQUEST_URI' => '/pay-monthly-mobile-deals.php/Nokia_N97_32',
  'SCRIPT_NAME' => '/pay-monthly-mobile-deals.php',
  'PATH_INFO' => '/Nokia_N97_32',
  'PATH_TRANSLATED' => '/home/easyweig/public_html/cheapmonthlymobilephones.co.uk/Nokia_N97_32',
  'PHP_SELF' => '/pay-monthly-mobile-deals.php/Nokia_N97_32',
  'REQUEST_TIME' => 1280515765,
  'argv' => 
  array (
  ),
  'argc' => 0,
)

Exception Report Generated: Friday, July 30 2010, 11:49:25 AM