CakePHP: the rapid development php framework: Errors

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

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

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

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

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

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' => 'information',
	'Page.active' => (int) 1,
	'Page.home' => (int) 0
)
$title = null
$description = null
$page = array()

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

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

Code Context

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

$conditions = array(
	'Page.i18n_alias' => 'information',
	'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 159
PagesController::display() - APP/Controller/PagesController.php, line 133
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 110

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

Code Context

        $pageVersions = $this->Page->find('first', array(
            'conditions' => array(
                'Page.id' => $page['Page']['id']

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

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

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

Code Context

            'fields' => array('Page.alias')
        ));
        $versions = $this->formatVersions($pageVersions['aliasTranslations']);

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

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

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

Code Context


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

$translations = null
$versions = array()

AppController::formatVersions() - APP/Controller/AppController.php, line 343
AppController::constructPage() - APP/Controller/AppController.php, line 192
PagesController::display() - APP/Controller/PagesController.php, line 133
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 110

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

Code Context

         */
        // Page intérieure/article
        if ($constructPage['page']['Layout']['name'] === 'interieur') {

$alias = 'information'
$conditions = array(
	'Page.i18n_alias' => 'information',
	'Page.active' => (int) 1,
	'Page.home' => (int) 0
)
$constructPage = array(
	'page' => array(),
	'metas' => array(
		'title' => null,
		'description' => null
	),
	'breadcrumb' => null,
	'versions' => array(),
	'back' => array(
		'controller' => 'pages',
		'action' => 'index'
	)
)

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

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

Code Context

        }
        // Liste de liens vers des pages internes
        else if ($constructPage['page']['Layout']['name'] === 'liste') {

$alias = 'information'
$conditions = array(
	'Page.i18n_alias' => 'information',
	'Page.active' => (int) 1,
	'Page.home' => (int) 0
)
$constructPage = array(
	'page' => array(),
	'metas' => array(
		'title' => null,
		'description' => null
	),
	'breadcrumb' => null,
	'versions' => array(),
	'back' => array(
		'controller' => 'pages',
		'action' => 'index'
	)
)

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

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

Code Context

        }

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

$alias = 'information'
$conditions = array(
	'Page.i18n_alias' => 'information',
	'Page.active' => (int) 1,
	'Page.home' => (int) 0
)
$constructPage = array(
	'page' => array(),
	'metas' => array(
		'title' => null,
		'description' => null
	),
	'breadcrumb' => null,
	'versions' => array(),
	'back' => array(
		'controller' => 'pages',
		'action' => 'index'
	)
)

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

Missing View

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

Error: Confirm you have created the file: /srv/D_art1/www/clients/client22/web38/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 181 → Controller->render(string)

            ));
        }

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

'/Elements/Layouts/Site/site-'

[internal function] → PagesController->display(string)
```
'information'
```

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]
	)
	_jsVars => 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) {}
	Auth => object(AuthComponent) {}
	Page => object(Page) {}
	Partner => object(Partner) {}
	Tag => object(Tag) {}
	[protected] _homepage => null
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {}
}
array(
	(int) 0 => 'information'
)

CORE/Cake/Routing/Dispatcher.php line 187 → 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 => 'eng/pages/information'
	base => ''
	webroot => '/'
	here => '/eng/pages/information'
	[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);
        if (isset($request->params['return'])) {

object(PagesController) {
	helpers => array(
		[maximum depth reached]
	)
	_jsVars => 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) {}
	Auth => object(AuthComponent) {}
	Page => object(Page) {}
	Partner => object(Partner) {}
	Tag => object(Tag) {}
	[protected] _homepage => null
	[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 => 'eng/pages/information'
	base => ''
	webroot => '/'
	here => '/eng/pages/information'
	[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 110 → 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 => 'eng/pages/information'
	base => ''
	webroot => '/'
	here => '/eng/pages/information'
	[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) 15 queries took 42 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`home`, `Page`.`specific_url`, `Layout`.`name`, `Page`.`thumbnail`, `Layout`.`id`, (`I18n__name`.`content`) AS `Page__i18n_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 `varrains`.`pages` AS `Page` INNER JOIN `varrains`.`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` = 'eng') INNER JOIN `varrains`.`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` = 'eng') INNER JOIN `varrains`.`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` = 'eng') INNER JOIN `varrains`.`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` = 'eng') LEFT JOIN `varrains`.`layouts` AS `Layout` ON (`Page`.`layout_id` = `Layout`.`id`) WHERE (`I18n__alias`.`content`) = 'information' AND `Page`.`active` = '1' AND `Page`.`home` = '0' LIMIT 1	0	0	42
2	SELECT `Page`.`lft`, `Page`.`rght` FROM `varrains`.`pages` AS `Page` WHERE `Page`.`id` = '' LIMIT 1	0	0	0
3	SELECT `Page`.`id`, `Page`.`name`, `Page`.`alias`, `Page`.`parent_id`, `Page`.`layout_id`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`lft`, `Page`.`rght`, `Page`.`active`, `Page`.`menu`, `Page`.`home`, `Page`.`book`, `Page`.`list`, `Page`.`specific`, `Page`.`specific_url`, `Page`.`chapeau`, `Page`.`thumbnail`, `Page`.`page_type_id`, (`I18n__alias`.`content`) AS `Page__i18n_alias`, `Layout`.`id`, `Layout`.`name`, `Layout`.`libelle` FROM `varrains`.`pages` AS `Page` INNER JOIN `varrains`.`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` = 'eng') LEFT JOIN `varrains`.`layouts` AS `Layout` ON (`Page`.`layout_id` = `Layout`.`id`) WHERE `Page`.`id` IS NULL LIMIT 1	0	0	0
4	SELECT `Partner`.`logo`, `Partner`.`url`, (`I18n__name`.`content`) AS `Partner__i18n_name`, `Partner`.`id` FROM `varrains`.`partners` AS `Partner` INNER JOIN `varrains`.`i18n` AS `I18n__name` ON (`Partner`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Partner' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `Partner`.`rang` ASC	1	1	0
5	SELECT `nameTranslations`.`id`, `nameTranslations`.`locale`, `nameTranslations`.`model`, `nameTranslations`.`foreign_key`, `nameTranslations`.`field`, `nameTranslations`.`content` FROM `varrains`.`i18n` AS `nameTranslations` WHERE `model` = 'Partner' AND `field` = 'name' AND `nameTranslations`.`foreign_key` = (1)	2	2	0
6	SELECT `Page`.`alias` FROM `varrains`.`pages` AS `Page` WHERE `book` = '1' LIMIT 1	0	0	0
7	SELECT `Tag`.`slug`, (`I18n__name`.`content`) AS `Tag__i18n_name` FROM `varrains`.`tags` AS `Tag` INNER JOIN `varrains`.`i18n` AS `I18n__name` ON (`Tag`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Tag' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE `Tag`.`type` = 'theme' ORDER BY `Tag`.`name` ASC	0	0	0
8	SELECT `Tag`.`slug`, (`I18n__name`.`content`) AS `Tag__i18n_name` FROM `varrains`.`tags` AS `Tag` INNER JOIN `varrains`.`i18n` AS `I18n__name` ON (`Tag`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Tag' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE `Tag`.`type` = 'day' ORDER BY `Tag`.`name` ASC	0	0	0
9	SELECT `Tag`.`slug`, (`I18n__name`.`content`) AS `Tag__i18n_name` FROM `varrains`.`tags` AS `Tag` INNER JOIN `varrains`.`i18n` AS `I18n__name` ON (`Tag`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Tag' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE `Tag`.`type` = 'place' ORDER BY `Tag`.`name` ASC	0	0	0
10	SELECT `Partner`.`logo`, `Partner`.`url`, (`I18n__name`.`content`) AS `Partner__i18n_name`, `Partner`.`id` FROM `varrains`.`partners` AS `Partner` INNER JOIN `varrains`.`i18n` AS `I18n__name` ON (`Partner`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Partner' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `Partner`.`rang` ASC	1	1	0
11	SELECT `nameTranslations`.`id`, `nameTranslations`.`locale`, `nameTranslations`.`model`, `nameTranslations`.`foreign_key`, `nameTranslations`.`field`, `nameTranslations`.`content` FROM `varrains`.`i18n` AS `nameTranslations` WHERE `model` = 'Partner' AND `field` = 'name' AND `nameTranslations`.`foreign_key` = (1)	2	2	0
12	SELECT `Page`.`alias` FROM `varrains`.`pages` AS `Page` WHERE `book` = '1' LIMIT 1	0	0	0
13	SELECT `Tag`.`slug`, (`I18n__name`.`content`) AS `Tag__i18n_name` FROM `varrains`.`tags` AS `Tag` INNER JOIN `varrains`.`i18n` AS `I18n__name` ON (`Tag`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Tag' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE `Tag`.`type` = 'theme' ORDER BY `Tag`.`name` ASC	0	0	0
14	SELECT `Tag`.`slug`, (`I18n__name`.`content`) AS `Tag__i18n_name` FROM `varrains`.`tags` AS `Tag` INNER JOIN `varrains`.`i18n` AS `I18n__name` ON (`Tag`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Tag' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE `Tag`.`type` = 'day' ORDER BY `Tag`.`name` ASC	0	0	0
15	SELECT `Tag`.`slug`, (`I18n__name`.`content`) AS `Tag__i18n_name` FROM `varrains`.`tags` AS `Tag` INNER JOIN `varrains`.`i18n` AS `I18n__name` ON (`Tag`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Tag' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE `Tag`.`type` = 'place' ORDER BY `Tag`.`name` ASC	0	0	0

(default) 15 queries took 42 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`home`, `Page`.`specific_url`, `Layout`.`name`, `Page`.`thumbnail`, `Layout`.`id`, (`I18n__name`.`content`) AS `Page__i18n_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 `varrains`.`pages` AS `Page` INNER JOIN `varrains`.`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` = 'eng') INNER JOIN `varrains`.`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` = 'eng') INNER JOIN `varrains`.`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` = 'eng') INNER JOIN `varrains`.`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` = 'eng') LEFT JOIN `varrains`.`layouts` AS `Layout` ON (`Page`.`layout_id` = `Layout`.`id`) WHERE (`I18n__alias`.`content`) = 'information' AND `Page`.`active` = '1' AND `Page`.`home` = '0' LIMIT 1

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

SELECT `Page`.`id`, `Page`.`name`, `Page`.`alias`, `Page`.`parent_id`, `Page`.`layout_id`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`lft`, `Page`.`rght`, `Page`.`active`, `Page`.`menu`, `Page`.`home`, `Page`.`book`, `Page`.`list`, `Page`.`specific`, `Page`.`specific_url`, `Page`.`chapeau`, `Page`.`thumbnail`, `Page`.`page_type_id`, (`I18n__alias`.`content`) AS `Page__i18n_alias`, `Layout`.`id`, `Layout`.`name`, `Layout`.`libelle` FROM `varrains`.`pages` AS `Page` INNER JOIN `varrains`.`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` = 'eng') LEFT JOIN `varrains`.`layouts` AS `Layout` ON (`Page`.`layout_id` = `Layout`.`id`) WHERE `Page`.`id` IS NULL LIMIT 1

SELECT `Partner`.`logo`, `Partner`.`url`, (`I18n__name`.`content`) AS `Partner__i18n_name`, `Partner`.`id` FROM `varrains`.`partners` AS `Partner` INNER JOIN `varrains`.`i18n` AS `I18n__name` ON (`Partner`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Partner' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `Partner`.`rang` ASC

SELECT `nameTranslations`.`id`, `nameTranslations`.`locale`, `nameTranslations`.`model`, `nameTranslations`.`foreign_key`, `nameTranslations`.`field`, `nameTranslations`.`content` FROM `varrains`.`i18n` AS `nameTranslations` WHERE `model` = 'Partner' AND `field` = 'name' AND `nameTranslations`.`foreign_key` = (1)

SELECT `Page`.`alias` FROM `varrains`.`pages` AS `Page` WHERE `book` = '1' LIMIT 1

SELECT `Tag`.`slug`, (`I18n__name`.`content`) AS `Tag__i18n_name` FROM `varrains`.`tags` AS `Tag` INNER JOIN `varrains`.`i18n` AS `I18n__name` ON (`Tag`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Tag' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE `Tag`.`type` = 'theme' ORDER BY `Tag`.`name` ASC

SELECT `Page`.`alias` FROM `varrains`.`pages` AS `Page` WHERE `book` = '1' LIMIT 1