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;
- 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);
- [internal function] → CitiesController->check_tag(string, string)
- 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'