Prototype Communes

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 periods.period_code='x' AND periods.id In () AND Unit.start<=periods.end A' at line 1

SQL Query: SELECT DISTINCT Count(Distinct Unit.id) AS nb FROM periods, basesigns_tags INNER JOIN (units AS Unit INNER JOIN cities_units ON Unit.id = cities_units.unit_id) ON basesigns_tags.basesign_id = Unit.basesign_id WHERE cities_units.city_id In () AND periods.period_code='x' AND periods.id In () AND Unit.start<=periods.end AND Unit.end>=periods.start AND basesigns_tags.tag_id In (,311);

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 436 → 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 403 → DboSource->_execute(string, array)

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

  ' SELECT DISTINCT Count(Distinct Unit.id) AS nb FROM periods, basesigns_tags INNER JOIN (units AS Unit INNER JOIN cities_units ON Unit.id = cities_units.unit_id) ON basesigns_tags.basesign_id = Unit.basesign_id WHERE cities_units.city_id In () AND periods.period_code='x' AND periods.id In () AND Unit.start<=periods.end AND Unit.end>=periods.start AND basesigns_tags.tag_id In (,311);'
  array()

• CORE/Cake/Model/Datasource/DboSource.php line 646 → 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 DISTINCT Count(Distinct Unit.id) AS nb FROM periods, basesigns_tags INNER JOIN (units AS Unit INNER JOIN cities_units ON Unit.id = cities_units.unit_id) ON basesigns_tags.basesign_id = Unit.basesign_id WHERE cities_units.city_id In () AND periods.period_code='x' AND periods.id In () AND Unit.start<=periods.end AND Unit.end>=periods.start AND basesigns_tags.tag_id In (,311);'
  array()
  array()

• CORE/Cake/Model/Datasource/DboSource.php line 515 → 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 DISTINCT Count(Distinct Unit.id) AS nb FROM periods, basesigns_tags INNER JOIN (units AS Unit INNER JOIN cities_units ON Unit.id = cities_units.unit_id) ON basesigns_tags.basesign_id = Unit.basesign_id WHERE cities_units.city_id In () AND periods.period_code='x' AND periods.id In () AND Unit.start<=periods.end AND Unit.end>=periods.start AND basesigns_tags.tag_id In (,311);'

• [internal function] → DboSource->query(string)

  ' SELECT DISTINCT Count(Distinct Unit.id) AS nb FROM periods, basesigns_tags INNER JOIN (units AS Unit INNER JOIN cities_units ON Unit.id = cities_units.unit_id) ON basesigns_tags.basesign_id = Unit.basesign_id WHERE cities_units.city_id In () AND periods.period_code='x' AND periods.id In () AND Unit.start<=periods.end AND Unit.end>=periods.start AND basesigns_tags.tag_id In (,311);'

• CORE/Cake/Model/Model.php line 2992 → call_user_func_array(array, array)

      public function query($sql) {
          $params = func_get_args();
          $db = $this->getDataSource();
          return call_user_func_array(array(&$db, 'query'), $params);
      }

  array(
  	(int) 0 => object(Mysql) {},
  	(int) 1 => 'query'
  )
  array(
  	(int) 0 => ' SELECT DISTINCT Count(Distinct Unit.id) AS nb FROM periods, basesigns_tags INNER JOIN (units AS Unit INNER JOIN cities_units ON Unit.id = cities_units.unit_id) ON basesigns_tags.basesign_id = Unit.basesign_id WHERE cities_units.city_id In () AND periods.period_code='x' AND periods.id In () AND Unit.start<=periods.end AND Unit.end>=periods.start AND basesigns_tags.tag_id In (,311);'
  )

• APP/Controller/CitiesController.php line 18 → Model->query(string)

              " WHERE cities_units.city_id In (". $inAliases .")" .
  
                  " AND periods.period_code='x' AND periods.id In (". $inPeriods .") AND Unit.start<=periods.end AND Unit.end>=periods.start" .
  
                  " AND basesigns_tags.tag_id In (". $inTags .");"
  
          ));
  
          $sql = " SELECT DISTINCT Unit.*, UnitType.unit_type" .
  

  ' SELECT DISTINCT Count(Distinct Unit.id) AS nb FROM periods, basesigns_tags INNER JOIN (units AS Unit INNER JOIN cities_units ON Unit.id = cities_units.unit_id) ON basesigns_tags.basesign_id = Unit.basesign_id WHERE cities_units.city_id In () AND periods.period_code='x' AND periods.id In () AND Unit.start<=periods.end AND Unit.end>=periods.start AND basesigns_tags.tag_id In (,311);'

• APP/Controller/CitiesController.php line 143 → CitiesController->getUnits(null, null, string)

          };
  
          
  
          // Retrieve all associated units (filtered)
  
          $this->getUnits($inAliases, $inPeriods, $inTags);
  
          
  

  null
  null
  ',311'

• [internal function] → CitiesController->check_tag(string, string)

  '2504'
  '311'

• CORE/Cake/Controller/Controller.php line 488 → ReflectionMethod->invokeArgs(CitiesController, array)

                      'action' => $request->params['action']
                  ));
              }
              return $method->invokeArgs($this, $request->params['pass']);
  

  object(CitiesController) {
  	name => 'Cities'
  	uses => array(
  	)
  	helpers => array(
  	)
  	components => array(
  	)
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Cities'
  	layoutPath => null
  	viewVars => array()
  	view => 'check_tag'
  	layout => 'default'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	viewClass => 'View'
  	View => null
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array(
  	)
  	scaffold => false
  	methods => array(
  	)
  	modelClass => 'City'
  	modelKey => 'city'
  	validationErrors => null
  	Session => object(SessionComponent) {}
  	City => object(City) {}
  }
  array(
  	(int) 0 => '2504',
  	(int) 1 => '311'
  )

• CORE/Cake/Routing/Dispatcher.php line 103 → Controller->invokeAction(CakeRequest)

          $controller->startupProcess();
  
          $render = true;
          $result = $controller->invokeAction($request);
          if ($result instanceof CakeResponse) {

  object(CakeRequest) {
  	params => array(
  	)
  	data => array()
  	query => array()
  	url => 'cities/check_tag/2504/311'
  	base => '/index.php'
  	webroot => '/app/webroot/'
  	here => '/index.php/cities/check_tag/2504/311'
  }

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

              ));
          }
  
          return $this->_invoke($controller, $request, $response);
      }

  object(CitiesController) {
  	name => 'Cities'
  	uses => array(
  	)
  	helpers => array(
  	)
  	components => array(
  	)
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Cities'
  	layoutPath => null
  	viewVars => array()
  	view => 'check_tag'
  	layout => 'default'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	viewClass => 'View'
  	View => null
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array(
  	)
  	scaffold => false
  	methods => array(
  	)
  	modelClass => 'City'
  	modelKey => 'city'
  	validationErrors => null
  	Session => object(SessionComponent) {}
  	City => object(City) {}
  }
  object(CakeRequest) {
  	params => array(
  	)
  	data => array()
  	query => array()
  	url => 'cities/check_tag/2504/311'
  	base => '/index.php'
  	webroot => '/app/webroot/'
  	here => '/index.php/cities/check_tag/2504/311'
  }
  object(CakeResponse) {
  	
  }

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

      App::uses('Dispatcher', 'Routing');
  
  
  
      $Dispatcher = new Dispatcher();
  
      $Dispatcher->dispatch(new CakeRequest(), new CakeResponse(array('charset' => Configure::read('App.encoding'))));
  
  

  object(CakeRequest) {
  	params => array(
  	)
  	data => array()
  	query => array()
  	url => 'cities/check_tag/2504/311'
  	base => '/index.php'
  	webroot => '/app/webroot/'
  	here => '/index.php/cities/check_tag/2504/311'
  }
  object(CakeResponse) {
  	
  }

• ROOT/index.php line 40 → require(string)

          define('CAKE_CORE_INCLUDE_PATH', ROOT . DS . 'lib');
  
      }
  
  
  
      require APP_DIR . DS . WEBROOT_DIR . DS . 'index.php';
  
  

  '/home/clients/74c43d8ac986b47945c887bbbf8914c8/web/app/webroot/index.php'