SearchComponent::query() - APP/controllers/components/search.php, line 14
SearchController::search() - APP/controllers/search_controller.php, line 120
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`ci' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 684]
$sql = "SELECT COUNT(*) AS `count` FROM `property` AS `Property` LEFT JOIN `type` AS `Type` ON (`Property`.`type_id` = `Type`.`id`) WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) "
$error = "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`ci' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 684
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 410
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 823
Model::find() - CORE/cake/libs/model/model.php, line 2127
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1204
SearchController::search() - APP/controllers/search_controller.php, line 129
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` LEFT JOIN `type` AS `Type` ON (`Property`.`type_id` = `Type`.`id`) WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0)
Query: SELECT `Property`.`id`, `Property`.`type_id`, `Property`.`reference`, `Property`.`title`, `Property`.`subtitle`, `Property`.`address`, `Property`.`city`, `Property`.`area`, `Property`.`location`, `Property`.`price`, `Property`.`description`, `Property`.`buy`, `Property`.`active`, `Property`.`created`, `Property`.`updated`, `Type`.`id`, `Type`.`name`, `Type`.`uri` FROM `property` AS `Property` LEFT JOIN `type` AS `Type` ON (`Property`.`type_id` = `Type`.`id`) WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) ORDER BY CAST(`Property`.`price` AS SIGNED) asc LIMIT 5
Notice (8): Undefined index: immobiliere [APP/controllers/search_controller.php, line 159]
$checkList = false
$listArea = array(
"Hivernage" => "Hivernage",
"" => "",
"Proche Amelkis" => "Proche Amelkis",
"Majorelle" => "Majorelle",
"Victor Hugo" => "Victor Hugo",
"Targa" => "Targa",
"Agdal" => "Agdal",
"Route de Ouarzazate" => "Route de Ouarzazate",
"Amizmiz" => "Amizmiz",
"Guéliz" => "Guéliz",
"Bab Atlas" => "Bab Atlas",
"Chuiter" => "Chuiter",
"Route d'Amizmiz" => "Route d'Amizmiz",
"Route de l'Ourika" => "Route de l'Ourika",
"Route de Sidi Abdellah Ghiat" => "Route de Sidi Abdellah Ghiat",
"Proche du golf" => "Proche du golf",
"Palmeraie" => "Palmeraie",
"Route de Fès" => "Route de Fès",
"Route Sidi Abdellah Ghiat" => "Route Sidi Abdellah Ghiat",
"Amelkis" => "Amelkis"
)
$params = array(
"where" => "maroc",
"what" => "immobiliere",
"choix" => "agence"
)
$results = " (Property.type_id = ) AND ((soundex(Property.city) like soundex('maroc') OR lower(Property.city) like '%maroc%' OR lower(Property.area) like '%maroc%' OR soundex(Property.area) like soundex('maroc'))) AND (buy=0)"
$list = false
$listFilter = array()
$type = null
$id = null
SearchController::search() - APP/controllers/search_controller.php, line 159
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Warning (2): Invalid argument supplied for foreach() [APP/controllers/search_controller.php, line 161]
$checkFilters = $this->Property->filtres[$params['what']]; foreach($checkFilters as $prop => &$filter){
$checkList = false
$listArea = array(
"Hivernage" => "Hivernage",
"" => "",
"Proche Amelkis" => "Proche Amelkis",
"Majorelle" => "Majorelle",
"Victor Hugo" => "Victor Hugo",
"Targa" => "Targa",
"Agdal" => "Agdal",
"Route de Ouarzazate" => "Route de Ouarzazate",
"Amizmiz" => "Amizmiz",
"Guéliz" => "Guéliz",
"Bab Atlas" => "Bab Atlas",
"Chuiter" => "Chuiter",
"Route d'Amizmiz" => "Route d'Amizmiz",
"Route de l'Ourika" => "Route de l'Ourika",
"Route de Sidi Abdellah Ghiat" => "Route de Sidi Abdellah Ghiat",
"Proche du golf" => "Proche du golf",
"Palmeraie" => "Palmeraie",
"Route de Fès" => "Route de Fès",
"Route Sidi Abdellah Ghiat" => "Route Sidi Abdellah Ghiat",
"Amelkis" => "Amelkis"
)
$params = array(
"where" => "maroc",
"what" => "immobiliere",
"choix" => "agence"
)
$results = " (Property.type_id = ) AND ((soundex(Property.city) like soundex('maroc') OR lower(Property.city) like '%maroc%' OR lower(Property.area) like '%maroc%' OR soundex(Property.area) like soundex('maroc'))) AND (buy=0)"
$list = false
$listFilter = array()
$type = null
$id = null
$checkFilters = null
SearchController::search() - APP/controllers/search_controller.php, line 161
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Notice (8): Undefined variable: usedFilters [APP/controllers/search_controller.php, line 171]
$checkList = false
$listArea = array(
"Hivernage" => "Hivernage",
"" => "",
"Proche Amelkis" => "Proche Amelkis",
"Majorelle" => "Majorelle",
"Victor Hugo" => "Victor Hugo",
"Targa" => "Targa",
"Agdal" => "Agdal",
"Route de Ouarzazate" => "Route de Ouarzazate",
"Amizmiz" => "Amizmiz",
"Guéliz" => "Guéliz",
"Bab Atlas" => "Bab Atlas",
"Chuiter" => "Chuiter",
"Route d'Amizmiz" => "Route d'Amizmiz",
"Route de l'Ourika" => "Route de l'Ourika",
"Route de Sidi Abdellah Ghiat" => "Route de Sidi Abdellah Ghiat",
"Proche du golf" => "Proche du golf",
"Palmeraie" => "Palmeraie",
"Route de Fès" => "Route de Fès",
"Route Sidi Abdellah Ghiat" => "Route Sidi Abdellah Ghiat",
"Amelkis" => "Amelkis"
)
$params = array(
"where" => "maroc",
"what" => "immobiliere",
"choix" => "agence"
)
$results = " (Property.type_id = ) AND ((soundex(Property.city) like soundex('maroc') OR lower(Property.city) like '%maroc%' OR lower(Property.area) like '%maroc%' OR soundex(Property.area) like soundex('maroc'))) AND (buy=0)"
$list = false
$listFilter = array()
$type = null
$id = null
$checkFilters = null
SearchController::search() - APP/controllers/search_controller.php, line 171
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and price <200000
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and price BETWEEN 200001 AND 500000
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and price BETWEEN 500001 AND 1000000
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and price BETWEEN 1000001 AND 1500000
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and price BETWEEN 1500001 AND 2000000
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and price >2000001
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Hivernage%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Proche Amelkis%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Majorelle%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Victor Hugo%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Targa%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Agdal%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Route de Ouarzazate%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Amizmiz%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Guéliz%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Bab Atlas%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Chuiter%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Route d'Amizmiz%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Route de l'Ourika%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Route de Sidi Abdellah Ghiat%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Proche du golf%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Palmeraie%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Route de Fès%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Route Sidi Abdellah Ghiat%"
Query: SELECT COUNT(*) AS `count` FROM `property` AS `Property` WHERE (`Property`.`type_id` = ) AND ((soundex(`Property`.`city`) like soundex('maroc') OR lower(`Property`.`city`) like '%maroc%' OR lower(`Property`.`area`) like '%maroc%' OR soundex(`Property`.`area`) like soundex('maroc'))) AND (buy=0) and area like "%Amelkis%"
include - APP/views/search/search.ctp, line 22
View::_render() - CORE/cake/libs/view/view.php, line 731
View::render() - CORE/cake/libs/view/view.php, line 426
Controller::render() - CORE/cake/libs/controller/controller.php, line 909
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83