Error: Database Error

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php toggle arguments

	`$connection = $this->_driver->connection();`

	`try {`
	`$connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, $this->_bufferResults);`
	`$result = $this->_statement->execute($params);`
	`} finally {`
	`$connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);`
	`}`

null

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/vendor/cakephp/cakephp/src/Database/Connection.php toggle arguments

	`public function run(Query $query)`
	`{`
	`$statement = $this->prepare($query);`
	`$query->valueBinder()->attachTo($statement);`
	`$statement->execute();`

	`return $statement;`
	`}`

No arguments

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/vendor/cakephp/cakephp/src/Database/Query.php toggle arguments

	`* @return \Cake\Database\StatementInterface`
	`*/`
	`public function execute()`
	`{`
	`$statement = $this->_connection->run($this);`
	`$driver = $this->_connection->driver();`
	`$typeMap = $this->getSelectTypeMap();`

	`if ($typeMap->toArray() && $this->_typeCastAttached === false) {`

object(Cake\ORM\Query) {

	'(help)' => 'This is a Query object, to get the results execute or iterate it.',
	'sql' => 'SELECT Annonces.id AS `Annonces__id`, Annonces.astatut_id AS `Annonces__astatut_id`, Annonces.ref AS `Annonces__ref`, Annonces.created AS `Annonces__created`, Annonces.titre AS `Annonces__titre`, Annonces.description AS `Annonces__description`, Annonces.nom AS `Annonces__nom`, Annonces.telephone AS `Annonces__telephone`, Annonces.masquer_telephone AS `Annonces__masquer_telephone`, Annonces.email AS `Annonces__email`, Annonces.prix AS `Annonces__prix`, Annonces.statut AS `Annonces__statut`, Annonces.edit AS `Annonces__edit`, Annonces.activation_code AS `Annonces__activation_code`, Annonces.active AS `Annonces__active`, Annonces.pass AS `Annonces__pass`, Annonces.member_delete AS `Annonces__member_delete`, Annonces.member_delete_raison AS `Annonces__member_delete_raison`, Annonces.category_id AS `Annonces__category_id`, Annonces.region_id AS `Annonces__region_id`, Annonces.renew_code AS `Annonces__renew_code`, Annonces.renew_date AS `Annonces__renew_date`, Annonces.ip AS `Annonces__ip`, Annonces.slug AS `Annonces__slug`, Annonces.commune_id AS `Annonces__commune_id`, Annonces.aimage_count AS `Annonces__aimage_count`, Annonces.acontact_count AS `Annonces__acontact_count`, Annonces.sharing_count AS `Annonces__sharing_count`, Annonces.sarnaque_count AS `Annonces__sarnaque_count`, Annonces.member_id AS `Annonces__member_id`, Annonces.admin_notifie AS `Annonces__admin_notifie`, Annonces.noindex AS `Annonces__noindex`, Annonces.refall AS `Annonces__refall`, Annonces.tag_selection_1 AS `Annonces__tag_selection_1`, Annonces.type AS `Annonces__type`, Annonces.type_annonceur AS `Annonces__type_annonceur`, Annonces.date_validation AS `Annonces__date_validation`, Annonces.date_publication AS `Annonces__date_publication`, Annonces.date_edition AS `Annonces__date_edition`, Annonces.tag_logo_urgent AS `Annonces__tag_logo_urgent`, Annonces.nbr_view_aujourdhui AS `Annonces__nbr_view_aujourdhui`, Annonces.nbr_affichage_1 AS `Annonces__nbr_affichage_1`, Annonces.nbr_affichage_1_total AS `Annonces__nbr_affichage_1_total`, Annonces.nbr_view_total AS `Annonces__nbr_view_total`, Annonces.lu AS `Annonces__lu`, Annonces.mail_activation_envoye AS `Annonces__mail_activation_envoye`, Annonces.mail_act_renvoye AS `Annonces__mail_act_renvoye`, Annonces.mail_enligne_envoye AS `Annonces__mail_enligne_envoye`, Annonces.mail_refusee_envoye AS `Annonces__mail_refusee_envoye`, Annonces.HTTP_REMOTE_IP AS `Annonces__HTTP_REMOTE_IP`, Annonces.GEOIP_COUNTRY_CODE AS `Annonces__GEOIP_COUNTRY_CODE`, Annonces.GEOIP_REGION AS `Annonces__GEOIP_REGION`, Annonces.GEOIP_CITY AS `Annonces__GEOIP_CITY`, Annonces.GEOIP_LATITUDE AS `Annonces__GEOIP_LATITUDE`, Annonces.GEOIP_LONGITUDE AS `Annonces__GEOIP_LONGITUDE`, Annonces.noref AS `Annonces__noref`, Annonces.quartier_id AS `Annonces__quartier_id`, Annonces.language AS `Annonces__language`, Annonces.timg_created AS `Annonces__timg_created`, Annonces.aimages_deleted AS `Annonces__aimages_deleted`, Annonces.last_edit AS `Annonces__last_edit`, Annonces.deja_remonte AS `Annonces__deja_remonte`, Annonces.phoneimg_created AS `Annonces__phoneimg_created`, Annonces.source_id AS `Annonces__source_id`, Annonces.source AS `Annonces__source`, Annonces.ann_traitee AS `Annonces__ann_traitee`, Annonces.validee_auto AS `Annonces__validee_auto`, Category.id AS `Category__id`, Category.title AS `Category__title`, Category.title_ar AS `Category__title_ar`, Category.title_en AS `Category__title_en`, Category.parent_id AS `Category__parent_id`, Category.rght AS `Category__rght`, Category.lft AS `Category__lft`, Category.slug AS `Category__slug`, Category.slug_ar AS `Category__slug_ar`, Category.slug_en AS `Category__slug_en`, Category.slug_court AS `Category__slug_court`, Category.slug_court_ar AS `Category__slug_court_ar`, Category.slug_court_en AS `Category__slug_court_en`, Category.annonce_count AS `Category__annonce_count`, Category.liste_prix_min AS `Category__liste_prix_min`, Category.liste_prix_max AS `Category__liste_prix_max`, Category.visible AS `Category__visible`, Category.remontegroup_id AS `Category__remontegroup_id`, Category_title_translation.id AS `Category_title_translation__id`, Category_title_translation.locale AS `Category_title_translation__locale`, Category_title_translation.model AS `Category_title_translation__model`, Category_title_translation.foreign_key AS `Category_title_translation__foreign_key`, Category_title_translation.field AS `Category_title_translation__field`, Category_title_translation.content AS `Category_title_translation__content` FROM annonces Annonces LEFT JOIN categories Category ON Category.id = (Annonces.category_id) LEFT JOIN i18n Category_title_translation ON (Category_title_translation.model = :c0 AND Category_title_translation.field = :c1 AND Category_title_translation.locale = :c2 AND Category.id = (Category_title_translation.foreign_key)) WHERE (Annonces.astatut_id = :c3 AND Annonces.aimage_count >= :c4 AND Annonces.category_id = :c5 AND Annonces.id Not IN (  )) ORDER BY Annonces.date_publication desc LIMIT 4',
	'params' => [
		':c0' => [
			'value' => 'Categories',
			'type' => 'string',
			'placeholder' => 'c0'
		],
		':c1' => [
			'value' => 'title',
			'type' => 'string',
			'placeholder' => 'c1'
		],
		':c2' => [
			'value' => 'fr',
			'type' => 'string',
			'placeholder' => 'c2'
		],
		':c3' => [
			'value' => (int) 7,
			'type' => 'integer',
			'placeholder' => 'c3'
		],
		':c4' => [
			'value' => (int) 1,
			'type' => 'integer',
			'placeholder' => 'c4'
		],
		':c5' => [
			'value' => null,
			'type' => 'integer',
			'placeholder' => 'c5'
		]
	],
	'defaultTypes' => [
		'Annonces__id' => 'integer',
		'Annonces.id' => 'integer',
		'id' => 'integer',
		'Annonces__astatut_id' => 'integer',
		'Annonces.astatut_id' => 'integer',
		'astatut_id' => 'integer',
		'Annonces__ref' => 'string',
		'Annonces.ref' => 'string',
		'ref' => 'string',
		'Annonces__created' => 'datetime',
		'Annonces.created' => 'datetime',
		'created' => 'datetime',
		'Annonces__titre' => 'string',
		'Annonces.titre' => 'string',
		'titre' => 'string',
		'Annonces__description' => 'string',
		'Annonces.description' => 'string',
		'description' => 'string',
		'Annonces__nom' => 'string',
		'Annonces.nom' => 'string',
		'nom' => 'string',
		'Annonces__telephone' => 'string',
		'Annonces.telephone' => 'string',
		'telephone' => 'string',
		'Annonces__masquer_telephone' => 'integer',
		'Annonces.masquer_telephone' => 'integer',
		'masquer_telephone' => 'integer',
		'Annonces__email' => 'string',
		'Annonces.email' => 'string',
		'email' => 'string',
		'Annonces__prix' => 'float',
		'Annonces.prix' => 'float',
		'prix' => 'float',
		'Annonces__statut' => 'integer',
		'Annonces.statut' => 'integer',
		'statut' => 'integer',
		'Annonces__edit' => 'integer',
		'Annonces.edit' => 'integer',
		'edit' => 'integer',
		'Annonces__activation_code' => 'string',
		'Annonces.activation_code' => 'string',
		'activation_code' => 'string',
		'Annonces__active' => 'integer',
		'Annonces.active' => 'integer',
		'active' => 'integer',
		'Annonces__pass' => 'string',
		'Annonces.pass' => 'string',
		'pass' => 'string',
		'Annonces__member_delete' => 'integer',
		'Annonces.member_delete' => 'integer',
		'member_delete' => 'integer',
		'Annonces__member_delete_raison' => 'integer',
		'Annonces.member_delete_raison' => 'integer',
		'member_delete_raison' => 'integer',
		'Annonces__category_id' => 'integer',
		'Annonces.category_id' => 'integer',
		'category_id' => 'integer',
		'Annonces__region_id' => 'integer',
		'Annonces.region_id' => 'integer',
		'region_id' => 'integer',
		'Annonces__renew_code' => 'string',
		'Annonces.renew_code' => 'string',
		'renew_code' => 'string',
		'Annonces__renew_date' => 'datetime',
		'Annonces.renew_date' => 'datetime',
		'renew_date' => 'datetime',
		'Annonces__ip' => 'string',
		'Annonces.ip' => 'string',
		'ip' => 'string',
		'Annonces__slug' => 'string',
		'Annonces.slug' => 'string',
		'slug' => 'string',
		'Annonces__commune_id' => 'integer',
		'Annonces.commune_id' => 'integer',
		'commune_id' => 'integer',
		'Annonces__aimage_count' => 'integer',
		'Annonces.aimage_count' => 'integer',
		'aimage_count' => 'integer',
		'Annonces__acontact_count' => 'integer',
		'Annonces.acontact_count' => 'integer',
		'acontact_count' => 'integer',
		'Annonces__sharing_count' => 'integer',
		'Annonces.sharing_count' => 'integer',
		'sharing_count' => 'integer',
		'Annonces__sarnaque_count' => 'integer',
		'Annonces.sarnaque_count' => 'integer',
		'sarnaque_count' => 'integer',
		'Annonces__member_id' => 'integer',
		'Annonces.member_id' => 'integer',
		'member_id' => 'integer',
		'Annonces__admin_notifie' => 'integer',
		'Annonces.admin_notifie' => 'integer',
		'admin_notifie' => 'integer',
		'Annonces__noindex' => 'integer',
		'Annonces.noindex' => 'integer',
		'noindex' => 'integer',
		'Annonces__refall' => 'integer',
		'Annonces.refall' => 'integer',
		'refall' => 'integer',
		'Annonces__tag_selection_1' => 'integer',
		'Annonces.tag_selection_1' => 'integer',
		'tag_selection_1' => 'integer',
		'Annonces__type' => 'integer',
		'Annonces.type' => 'integer',
		'type' => 'integer',
		'Annonces__type_annonceur' => 'integer',
		'Annonces.type_annonceur' => 'integer',
		'type_annonceur' => 'integer',
		'Annonces__date_validation' => 'datetime',
		'Annonces.date_validation' => 'datetime',
		'date_validation' => 'datetime',
		'Annonces__date_publication' => 'datetime',
		'Annonces.date_publication' => 'datetime',
		'date_publication' => 'datetime',
		'Annonces__date_edition' => 'timestamp',
		'Annonces.date_edition' => 'timestamp',
		'date_edition' => 'timestamp',
		'Annonces__tag_logo_urgent' => 'boolean',
		'Annonces.tag_logo_urgent' => 'boolean',
		'tag_logo_urgent' => 'boolean',
		'Annonces__nbr_view_aujourdhui' => 'integer',
		'Annonces.nbr_view_aujourdhui' => 'integer',
		'nbr_view_aujourdhui' => 'integer',
		'Annonces__nbr_affichage_1' => 'integer',
		'Annonces.nbr_affichage_1' => 'integer',
		'nbr_affichage_1' => 'integer',
		'Annonces__nbr_affichage_1_total' => 'integer',
		'Annonces.nbr_affichage_1_total' => 'integer',
		'nbr_affichage_1_total' => 'integer',
		'Annonces__nbr_view_total' => 'integer',
		'Annonces.nbr_view_total' => 'integer',
		'nbr_view_total' => 'integer',
		'Annonces__lu' => 'boolean',
		'Annonces.lu' => 'boolean',
		'lu' => 'boolean',
		'Annonces__mail_activation_envoye' => 'boolean',
		'Annonces.mail_activation_envoye' => 'boolean',
		'mail_activation_envoye' => 'boolean',
		'Annonces__mail_act_renvoye' => 'boolean',
		'Annonces.mail_act_renvoye' => 'boolean',
		'mail_act_renvoye' => 'boolean',
		'Annonces__mail_enligne_envoye' => 'boolean',
		'Annonces.mail_enligne_envoye' => 'boolean',
		'mail_enligne_envoye' => 'boolean',
		'Annonces__mail_refusee_envoye' => 'boolean',
		'Annonces.mail_refusee_envoye' => 'boolean',
		'mail_refusee_envoye' => 'boolean',
		'Annonces__HTTP_REMOTE_IP' => 'string',
		'Annonces.HTTP_REMOTE_IP' => 'string',
		'HTTP_REMOTE_IP' => 'string',
		'Annonces__GEOIP_COUNTRY_CODE' => 'string',
		'Annonces.GEOIP_COUNTRY_CODE' => 'string',
		'GEOIP_COUNTRY_CODE' => 'string',
		'Annonces__GEOIP_REGION' => 'string',
		'Annonces.GEOIP_REGION' => 'string',
		'GEOIP_REGION' => 'string',
		'Annonces__GEOIP_CITY' => 'string',
		'Annonces.GEOIP_CITY' => 'string',
		'GEOIP_CITY' => 'string',
		'Annonces__GEOIP_LATITUDE' => 'string',
		'Annonces.GEOIP_LATITUDE' => 'string',
		'GEOIP_LATITUDE' => 'string',
		'Annonces__GEOIP_LONGITUDE' => 'string',
		'Annonces.GEOIP_LONGITUDE' => 'string',
		'GEOIP_LONGITUDE' => 'string',
		'Annonces__noref' => 'boolean',
		'Annonces.noref' => 'boolean',
		'noref' => 'boolean',
		'Annonces__quartier_id' => 'integer',
		'Annonces.quartier_id' => 'integer',
		'quartier_id' => 'integer',
		'Annonces__language' => 'string',
		'Annonces.language' => 'string',
		'language' => 'string',
		'Annonces__timg_created' => 'boolean',
		'Annonces.timg_created' => 'boolean',
		'timg_created' => 'boolean',
		'Annonces__aimages_deleted' => 'boolean',
		'Annonces.aimages_deleted' => 'boolean',
		'aimages_deleted' => 'boolean',
		'Annonces__last_edit' => 'datetime',
		'Annonces.last_edit' => 'datetime',
		'last_edit' => 'datetime',
		'Annonces__deja_remonte' => 'integer',
		'Annonces.deja_remonte' => 'integer',
		'deja_remonte' => 'integer',
		'Annonces__phoneimg_created' => 'boolean',
		'Annonces.phoneimg_created' => 'boolean',
		'phoneimg_created' => 'boolean',
		'Annonces__source_id' => 'integer',
		'Annonces.source_id' => 'integer',
		'source_id' => 'integer',
		'Annonces__source' => 'string',
		'Annonces.source' => 'string',
		'source' => 'string',
		'Annonces__ann_traitee' => 'boolean',
		'Annonces.ann_traitee' => 'boolean',
		'ann_traitee' => 'boolean',
		'Annonces__validee_auto' => 'boolean',
		'Annonces.validee_auto' => 'boolean',
		'validee_auto' => 'boolean',
		'Images__id' => 'integer',
		'Images.id' => 'integer',
		'Images__image' => 'string',
		'Images.image' => 'string',
		'image' => 'string',
		'Images__annonce_id' => 'integer',
		'Images.annonce_id' => 'integer',
		'annonce_id' => 'integer',
		'Category__id' => 'integer',
		'Category.id' => 'integer',
		'Category__title' => 'string',
		'Category.title' => 'string',
		'title' => 'string',
		'Category__title_ar' => 'string',
		'Category.title_ar' => 'string',
		'title_ar' => 'string',
		'Category__title_en' => 'string',
		'Category.title_en' => 'string',
		'title_en' => 'string',
		'Category__parent_id' => 'integer',
		'Category.parent_id' => 'integer',
		'parent_id' => 'integer',
		'Category__rght' => 'integer',
		'Category.rght' => 'integer',
		'rght' => 'integer',
		'Category__lft' => 'integer',
		'Category.lft' => 'integer',
		'lft' => 'integer',
		'Category__slug' => 'string',
		'Category.slug' => 'string',
		'Category__slug_ar' => 'string',
		'Category.slug_ar' => 'string',
		'slug_ar' => 'string',
		'Category__slug_en' => 'string',
		'Category.slug_en' => 'string',
		'slug_en' => 'string',
		'Category__slug_court' => 'string',
		'Category.slug_court' => 'string',
		'slug_court' => 'string',
		'Category__slug_court_ar' => 'string',
		'Category.slug_court_ar' => 'string',
		'slug_court_ar' => 'string',
		'Category__slug_court_en' => 'string',
		'Category.slug_court_en' => 'string',
		'slug_court_en' => 'string',
		'Category__annonce_count' => 'integer',
		'Category.annonce_count' => 'integer',
		'annonce_count' => 'integer',
		'Category__liste_prix_min' => 'text',
		'Category.liste_prix_min' => 'text',
		'liste_prix_min' => 'text',
		'Category__liste_prix_max' => 'text',
		'Category.liste_prix_max' => 'text',
		'liste_prix_max' => 'text',
		'Category__visible' => 'boolean',
		'Category.visible' => 'boolean',
		'visible' => 'boolean',
		'Category__remontegroup_id' => 'integer',
		'Category.remontegroup_id' => 'integer',
		'remontegroup_id' => 'integer',
		'Category_title_translation__id' => 'integer',
		'Category_title_translation.id' => 'integer',
		'Category_title_translation__locale' => 'string',
		'Category_title_translation.locale' => 'string',
		'locale' => 'string',
		'Category_title_translation__model' => 'string',
		'Category_title_translation.model' => 'string',
		'model' => 'string',
		'Category_title_translation__foreign_key' => 'integer',
		'Category_title_translation.foreign_key' => 'integer',
		'foreign_key' => 'integer',
		'Category_title_translation__field' => 'string',
		'Category_title_translation.field' => 'string',
		'field' => 'string',
		'Category_title_translation__content' => 'text',
		'Category_title_translation.content' => 'text',
		'content' => 'text'
	],
	'decorators' => (int) 0,
	'executed' => false,
	'hydrate' => true,
	'buffered' => true,
	'formatters' => (int) 2,
	'mapReducers' => (int) 0,
	'contain' => [
		'Images' => [],
		'Category' => [
			'Category_title_translation' => [
				[maximum depth reached]
			]
		]
	],
	'matching' => [],
	'extraOptions' => [],
	'repository' => object(App\Model\Table\AnnoncesTable) {

		'registryAlias' => 'Annonces',
		'table' => 'annonces',
		'alias' => 'Annonces',
		'entityClass' => 'App\Model\Entity\Annonce',
		'associations' => [
			[maximum depth reached]
		],
		'behaviors' => [
			[maximum depth reached]
		],
		'defaultConnection' => 'default',
		'connectionName' => 'default'
	
	}

}

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/vendor/cakephp/cakephp/src/ORM/Query.php toggle arguments


	`return new $decorator($this->_results);`
	`}`

	`$statement = $this->getEagerLoader()->loadExternal($this, $this->execute());`

	`return new ResultSet($this, $statement);`
	`}`

No arguments

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/vendor/cakephp/cakephp/src/Datasource/QueryTrait.php toggle arguments

	`if ($this->_cache) {`
	`$results = $this->_cache->fetch($this);`
	`}`
	`if (!isset($results)) {`
	`$results = $this->_decorateResults($this->_execute());`
	`if ($this->_cache) {`
	`$this->_cache->store($this, $results);`
	`}`
	`}`

No arguments

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/vendor/cakephp/cakephp/src/ORM/Query.php toggle arguments

	`'You cannot call all() on a non-select query. Use execute() instead.'`
	`);`
	`}`

	`return $this->_all();`
	`}`

	`/**`
	`* Trigger the beforeFind event on the query's repository object.`

No arguments

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/vendor/cakephp/cakephp/src/Datasource/QueryTrait.php toggle arguments

	`* @return array`
	`*/`
	`public function toArray()`
	`{`
	`return $this->all()->toArray();`
	`}`

	`/**`
	`* Register a new MapReduce routine to be executed on top of the database results`

No arguments

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/src/Controller/AnnoncesController.php toggle arguments

	`])`
	`->contain(['Images', 'Category'])`
	`->order(['Annonces.date_publication' => 'desc'])`
	`->limit($limit - $count);`
	`$relatedAnnonces = array_merge($relatedAnnonces->toArray(), $new_results->toArray());`
	`return $relatedAnnonces;`
	`}`

	`protected function pageDescriptionFormat($text)`

No arguments

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/src/Controller/AnnoncesController.php toggle arguments

	`$this->set(compact('boutique'));`
	`}`

	`if (empty($boutique)) {`
	`$this->set('relatedAnnonces', $this->__getRelatedAnnonces($annonce, 4));`
	`} else {`
	`$this->set('relatedAnnonces', $this->__getRelatedAnnoncesMember($id, $annonce->member_id, 4));`
	`}`

null
(int) 4

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/vendor/cakephp/cakephp/src/Controller/Controller.php toggle arguments

	`}`
	`/* @var callable $callable */`
	`$callable = [$this, $request->getParam('action')];`

	`return $callable(...array_values($request->getParam('pass')));`
	`}`

	`/**`
	`* Merge components, helpers vars from`

'980011'

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/vendor/cakephp/cakephp/src/Http/ActionDispatcher.php toggle arguments

	`if ($result instanceof Response) {`
	`return $result;`
	`}`

	`$response = $controller->invokeAction();`
	`if ($response !== null && !($response instanceof Response)) {`
	`throw new LogicException('Controller actions can only return Cake\Http\Response or null.');`
	`}`

No arguments

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/vendor/cakephp/cakephp/src/Http/ActionDispatcher.php toggle arguments

	`} else {`
	`$controller = $this->factory->create($request, $response);`
	`}`

	`$response = $this->_invoke($controller);`
	`if (isset($request->params['return'])) {`
	`return $response;`
	`}`

object(App\Controller\AnnoncesController) {
	paginate => [
		'limit' => (int) 50,
		'contain' => [
			(int) 0 => 'Commune',
			(int) 1 => 'Images',
			(int) 2 => 'Category',
			(int) 3 => 'Quartier'
		]
	]
	name => 'Annonces'
	helpers => []
	request => object(Cake\Http\ServerRequest) {
		params => [
			[maximum depth reached]
		]
		data => [
			[maximum depth reached]
		]
		query => [[maximum depth reached]]
		cookies => [[maximum depth reached]]
		url => 'fr/demande-formation/Cours-de-francais-980011.html'
		base => ''
		webroot => '/'
		here => '/fr/demande-formation/Cours-de-francais-980011.html'
		trustProxy => false
		[protected] _environment => [
			[maximum depth reached]
		]
		[protected] _input => null
		[protected] _detectors => [
			[maximum depth reached]
		]
		[protected] _detectorCache => [
			[maximum depth reached]
		]
		[protected] stream => object(Zend\Diactoros\PhpInputStream) {}
		[protected] uri => object(Zend\Diactoros\Uri) {}
		[protected] session => object(Cake\Network\Session) {}
		[protected] attributes => [[maximum depth reached]]
		[protected] emulatedAttributes => [
			[maximum depth reached]
		]
		[protected] uploadedFiles => [[maximum depth reached]]
		[protected] protocol => null
		[protected] requestTarget => null
	}
	response => object(Cake\Http\Response) {

		'status' => (int) 200,
		'contentType' => 'text/html',
		'headers' => [
			[maximum depth reached]
		],
		'file' => null,
		'fileRange' => [[maximum depth reached]],
		'cookies' => [[maximum depth reached]],
		'cacheDirectives' => [[maximum depth reached]],
		'body' => ''
	
	}
	autoRender => false
	components => []
	View => object(App\View\AppView) {
		Blocks => object(Cake\View\ViewBlock) {}
		plugin => null
		name => 'Annonces'
		passedArgs => [
			[maximum depth reached]
		]
		helpers => [[maximum depth reached]]
		templatePath => 'Annonces'
		template => 'view'
		layout => 'default'
		layoutPath => null
		autoLayout => true
		subDir => null
		theme => null
		hasRendered => true
		uuids => [[maximum depth reached]]
		request => object(Cake\Http\ServerRequest) {}
		response => object(Cake\Http\Response) {}
		elementCache => 'default'
		viewClass => null
		viewVars => [
			[maximum depth reached]
		]
		Paginator => object(Cake\View\Helper\PaginatorHelper) {}
		Html => object(Cake\View\Helper\HtmlHelper) {}
		Url => object(Cake\View\Helper\UrlHelper) {}
		Form => object(Cake\View\Helper\FormHelper) {}
		Number => object(Cake\View\Helper\NumberHelper) {}
		[protected] _helpers => object(Cake\View\HelperRegistry) {}
		[protected] _ext => '.ctp'
		[protected] _passedVars => [
			[maximum depth reached]
		]
		[protected] _paths => [
			[maximum depth reached]
		]
		[protected] _pathsForPlugin => [[maximum depth reached]]
		[protected] _parents => [[maximum depth reached]]
		[protected] _current => '/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/src/Template/Layout/default.ctp'
		[protected] _currentType => 'layout'
		[protected] _stack => [[maximum depth reached]]
		[protected] _eventManager => object(Cake\Event\EventManager) {}
		[protected] _eventClass => '\Cake\Event\Event'
		[protected] _viewBuilder => null
	}
	plugin => null
	passedArgs => [
		(int) 0 => '980011'
	]
	modelClass => 'Annonces'
	viewClass => null
	viewVars => [
		'quartiers' => [],
		'categories' => [
			(int) 0 => object(Cake\ORM\Entity) {},
			(int) 1 => object(Cake\ORM\Entity) {},
			(int) 2 => object(Cake\ORM\Entity) {},
			(int) 3 => object(Cake\ORM\Entity) {},
			(int) 4 => object(Cake\ORM\Entity) {},
			(int) 5 => object(Cake\ORM\Entity) {},
			(int) 6 => object(Cake\ORM\Entity) {},
			(int) 7 => object(Cake\ORM\Entity) {},
			(int) 8 => object(Cake\ORM\Entity) {},
			(int) 9 => object(Cake\ORM\Entity) {},
			(int) 10 => object(Cake\ORM\Entity) {},
			(int) 11 => object(Cake\ORM\Entity) {},
			(int) 12 => object(Cake\ORM\Entity) {}
		],
		'communes' => object(Cake\ORM\Query) {},
		'count' => [
			'all' => (int) 4055,
			'pro' => (int) 189,
			'par' => (int) 3866
		],
		'annonces' => object(Cake\Datasource\ResultSetDecorator) {},
		'annonce_desactivee' => (int) 1,
		'page_title' => null
	]
	RequestHandler => object(Cake\Controller\Component\RequestHandlerComponent) {

		'components' => [[maximum depth reached]],
		'implementedEvents' => [
			[maximum depth reached]
		],
		'_config' => [
			[maximum depth reached]
		]
	
	}
	Flash => object(Cake\Controller\Component\FlashComponent) {

		'components' => [[maximum depth reached]],
		'implementedEvents' => [[maximum depth reached]],
		'_config' => [
			[maximum depth reached]
		]
	
	}
	Auth => object(Cake\Controller\Component\AuthComponent) {

		'components' => [
			[maximum depth reached]
		],
		'implementedEvents' => [
			[maximum depth reached]
		],
		'_config' => [
			[maximum depth reached]
		]
	
	}
	Paginator => object(Cake\Controller\Component\PaginatorComponent) {

		'components' => [[maximum depth reached]],
		'implementedEvents' => [[maximum depth reached]],
		'_config' => [
			[maximum depth reached]
		]
	
	}
	Annonces => object(App\Model\Table\AnnoncesTable) {

		'registryAlias' => 'Annonces',
		'table' => 'annonces',
		'alias' => 'Annonces',
		'entityClass' => 'App\Model\Entity\Annonce',
		'associations' => [
			[maximum depth reached]
		],
		'behaviors' => [
			[maximum depth reached]
		],
		'defaultConnection' => 'default',
		'connectionName' => 'default'
	
	}
	[protected] _responseClass => 'Cake\Http\Response'
	[protected] _components => object(Cake\Controller\ComponentRegistry) {

		'_Controller' => object(App\Controller\AnnoncesController) {},
		'_loaded' => [
			[maximum depth reached]
		],
		'_eventManager' => object(Cake\Event\EventManager) {},
		'_eventClass' => '\Cake\Event\Event'
	
	}
	[protected] _validViewOptions => [
		(int) 0 => 'passedArgs'
	]
	[protected] _eventManager => object(Cake\Event\EventManager) {

		'_listeners' => [
			[maximum depth reached]
		],
		'_isGlobal' => false,
		'_eventList' => null,
		'_trackEvents' => false,
		'_generalManager' => '(object) EventManager'
	
	}
	[protected] _eventClass => '\Cake\Event\Event'
	[protected] _tableLocator => object(Cake\ORM\Locator\TableLocator) {
		[protected] _config => [[maximum depth reached]]
		[protected] _instances => [
			[maximum depth reached]
		]
		[protected] _fallbacked => [
			[maximum depth reached]
		]
		[protected] _options => [
			[maximum depth reached]
		]
	}
	[protected] _modelFactories => [
		'Table' => [
			(int) 0 => object(Cake\ORM\Locator\TableLocator) {},
			(int) 1 => 'get'
		]
	]
	[protected] _modelType => 'Table'
	[protected] _viewBuilder => object(Cake\View\ViewBuilder) {
		[protected] _templatePath => 'Annonces'
		[protected] _template => 'view'
		[protected] _plugin => null
		[protected] _theme => null
		[protected] _layout => null
		[protected] _autoLayout => null
		[protected] _layoutPath => null
		[protected] _name => 'Annonces'
		[protected] _className => null
		[protected] _options => [
			[maximum depth reached]
		]
		[protected] _helpers => [[maximum depth reached]]
	}
}

/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/vendor/cakephp/cakephp/src/Http/BaseApplication.php toggle arguments

	`* @return \Psr\Http\Message\ResponseInterface`
	`*/`
	`public function __invoke(ServerRequestInterface $request, ResponseInterface $response, $next)`
	`{`
	`return $this->getDispatcher()->dispatch($request, $response);`
	`}`

	`/**`
	`* Get the ActionDispatcher.`

object(Cake\Http\ServerRequest) {
	params => [
		'language' => 'fr',
		'category' => 'demande-formation',
		'ad_slug' => 'Cours-de-francais',
		'id' => '980011',
		'pass' => [
			(int) 0 => '980011'
		],
		'controller' => 'Annonces',
		'action' => 'view',
		'plugin' => null,
		'_ext' => 'html',
		'_matchedRoute' => '/:language/:category/:ad_slug-:id',
		'isAjax' => false,
		'paging' => [
			'Annonces' => [
				[maximum depth reached]
			]
		]
	]
	data => [
		'cid' => (int) 0
	]
	query => []
	cookies => []
	url => 'fr/demande-formation/Cours-de-francais-980011.html'
	base => ''
	webroot => '/'
	here => '/fr/demande-formation/Cours-de-francais-980011.html'
	trustProxy => false
	[protected] _environment => [
		'USER' => 'mohammed',
		'HOME' => '/var/www/vhosts/mabroka.ma',
		'SCRIPT_NAME' => '/webroot/index.php',
		'REQUEST_URI' => '/fr/demande-formation/Cours-de-francais-980011.html',
		'QUERY_STRING' => '',
		'REQUEST_METHOD' => 'GET',
		'SERVER_PROTOCOL' => 'HTTP/1.0',
		'GATEWAY_INTERFACE' => 'CGI/1.1',
		'REDIRECT_URL' => '/webroot/fr/demande-formation/Cours-de-francais-980011.html',
		'REMOTE_PORT' => '60366',
		'SCRIPT_FILENAME' => '/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma/webroot/index.php',
		'SERVER_ADMIN' => 'belabed_90@hotmail.fr',
		'CONTEXT_DOCUMENT_ROOT' => '/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma',
		'CONTEXT_PREFIX' => '',
		'REQUEST_SCHEME' => 'https',
		'DOCUMENT_ROOT' => '/var/www/vhosts/mabroka.ma/httpdocs/mabroka.ma',
		'REMOTE_ADDR' => '54.226.25.74',
		'SERVER_PORT' => '443',
		'SERVER_ADDR' => '82.165.67.128',
		'SERVER_NAME' => 'www.mabroka.ma',
		'SERVER_SOFTWARE' => 'Apache',
		'SERVER_SIGNATURE' => '',
		'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin',
		'HTTP_ACCEPT_ENCODING' => 'gzip',
		'HTTP_IF_MODIFIED_SINCE' => 'Tue, 16 Oct 2018 19:28:23 CEST',
		'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
		'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
		'HTTP_CONNECTION' => 'close',
		'HTTP_X_ACCEL_INTERNAL' => '/internal-nginx-static-location',
		'HTTP_X_REAL_IP' => '54.226.25.74',
		'HTTP_HOST' => 'www.mabroka.ma',
		'proxy-nokeepalive' => '1',
		'HTTPS' => 'on',
		'PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins',
		'UNIQUE_ID' => 'XEPtefgeg1XvIdnK9hzGHQAAAIY',
		'REDIRECT_STATUS' => '200',
		'REDIRECT_HTTPS' => 'on',
		'REDIRECT_PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins',
		'REDIRECT_UNIQUE_ID' => 'XEPtefgeg1XvIdnK9hzGHQAAAIY',
		'REDIRECT_REDIRECT_STATUS' => '200',
		'REDIRECT_REDIRECT_HTTPS' => 'on',
		'REDIRECT_REDIRECT_PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins',
		'REDIRECT_REDIRECT_UNIQUE_ID' => 'XEPtefgeg1XvIdnK9hzGHQAAAIY',
		'FCGI_ROLE' => 'RESPONDER',
		'PHP_SELF' => '/webroot/index.php',
		'REQUEST_TIME_FLOAT' => (float) 1547955577.7259,
		'REQUEST_TIME' => (int) 1547955577,
		'ORIGINAL_REQUEST_METHOD' => 'GET',
		'HTTP_X_REQUESTED_WITH' => null,
		'HTTP_REFERER' => null,
		'HTTP_IF_NONE_MATCH' => null
	]
	[protected] _input => null
	[protected] _detectors => [
		'get' => [
			'env' => 'REQUEST_METHOD',
			'value' => 'GET'
		],
		'post' => [
			'env' => 'REQUEST_METHOD',
			'value' => 'POST'
		],
		'put' => [
			'env' => 'REQUEST_METHOD',
			'value' => 'PUT'
		],
		'patch' => [
			'env' => 'REQUEST_METHOD',
			'value' => 'PATCH'
		],
		'delete' => [
			'env' => 'REQUEST_METHOD',
			'value' => 'DELETE'
		],
		'head' => [
			'env' => 'REQUEST_METHOD',
			'value' => 'HEAD'
		],
		'options' => [
			'env' => 'REQUEST_METHOD',
			'value' => 'OPTIONS'
		],
		'ssl' => [
			'env' => 'HTTPS',
			'options' => [
				[maximum depth reached]
			]
		],
		'ajax' => [
			'env' => 'HTTP_X_REQUESTED_WITH',
			'value' => 'XMLHttpRequest'
		],
		'flash' => [
			'env' => 'HTTP_USER_AGENT',
			'pattern' => '/^(Shockwave|Adobe) Flash/'
		],
		'requested' => [
			'param' => 'requested',
			'value' => (int) 1
		],
		'json' => [
			'accept' => [
				[maximum depth reached]
			],
			'param' => '_ext',
			'value' => 'json'
		],
		'xml' => [
			'accept' => [
				[maximum depth reached]
			],
			'param' => '_ext',
			'value' => 'xml'
		],
		'mobile' => object(Closure) {},
		'tablet' => object(Closure) {}
	]
	[protected] _detectorCache => [
		'ajax' => false,
		'get' => true,
		'head' => false,
		'options' => false
	]
	[protected] stream => object(Zend\Diactoros\PhpInputStream) {
		[protected] resource => resource
		[protected] stream => 'php://input'
		[private] cache => ''
		[private] reachedEof => false
	}
	[protected] uri => object(Zend\Diactoros\Uri) {
		base => ''
		webroot => '/'
		[protected] allowedSchemes => [
			[maximum depth reached]
		]
		[private] scheme => 'https'
		[private] userInfo => ''
		[private] host => 'www.mabroka.ma'
		[private] port => null
		[private] path => '/fr/demande-formation/Cours-de-francais-980011.html'
		[private] query => ''
		[private] fragment => ''
		[private] uriString => null
	}
	[protected] session => object(Cake\Network\Session) {
		[protected] _engine => null
		[protected] _started => null
		[protected] _lifetime => '1440'
		[protected] _isCLI => false
	}
	[protected] attributes => []
	[protected] emulatedAttributes => [
		(int) 0 => 'session',
		(int) 1 => 'webroot',
		(int) 2 => 'base',
		(int) 3 => 'params'
	]
	[protected] uploadedFiles => []
	[protected] protocol => null
	[protected] requestTarget => null
}
object(Cake\Http\Response) {

	'status' => (int) 200,
	'contentType' => 'text/html',
	'headers' => [
		'Content-Type' => [
			(int) 0 => 'text/html; charset=UTF-8'
		]
	],
	'file' => null,
	'fileRange' => [],
	'cookies' => [],
	'cacheDirectives' => [],
	'body' => ''

}