Database Error

Error: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'AND active=1 order by iOrder' at line 1

SQL Query: SELECT * FROM tblcategory WHERE CatID= AND active=1 order by iOrder

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

• CORE/Cake/Model/Datasource/DboSource.php line 460 → PDOStatement->execute(array)

          try {
              $query = $this->_connection->prepare($sql, $prepareOptions);
              $query->setFetchMode(PDO::FETCH_LAZY);
              if (!$query->execute($params)) {
                  $this->_results = $query;

  array()

• CORE/Cake/Model/Datasource/DboSource.php line 426 → DboSource->_execute(string, array)

          $options += array('log' => $this->fullDebug);
  
          $t = microtime(true);
          $this->_result = $this->_execute($sql, $params);
  

  'SELECT * FROM tblcategory WHERE CatID= AND active=1 order by iOrder'
  array()

• CORE/Cake/Model/Datasource/DboSource.php line 670 → DboSource->execute(string, array, array)

          if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
              return $cached;
          }
          if ($result = $this->execute($sql, array(), $params)) {
              $out = array();

  'SELECT * FROM tblcategory WHERE CatID= AND active=1 order by iOrder'
  array()
  array()

• CORE/Cake/Model/Datasource/DboSource.php line 539 → DboSource->fetchAll(string)

          $recursive = null;
  
          if (count($args) === 1) {
              return $this->fetchAll($args[0]);
          } elseif (count($args) > 1 && (strpos($args[0], 'findBy') === 0 || strpos($args[0], 'findAllBy') === 0)) {

  'SELECT * FROM tblcategory WHERE CatID= AND active=1 order by iOrder'

• CORE/Cake/Utility/CostumeRoomQ2A.php line 21 → DboSource->query(string)

          $ret = array();
  
          $i=0;
  
          $db = ConnectionManager::getDataSource('default');
  
          $rsDB = $db->query($Query); //mysql_query($Query);
  
  
  

  'SELECT * FROM tblcategory WHERE CatID= AND active=1 order by iOrder'

• CORE/Cake/Utility/CostumeRoomMenu.php line 64 → CostumeRoomQ2A::Query2Array(string)

          echo "</ul>";
  
      }
  
      public static function MenuPath($catid,$temp=""){
  
          $rsCatMenu = CostumeRoomQ2A::Query2Array("SELECT * FROM tblcategory WHERE CatID=".$catid.' AND active=1 order by iOrder');
  
          if(sizeof($rsCatMenu)==0) return 0;
  

  'SELECT * FROM tblcategory WHERE CatID= AND active=1 order by iOrder'

• CORE/Cake/Utility/CostumeRoom.php line 56 → CostumeRoomMenu::MenuPath(null)

          <header>
  
              <div id="MenuWrapper">
  
              <div id="MenuBar">
  
                  <div id="MenuPath"><?php CostumeRoomMenu::MenuPath($catid); ?></div>
  
                  <div id="cartlink">
  

  null

• APP/View/CMS/show.ctp line 2 → CostumeRoom::HTML2Content(null, string, string, null)

  <link rel="stylesheet" type="text/css" href="<?php echo cRootAddress ; ?>css/aboutus.css" />
  
  <?php CostumeRoom::HTML2Content($Title,"","",$CatID); ?>
  
  <div id="contentArea">
  

  null
  ''
  ''
  null

• CORE/Cake/View/View.php line 948 → include(string)

          extract($dataForView);
          ob_start();
  
          include $this->__viewFile;
  

  '/var/www/html/thecostumeroom/app/View/CMS/show.ctp'

• CORE/Cake/View/View.php line 910 → View->_evaluate(string, array)

          $beforeEvent = new CakeEvent('View.beforeRenderFile', $this, array($viewFile));
  
          $eventManager->dispatch($beforeEvent);
          $content = $this->_evaluate($viewFile, $data);
  

  '/var/www/html/thecostumeroom/app/View/CMS/show.ctp'
  array()

• CORE/Cake/View/View.php line 471 → View->_render(string)

          if ($view !== false && $viewFileName = $this->_getViewFileName($view)) {
              $this->_currentType = self::TYPE_VIEW;
              $this->getEventManager()->dispatch(new CakeEvent('View.beforeRender', $this, array($viewFileName)));
              $this->Blocks->set('content', $this->_render($viewFileName));
              $this->getEventManager()->dispatch(new CakeEvent('View.afterRender', $this, array($viewFileName)));

  '/var/www/html/thecostumeroom/app/View/CMS/show.ctp'

• CORE/Cake/Controller/Controller.php line 948 → View->render(null, null)

          }
  
          $this->autoRender = false;
          $this->response->body($this->View->render($view, $layout));
          return $this->response;

  null
  null

• CORE/Cake/Routing/Dispatcher.php line 194 → Controller->render()

          }
  
          if ($render && $controller->autoRender) {
              $response = $controller->render();
          } elseif (!($result instanceof CakeResponse) &&

• CORE/Cake/Routing/Dispatcher.php line 162 → Dispatcher->_invoke(CmsController, CakeRequest, CakeResponse)

              ));
          }
  
          $response = $this->_invoke($controller, $request, $response);
          if (isset($request->params['return'])) {

  object(CmsController) {
  	name => 'CMS'
  	uses => array(
  		[maximum depth reached]
  	)
  	helpers => array([maximum depth reached])
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'CMS'
  	layoutPath => null
  	viewVars => array([maximum depth reached])
  	view => 'show'
  	layout => 'default'
  	autoRender => false
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	components => array(
  		[maximum depth reached]
  	)
  	viewClass => 'View'
  	View => object(View) {}
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array(
  		[maximum depth reached]
  	)
  	scaffold => false
  	methods => array(
  		[maximum depth reached]
  	)
  	modelClass => 'CM'
  	modelKey => 'c_m'
  	validationErrors => null
  	Session => object(SessionComponent) {}
  	CMS => object(AppModel) {}
  	[protected] _responseClass => 'CakeResponse'
  	[protected] _mergeParent => 'AppController'
  	[protected] _eventManager => object(CakeEventManager) {}
  }
  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => 'cms/HireTerms'
  	base => ''
  	webroot => '/'
  	here => '/cms/HireTerms'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }
  object(CakeResponse) {
  	[protected] _statusCodes => array(
  		[maximum depth reached]
  	)
  	[protected] _mimeTypes => array(
  		[maximum depth reached]
  	)
  	[protected] _protocol => 'HTTP/1.1'
  	[protected] _status => (int) 200
  	[protected] _contentType => 'text/html'
  	[protected] _headers => array([maximum depth reached])
  	[protected] _body => null
  	[protected] _file => null
  	[protected] _charset => 'UTF-8'
  	[protected] _cacheDirectives => array([maximum depth reached])
  	[protected] _cookies => array([maximum depth reached])
  }

• APP/webroot/index.php line 109 → Dispatcher->dispatch(CakeRequest, CakeResponse)

  $Dispatcher->dispatch(
      new CakeRequest(),
      new CakeResponse()
  );
  

  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => 'cms/HireTerms'
  	base => ''
  	webroot => '/'
  	here => '/cms/HireTerms'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }
  object(CakeResponse) {
  	[protected] _statusCodes => array(
  		[maximum depth reached]
  	)
  	[protected] _mimeTypes => array(
  		[maximum depth reached]
  	)
  	[protected] _protocol => 'HTTP/1.1'
  	[protected] _status => (int) 200
  	[protected] _contentType => 'text/html'
  	[protected] _headers => array([maximum depth reached])
  	[protected] _body => null
  	[protected] _file => null
  	[protected] _charset => 'UTF-8'
  	[protected] _cacheDirectives => array([maximum depth reached])
  	[protected] _cookies => array([maximum depth reached])
  }