Errors

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;

array()

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])
}