Notice (8): Undefined index: City [APP/Controller/PagesController.php, line 3051]Code Context
$this->set('title_for_layout', 'Transatour Maroc - Liste des séjours au Maroc - '.$cp['City']['name']);
$idtab = 'agences-transatour-maroc'
$idtb = array(
(int) 0 => 'agences',
(int) 1 => 'transatour',
(int) 2 => 'maroc'
)
$id = 'agences'
$cp = array()
PagesController::sejours_au_maroc_destination() - APP/Controller/PagesController.php, line 3051
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 191
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 165
[main] - APP/webroot/index.php, line 108
Database Error
Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'agences' in 'where clause'
SQL Query:
SELECT
ps.periode
FROM pack_sans_fs_site_new ps
WHERE ps.id_type_voyage = 3 and ps.id_ville = agences and ps.circuit = 0 and ps.promo = 0 GROUP BY ps.periode ORDER BY ps.periode ASC
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 458 → 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 424 → DboSource->_execute(string, array)
$options += array('log' => $this->fullDebug);
$t = microtime(true);
$this->_result = $this->_execute($sql, $params);
'SELECT
ps.periode
FROM pack_sans_fs_site_new ps
WHERE ps.id_type_voyage = 3 and ps.id_ville = agences and ps.circuit = 0 and ps.promo = 0 GROUP BY ps.periode ORDER BY ps.periode ASC'
array()
- CORE/Cake/Model/Datasource/DboSource.php line 666 → DboSource->execute(string, array, array)
if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
return $cached;
}
$result = $this->execute($sql, array(), $params);
if ($result) {
'SELECT
ps.periode
FROM pack_sans_fs_site_new ps
WHERE ps.id_type_voyage = 3 and ps.id_ville = agences and ps.circuit = 0 and ps.promo = 0 GROUP BY ps.periode ORDER BY ps.periode ASC'
array()
array()
- CORE/Cake/Model/Datasource/DboSource.php line 537 → 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
ps.periode
FROM pack_sans_fs_site_new ps
WHERE ps.id_type_voyage = 3 and ps.id_ville = agences and ps.circuit = 0 and ps.promo = 0 GROUP BY ps.periode ORDER BY ps.periode ASC'
- [internal function] → DboSource->query(string)
'SELECT
ps.periode
FROM pack_sans_fs_site_new ps
WHERE ps.id_type_voyage = 3 and ps.id_ville = agences and ps.circuit = 0 and ps.promo = 0 GROUP BY ps.periode ORDER BY ps.periode ASC'
- CORE/Cake/Model/Model.php line 3354 → 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
ps.periode
FROM pack_sans_fs_site_new ps
WHERE ps.id_type_voyage = 3 and ps.id_ville = agences and ps.circuit = 0 and ps.promo = 0 GROUP BY ps.periode ORDER BY ps.periode ASC'
)
- APP/Controller/PagesController.php line 3063 → Model->query(string)
WHERE ps.id_type_voyage = 3 and ps.id_ville = ".$id." and ps.circuit = 0 and ps.promo = 0 GROUP BY ps.periode ORDER BY ps.periode ASC";
$persejmar = $this->Package->query($sqlper);
'SELECT
ps.periode
FROM pack_sans_fs_site_new ps
WHERE ps.id_type_voyage = 3 and ps.id_ville = agences and ps.circuit = 0 and ps.promo = 0 GROUP BY ps.periode ORDER BY ps.periode ASC'
- [internal function] → PagesController->sejours_au_maroc_destination(string)
'agences-transatour-maroc'
- CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(PagesController, array)
'action' => $request->params['action']
));
}
return $method->invokeArgs($this, $request->params['pass']);
object(PagesController) {
uses => array(
[maximum depth reached]
)
name => 'Pages'
helpers => array([maximum depth reached])
request => object(CakeRequest) {}
response => object(CakeResponse) {}
viewPath => 'Pages'
layoutPath => null
viewVars => array(
[maximum depth reached]
)
view => 'sejours_au_maroc_destination'
layout => 'default'
autoRender => true
autoLayout => true
Components => object(ComponentCollection) {}
components => array(
[maximum depth reached]
)
viewClass => 'View'
View => null
ext => '.ctp'
plugin => null
cacheAction => false
passedArgs => array(
[maximum depth reached]
)
scaffold => false
methods => array(
[maximum depth reached]
)
modelClass => 'Page'
modelKey => 'page'
validationErrors => null
Session => object(SessionComponent) {}
Package => object(Package) {}
Photo => object(Photo) {}
City => object(City) {}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {}
}
array(
(int) 0 => 'agences-transatour-maroc'
)
- CORE/Cake/Routing/Dispatcher.php line 191 → Controller->invokeAction(CakeRequest)
$response = $controller->response;
$render = true;
$result = $controller->invokeAction($request);
if ($result instanceof CakeResponse) {
object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'transatour-maroc-liste-sejours-maroc-ville/agences-transatour-maroc'
base => ''
webroot => '/'
here => '/transatour-maroc-liste-sejours-maroc-ville/agences-transatour-maroc'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}
- CORE/Cake/Routing/Dispatcher.php line 165 → Dispatcher->_invoke(PagesController, CakeRequest)
));
}
$response = $this->_invoke($controller, $request);
if (isset($request->params['return'])) {
object(PagesController) {
uses => array(
[maximum depth reached]
)
name => 'Pages'
helpers => array([maximum depth reached])
request => object(CakeRequest) {}
response => object(CakeResponse) {}
viewPath => 'Pages'
layoutPath => null
viewVars => array(
[maximum depth reached]
)
view => 'sejours_au_maroc_destination'
layout => 'default'
autoRender => true
autoLayout => true
Components => object(ComponentCollection) {}
components => array(
[maximum depth reached]
)
viewClass => 'View'
View => null
ext => '.ctp'
plugin => null
cacheAction => false
passedArgs => array(
[maximum depth reached]
)
scaffold => false
methods => array(
[maximum depth reached]
)
modelClass => 'Page'
modelKey => 'page'
validationErrors => null
Session => object(SessionComponent) {}
Package => object(Package) {}
Photo => object(Photo) {}
City => object(City) {}
[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 => 'transatour-maroc-liste-sejours-maroc-ville/agences-transatour-maroc'
base => ''
webroot => '/'
here => '/transatour-maroc-liste-sejours-maroc-ville/agences-transatour-maroc'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}
- APP/webroot/index.php line 108 → 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 => 'transatour-maroc-liste-sejours-maroc-ville/agences-transatour-maroc'
base => ''
webroot => '/'
here => '/transatour-maroc-liste-sejours-maroc-ville/agences-transatour-maroc'
[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] _fileRange => null
[protected] _charset => 'UTF-8'
[protected] _cacheDirectives => array([maximum depth reached])
[protected] _cookies => array([maximum depth reached])
}