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 basesigns_tags.tag_id=2 ORDER BY Unit.sign' at line 1
SQL Query:
SELECT DISTINCT Unit.*, UnitType.unit_type FROM basesigns_tags INNER JOIN ((unit_types AS UnitType INNER JOIN units AS Unit ON UnitType.id = Unit.unit_type_id) 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 basesigns_tags.tag_id=2 ORDER BY Unit.sign;
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 Unit.*, UnitType.unit_type FROM basesigns_tags INNER JOIN ((unit_types AS UnitType INNER JOIN units AS Unit ON UnitType.id = Unit.unit_type_id) 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 basesigns_tags.tag_id=2 ORDER BY Unit.sign;'
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 Unit.*, UnitType.unit_type FROM basesigns_tags INNER JOIN ((unit_types AS UnitType INNER JOIN units AS Unit ON UnitType.id = Unit.unit_type_id) 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 basesigns_tags.tag_id=2 ORDER BY Unit.sign;'
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 Unit.*, UnitType.unit_type FROM basesigns_tags INNER JOIN ((unit_types AS UnitType INNER JOIN units AS Unit ON UnitType.id = Unit.unit_type_id) 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 basesigns_tags.tag_id=2 ORDER BY Unit.sign;'
- [internal function] → DboSource->query(string)
' SELECT DISTINCT Unit.*, UnitType.unit_type FROM basesigns_tags INNER JOIN ((unit_types AS UnitType INNER JOIN units AS Unit ON UnitType.id = Unit.unit_type_id) 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 basesigns_tags.tag_id=2 ORDER BY Unit.sign;'
- 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 Unit.*, UnitType.unit_type FROM basesigns_tags INNER JOIN ((unit_types AS UnitType INNER JOIN units AS Unit ON UnitType.id = Unit.unit_type_id) 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 basesigns_tags.tag_id=2 ORDER BY Unit.sign;'
)
- APP/Controller/CitiesController.php line 414 → Model->query(string)
" FROM basesigns_tags INNER JOIN ((unit_types AS UnitType INNER JOIN units AS Unit ON UnitType.id = Unit.unit_type_id) 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 (". $inAliases . ") AND basesigns_tags.tag_id=" . $tag_id .
" ORDER BY Unit.sign;"
));
$this->layout = "ajax";
' SELECT DISTINCT Unit.*, UnitType.unit_type FROM basesigns_tags INNER JOIN ((unit_types AS UnitType INNER JOIN units AS Unit ON UnitType.id = Unit.unit_type_id) 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 basesigns_tags.tag_id=2 ORDER BY Unit.sign;'
- [internal function] → CitiesController->unit_by_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 => 'unit_by_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) {}
Tag => object(Tag) {}
}
array(
(int) 0 => '160',
(int) 1 => '2'
)
- 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/unit_by_tag/160/2'
base => '/index.php'
webroot => '/app/webroot/'
here => '/index.php/cities/unit_by_tag/160/2'
}
- 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 => 'unit_by_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) {}
Tag => object(Tag) {}
}
object(CakeRequest) {
params => array(
)
data => array()
query => array()
url => 'cities/unit_by_tag/160/2'
base => '/index.php'
webroot => '/app/webroot/'
here => '/index.php/cities/unit_by_tag/160/2'
}
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/unit_by_tag/160/2'
base => '/index.php'
webroot => '/app/webroot/'
here => '/index.php/cities/unit_by_tag/160/2'
}
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'