CakePHP: the rapid development php framework: Errors

Warning (2): Missing argument 1 for PagesController::display() [APP/Controller/PagesController.php, line 100]

Code Context

     * @param string $alias : slug
     */
    public function display($alias) {

PagesController::display() - APP/Controller/PagesController.php, line 100
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 188
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 114

Notice (8): Undefined variable: alias [APP/Controller/PagesController.php, line 104]

Code Context

        // Informations sur la page
        $conditions = array(
            'Page.i18n_alias' => $alias,

PagesController::display() - APP/Controller/PagesController.php, line 104
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 188
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 114

Notice (8): Undefined index: Page [APP/Controller/AppController.php, line 120]

Code Context

        // Balises métas
        $metas = array(
            "title" => (!empty($title)) ? $title: $page['Page']['meta_title'],

$conditions = array(
	'Page.i18n_alias' => null,
	'Page.active' => (int) 1,
	'Page.home' => (int) 0
)
$title = null
$description = null
$page = array()

AppController::constructPage() - APP/Controller/AppController.php, line 120
PagesController::display() - APP/Controller/PagesController.php, line 108
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 188
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 114

Notice (8): Undefined index: Page [APP/Controller/AppController.php, line 121]

Code Context

        $metas = array(
            "title" => (!empty($title)) ? $title: $page['Page']['meta_title'],
            "description" => (!empty($description)) ? $description: $page['Page']['meta_description']

$conditions = array(
	'Page.i18n_alias' => null,
	'Page.active' => (int) 1,
	'Page.home' => (int) 0
)
$title = null
$description = null
$page = array()

AppController::constructPage() - APP/Controller/AppController.php, line 121
PagesController::display() - APP/Controller/PagesController.php, line 108
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 188
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 114

Notice (8): Undefined index: Page [APP/Controller/AppController.php, line 125]

Code Context

        
        // Menus
        $menus = $this->affichageMenu($page['Page']['id']);

$conditions = array(
	'Page.i18n_alias' => null,
	'Page.active' => (int) 1,
	'Page.home' => (int) 0
)
$title = null
$description = null
$page = array()
$metas = array(
	'title' => null,
	'description' => null
)

AppController::constructPage() - APP/Controller/AppController.php, line 125
PagesController::display() - APP/Controller/PagesController.php, line 108
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 188
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 114

Notice (8): Undefined index: Page [APP/Controller/AppController.php, line 128]

Code Context

        
        // Fil d'ariane
        $breadcrumb = $this->Page->getPath($page['Page']['id']);

$conditions = array(
	'Page.i18n_alias' => null,
	'Page.active' => (int) 1,
	'Page.home' => (int) 0
)
$title = null
$description = null
$page = array()
$metas = array(
	'title' => null,
	'description' => null
)
$menus = '
<ul class='nav nav-pills pull-right main'>
<li><a href="/fra/pages/accueil" class="">Accueil</a></li>
<li><a href="/fra" class="">Qui sommes-nous ?</a></li>
<li><a href="/fra/pages/nos-produits" class="">Nos produits</a>
<ul class='nav nav-pills pull-right'>
<li><a href="/fra/pages/films-solaires" class="">Films solaires</a></li>
<li><a href="/fra/pages/films-de-securite" class="">Films de sécurité</a></li>
<li><a href="/fra/pages/films-occultants" class="">Films occultants</a></li>
</ul>
</li>
<li><a href="/fra/pro/" class="">Nos références</a></li>
<li><a href="/fra/pages/bien-choisir-et-poser-son-film" class="">Bien choisir et poser son film</a></li>
</ul>
'

AppController::constructPage() - APP/Controller/AppController.php, line 128
PagesController::display() - APP/Controller/PagesController.php, line 108
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 188
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 114

Notice (8): Undefined index: aliasTranslations [APP/Controller/AppController.php, line 149]

Code Context

        
        // Page dans les autres langues
        $versions = $this->formatVersions($page['aliasTranslations']);

$conditions = array(
	'Page.i18n_alias' => null,
	'Page.active' => (int) 1,
	'Page.home' => (int) 0
)
$title = null
$description = null
$page = array()
$metas = array(
	'title' => null,
	'description' => null
)
$menus = '
<ul class='nav nav-pills pull-right main'>
<li><a href="/fra/pages/accueil" class="">Accueil</a></li>
<li><a href="/fra" class="">Qui sommes-nous ?</a></li>
<li><a href="/fra/pages/nos-produits" class="">Nos produits</a>
<ul class='nav nav-pills pull-right'>
<li><a href="/fra/pages/films-solaires" class="">Films solaires</a></li>
<li><a href="/fra/pages/films-de-securite" class="">Films de sécurité</a></li>
<li><a href="/fra/pages/films-occultants" class="">Films occultants</a></li>
</ul>
</li>
<li><a href="/fra/pro/" class="">Nos références</a></li>
<li><a href="/fra/pages/bien-choisir-et-poser-son-film" class="">Bien choisir et poser son film</a></li>
</ul>
'
$breadcrumb = null
$annexes = array(
	(int) 0 => array(
		'Page' => array(
			'specific_url' => '/pages/contact',
			'home' => false,
			'locale' => 'fra',
			'name' => 'Etude personnalisée - Contactez-nous',
			'alias' => 'etude-personnalisee-contactez-nous'
		)
	),
	(int) 1 => array(
		'Page' => array(
			'specific_url' => '/pages/sitemap/',
			'home' => false,
			'locale' => 'fra',
			'name' => 'Plan du site',
			'alias' => 'plan-du-site'
		)
	),
	(int) 2 => array(
		'Page' => array(
			'specific_url' => '',
			'home' => false,
			'locale' => 'fra',
			'name' => 'Mentions légales',
			'alias' => 'mentions-legales'
		)
	)
)

AppController::constructPage() - APP/Controller/AppController.php, line 149
PagesController::display() - APP/Controller/PagesController.php, line 108
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 188
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 114

Warning (2): Invalid argument supplied for foreach() [APP/Controller/AppController.php, line 248]

Code Context

        
        $versions = array();
        foreach($translations as $translation):

$translations = null
$versions = array()

AppController::formatVersions() - APP/Controller/AppController.php, line 248
AppController::constructPage() - APP/Controller/AppController.php, line 149
PagesController::display() - APP/Controller/PagesController.php, line 108
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 188
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 114

Notice (8): Undefined index: Layout [APP/Controller/PagesController.php, line 110]

Code Context

        $constructPage = $this->constructPage($conditions);
        $this->set($constructPage);
        $this->render('/Elements/Layouts/Site/site-'.$constructPage['page']['Layout']['name']); // On affiche le bon template

$conditions = array(
	'Page.i18n_alias' => null,
	'Page.active' => (int) 1,
	'Page.home' => (int) 0
)
$constructPage = array(
	'page' => array(),
	'metas' => array(
		'title' => null,
		'description' => null
	),
	'menus' => '
<ul class='nav nav-pills pull-right main'>
<li><a href="/fra/pages/accueil" class="">Accueil</a></li>
<li><a href="/fra" class="">Qui sommes-nous ?</a></li>
<li><a href="/fra/pages/nos-produits" class="">Nos produits</a>
<ul class='nav nav-pills pull-right'>
<li><a href="/fra/pages/films-solaires" class="">Films solaires</a></li>
<li><a href="/fra/pages/films-de-securite" class="">Films de sécurité</a></li>
<li><a href="/fra/pages/films-occultants" class="">Films occultants</a></li>
</ul>
</li>
<li><a href="/fra/pro/" class="">Nos références</a></li>
<li><a href="/fra/pages/bien-choisir-et-poser-son-film" class="">Bien choisir et poser son film</a></li>
</ul>
',
	'breadcrumb' => null,
	'versions' => array(),
	'annexes' => array(
		(int) 0 => array(
			'Page' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Page' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'Page' => array(
				[maximum depth reached]
			)
		)
	)
)

PagesController::display() - APP/Controller/PagesController.php, line 110
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 188
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 114

Missing View

Error: The view for PagesController::display() was not found.

Error: Confirm you have created the file: /srv/D_art1/www/clients/client6/web22/web/app/View/Elements/Layouts/Site/site-.ctp

Notice: If you want to customize this error message, create app/View/Errors/missing_view.ctp

Stack Trace

CORE/Cake/View/View.php line 468 → View->_getViewFileName(string)

        }
        $this->Blocks->set('content', '');

        if ($view !== false && $viewFileName = $this->_getViewFileName($view)) {
            $this->_currentType = self::TYPE_VIEW;

'/Elements/Layouts/Site/site-'

CORE/Cake/Controller/Controller.php line 952 → View->render(string, null)

        }

        $this->autoRender = false;
        $this->response->body($this->View->render($view, $layout));
        return $this->response;

'/Elements/Layouts/Site/site-'
null

APP/Controller/PagesController.php line 110 → Controller->render(string)

        );
        $constructPage = $this->constructPage($conditions);
        $this->set($constructPage);
        $this->render('/Elements/Layouts/Site/site-'.$constructPage['page']['Layout']['name']); // On affiche le bon template

'/Elements/Layouts/Site/site-'

[internal function] → PagesController->display()

CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(PagesController, array)

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

object(PagesController) {
	helpers => array(
		[maximum depth reached]
	)
	components => array(
		[maximum depth reached]
	)
	name => 'Pages'
	uses => array(
		[maximum depth reached]
	)
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Pages'
	layoutPath => null
	viewVars => array(
		[maximum depth reached]
	)
	view => 'display'
	layout => 'default'
	autoRender => false
	autoLayout => true
	Components => object(ComponentCollection) {}
	viewClass => 'View'
	View => object(View) {}
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array([maximum depth reached])
	scaffold => false
	methods => array(
		[maximum depth reached]
	)
	modelClass => 'Page'
	modelKey => 'page'
	validationErrors => null
	RequestHandler => object(RequestHandlerComponent) {}
	Cookie => object(CookieComponent) {}
	Session => object(SessionComponent) {}
	Security => object(SecurityComponent) {}
	Auth => object(AuthComponent) {}
	Page => object(Page) {}
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {}
}
array()

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

        $controller->startupProcess();

        $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 => 'fra/pages'
	base => ''
	webroot => '/'
	here => '/fra/pages'
	[protected] _detectors => array(
		[maximum depth reached]
	)
	[protected] _input => ''
}

CORE/Cake/Routing/Dispatcher.php line 162 → Dispatcher->_invoke(PagesController, CakeRequest, CakeResponse)

            ));
        }

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

object(PagesController) {
	helpers => array(
		[maximum depth reached]
	)
	components => array(
		[maximum depth reached]
	)
	name => 'Pages'
	uses => array(
		[maximum depth reached]
	)
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Pages'
	layoutPath => null
	viewVars => array(
		[maximum depth reached]
	)
	view => 'display'
	layout => 'default'
	autoRender => false
	autoLayout => true
	Components => object(ComponentCollection) {}
	viewClass => 'View'
	View => object(View) {}
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array([maximum depth reached])
	scaffold => false
	methods => array(
		[maximum depth reached]
	)
	modelClass => 'Page'
	modelKey => 'page'
	validationErrors => null
	RequestHandler => object(RequestHandlerComponent) {}
	Cookie => object(CookieComponent) {}
	Session => object(SessionComponent) {}
	Security => object(SecurityComponent) {}
	Auth => object(AuthComponent) {}
	Page => object(Page) {}
	[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 => 'fra/pages'
	base => ''
	webroot => '/'
	here => '/fra/pages'
	[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])
}

APP/webroot/index.php line 114 → 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 => 'fra/pages'
	base => ''
	webroot => '/'
	here => '/fra/pages'
	[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])
}

(default) 5 queries took 2 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`home`, `Page`.`specific_url`, `Layout`.`name`, (`I18n__alias`.`content`) AS `Page__i18n_alias`, (`I18n__meta_title`.`content`) AS `Page__i18n_meta_title`, (`I18n__meta_description`.`content`) AS `Page__i18n_meta_description` FROM `altec`.`pages` AS `Page` INNER JOIN `altec`.`i18n` AS `I18n__alias` ON (`Page`.`id` = `I18n__alias`.`foreign_key` AND `I18n__alias`.`model` = 'Page' AND `I18n__alias`.`field` = 'alias' AND `I18n__alias`.`locale` = 'fra') INNER JOIN `altec`.`i18n` AS `I18n__meta_title` ON (`Page`.`id` = `I18n__meta_title`.`foreign_key` AND `I18n__meta_title`.`model` = 'Page' AND `I18n__meta_title`.`field` = 'meta_title' AND `I18n__meta_title`.`locale` = 'fra') INNER JOIN `altec`.`i18n` AS `I18n__meta_description` ON (`Page`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'Page' AND `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'fra') LEFT JOIN `altec`.`layouts` AS `Layout` ON (`Page`.`layout_id` = `Layout`.`id`) WHERE (`I18n__alias`.`content`) IS NULL AND `Page`.`active` = '1' AND `Page`.`home` = '0' LIMIT 1	0	0	2
2	SELECT `Page`.`parent_id`, `Page`.`home`, `Page`.`specific_url`, (`I18n__name`.`content`) AS `Page__i18n_name`, (`I18n__alias`.`content`) AS `Page__i18n_alias`, `Page`.`id` FROM `altec`.`pages` AS `Page` INNER JOIN `altec`.`i18n` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fra') INNER JOIN `altec`.`i18n` AS `I18n__alias` ON (`Page`.`id` = `I18n__alias`.`foreign_key` AND `I18n__alias`.`model` = 'Page' AND `I18n__alias`.`field` = 'alias' AND `I18n__alias`.`locale` = 'fra') LEFT JOIN `altec`.`layouts` AS `Layout` ON (`Page`.`layout_id` = `Layout`.`id`) WHERE `Page`.`active` = '1' AND `Page`.`menu` = '1' ORDER BY `Page`.`lft` ASC	8	8	0
3	SELECT `Page`.`lft`, `Page`.`rght` FROM `altec`.`pages` AS `Page` WHERE `Page`.`id` = '' LIMIT 1	0	0	0
4	SELECT `Page`.`lft`, `Page`.`rght` FROM `altec`.`pages` AS `Page` WHERE `Page`.`id` = '' LIMIT 1	0	0	0
5	SELECT `Page`.`specific_url`, `Page`.`home`, (`I18n__name`.`content`) AS `Page__i18n_name`, (`I18n__alias`.`content`) AS `Page__i18n_alias` FROM `altec`.`pages` AS `Page` INNER JOIN `altec`.`i18n` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fra') INNER JOIN `altec`.`i18n` AS `I18n__alias` ON (`Page`.`id` = `I18n__alias`.`foreign_key` AND `I18n__alias`.`model` = 'Page' AND `I18n__alias`.`field` = 'alias' AND `I18n__alias`.`locale` = 'fra') WHERE ((((`Page`.`menu` = '0') AND (`Page`.`active` = '1'))) OR (`Page`.`alias` = 'contact')) ORDER BY `Page`.`lft` ASC	3	3	0

(default) 5 queries took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`home`, `Page`.`specific_url`, `Layout`.`name`, (`I18n__alias`.`content`) AS `Page__i18n_alias`, (`I18n__meta_title`.`content`) AS `Page__i18n_meta_title`, (`I18n__meta_description`.`content`) AS `Page__i18n_meta_description` FROM `altec`.`pages` AS `Page` INNER JOIN `altec`.`i18n` AS `I18n__alias` ON (`Page`.`id` = `I18n__alias`.`foreign_key` AND `I18n__alias`.`model` = 'Page' AND `I18n__alias`.`field` = 'alias' AND `I18n__alias`.`locale` = 'fra') INNER JOIN `altec`.`i18n` AS `I18n__meta_title` ON (`Page`.`id` = `I18n__meta_title`.`foreign_key` AND `I18n__meta_title`.`model` = 'Page' AND `I18n__meta_title`.`field` = 'meta_title' AND `I18n__meta_title`.`locale` = 'fra') INNER JOIN `altec`.`i18n` AS `I18n__meta_description` ON (`Page`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'Page' AND `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'fra') LEFT JOIN `altec`.`layouts` AS `Layout` ON (`Page`.`layout_id` = `Layout`.`id`) WHERE (`I18n__alias`.`content`) IS NULL AND `Page`.`active` = '1' AND `Page`.`home` = '0' LIMIT 1

SELECT `Page`.`parent_id`, `Page`.`home`, `Page`.`specific_url`, (`I18n__name`.`content`) AS `Page__i18n_name`, (`I18n__alias`.`content`) AS `Page__i18n_alias`, `Page`.`id` FROM `altec`.`pages` AS `Page` INNER JOIN `altec`.`i18n` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fra') INNER JOIN `altec`.`i18n` AS `I18n__alias` ON (`Page`.`id` = `I18n__alias`.`foreign_key` AND `I18n__alias`.`model` = 'Page' AND `I18n__alias`.`field` = 'alias' AND `I18n__alias`.`locale` = 'fra') LEFT JOIN `altec`.`layouts` AS `Layout` ON (`Page`.`layout_id` = `Layout`.`id`) WHERE `Page`.`active` = '1' AND `Page`.`menu` = '1' ORDER BY `Page`.`lft` ASC

SELECT `Page`.`lft`, `Page`.`rght` FROM `altec`.`pages` AS `Page` WHERE `Page`.`id` = '' LIMIT 1

SELECT `Page`.`specific_url`, `Page`.`home`, (`I18n__name`.`content`) AS `Page__i18n_name`, (`I18n__alias`.`content`) AS `Page__i18n_alias` FROM `altec`.`pages` AS `Page` INNER JOIN `altec`.`i18n` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fra') INNER JOIN `altec`.`i18n` AS `I18n__alias` ON (`Page`.`id` = `I18n__alias`.`foreign_key` AND `I18n__alias`.`model` = 'Page' AND `I18n__alias`.`field` = 'alias' AND `I18n__alias`.`locale` = 'fra') WHERE ((((`Page`.`menu` = '0') AND (`Page`.`active` = '1'))) OR (`Page`.`alias` = 'contact')) ORDER BY `Page`.`lft` ASC