`
Quicksearch!
Search Now!
Welcome!
Real Estate PTY is a Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat
Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, fugiat nulla pariatur. Excepteur sint occaecat.
Query: SELECT `Property`.`id`, `Property`.`company_id`, `Property`.`user_id`, `Property`.`type_id`, `Property`.`category_id`, `Property`.`location_id`, `Property`.`status_id`, `Property`.`name`, `Property`.`description`, `Property`.`preconstruction_date`, `Property`.`construction_start`, `Property`.`construction_finish`, `Property`.`year_built`, `Property`.`price_from`, `Property`.`price_to`, `Property`.`maintenance_fee`, `Property`.`price_m2`, `Property`.`rental_cost`, `Property`.`size_from`, `Property`.`size_to`, `Property`.`metric`, `Property`.`floor`, `Property`.`bedrooms`, `Property`.`bathrooms`, `Property`.`more_info`, `Property`.`published`, `Property`.`featured`, `Property`.`exclusive`, `Property`.`featured_photo_id`, `Property`.`video`, `Property`.`viewed`, `Property`.`created`, `Property`.`modified`, `Property`.`propertytype_id`, `Property`.`friendlyname`, `Property`.`sfname`, `Property`.`slname`, `Property`.`semail`, `Property`.`saddress`, `Property`.`scity`, `Property`.`sstate`, `Property`.`scountry`, `Property`.`szip`, `Property`.`stelephone`, `Property`.`smobile`, `Property`.`scontactinpanama`, `Property`.`saddressinpanama`, `Property`.`scomments`, `Property`.`sellproperty`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`maplevel`, `Property`.`nombre`, `Property`.`descripcion`, `Property`.`mas_informacion`, `Company`.`id`, `Company`.`name`, `Company`.`address`, `Company`.`city`, `Company`.`state`, `Company`.`country_id`, `Company`.`zip_code`, `Company`.`telephone`, `Company`.`fax`, `Company`.`instant_message`, `Company`.`url`, `Company`.`email`, `Company`.`password`, `Company`.`logo`, `Company`.`map_api`, `Company`.`contact_name`, `Company`.`contact_phone`, `Company`.`contact_billing_address`, `Company`.`type`, `User`.`id`, `User`.`name`, `User`.`password`, `User`.`email`, `User`.`last_login`, `User`.`userlevel`, `User`.`type`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`name`, `Profile`.`address`, `Profile`.`city`, `Profile`.`state`, `Profile`.`country_id`, `Profile`.`zip_code`, `Profile`.`telephone`, `Profile`.`fax`, `Profile`.`instant_message`, `Profile`.`url`, `Profile`.`email`, `Profile`.`logo`, `Profile`.`map_api`, `Profile`.`contact_name`, `Profile`.`contact_phone`, `Profile`.`contact_billing_address`, `Profile`.`listings_allowed`, `Category`.`id`, `Category`.`type_id`, `Category`.`name`, `Category`.`description`, `Location`.`id`, `Location`.`name`, `Location`.`description`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`maplevel`, `Status`.`id`, `Status`.`name`, `Status`.`description`, `Propertytype`.`id`, `Propertytype`.`name`, `Propertytype`.`created`, `Propertytype`.`modified` FROM `properties` AS `Property` LEFT JOIN `companies` AS `Company` ON (`Property`.`company_id` = `Company`.`id`) LEFT JOIN `users` AS `User` ON (`Property`.`user_id` = `User`.`id`) LEFT JOIN `profiles` AS `Profile` ON (`Property`.`user_id` = `Profile`.`id`) LEFT JOIN `categories` AS `Category` ON (`Property`.`category_id` = `Category`.`id`) LEFT JOIN `locations` AS `Location` ON (`Property`.`location_id` = `Location`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Property`.`status_id` = `Status`.`id`) LEFT JOIN `propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) WHERE `Property`.`published` = 1 AND `Property`.`category_id` = '' AND `Property`.`id` <> ORDER BY rand() ASC LIMIT 4
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 'ORDER BY rand() ASC LIMIT 4' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 463]
Context |
Code$sql = "SELECT `Property`.`id`, `Property`.`company_id`, `Property`.`user_id`, `Property`.`type_id`, `Property`.`category_id`, `Property`.`location_id`, `Property`.`status_id`, `Property`.`name`, `Property`.`description`, `Property`.`preconstruction_date`, `Property`.`construction_start`, `Property`.`construction_finish`, `Property`.`year_built`, `Property`.`price_from`, `Property`.`price_to`, `Property`.`maintenance_fee`, `Property`.`price_m2`, `Property`.`rental_cost`, `Property`.`size_from`, `Property`.`size_to`, `Property`.`metric`, `Property`.`floor`, `Property`.`bedrooms`, `Property`.`bathrooms`, `Property`.`more_info`, `Property`.`published`, `Property`.`featured`, `Property`.`exclusive`, `Property`.`featured_photo_id`, `Property`.`video`, `Property`.`viewed`, `Property`.`created`, `Property`.`modified`, `Property`.`propertytype_id`, `Property`.`friendlyname`, `Property`.`sfname`, `Property`.`slname`, `Property`.`semail`, `Property`.`saddress`, `Property`.`scity`, `Property`.`sstate`, `Property`.`scountry`, `Property`.`szip`, `Property`.`stelephone`, `Property`.`smobile`, `Property`.`scontactinpanama`, `Property`.`saddressinpanama`, `Property`.`scomments`, `Property`.`sellproperty`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`maplevel`, `Property`.`nombre`, `Property`.`descripcion`, `Property`.`mas_informacion`, `Company`.`id`, `Company`.`name`, `Company`.`address`, `Company`.`city`, `Company`.`state`, `Company`.`country_id`, `Company`.`zip_code`, `Company`.`telephone`, `Company`.`fax`, `Company`.`instant_message`, `Company`.`url`, `Company`.`email`, `Company`.`password`, `Company`.`logo`, `Company`.`map_api`, `Company`.`contact_name`, `Company`.`contact_phone`, `Company`.`contact_billing_address`, `Company`.`type`, `User`.`id`, `User`.`name`, `User`.`password`, `User`.`email`, `User`.`last_login`, `User`.`userlevel`, `User`.`type`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`name`, `Profile`.`address`, `Profile`.`city`, `Profile`.`state`, `Profile`.`country_id`, `Profile`.`zip_code`, `Profile`.`telephone`, `Profile`.`fax`, `Profile`.`instant_message`, `Profile`.`url`, `Profile`.`email`, `Profile`.`logo`, `Profile`.`map_api`, `Profile`.`contact_name`, `Profile`.`contact_phone`, `Profile`.`contact_billing_address`, `Profile`.`listings_allowed`, `Category`.`id`, `Category`.`type_id`, `Category`.`name`, `Category`.`description`, `Location`.`id`, `Location`.`name`, `Location`.`description`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`maplevel`, `Status`.`id`, `Status`.`name`, `Status`.`description`, `Propertytype`.`id`, `Propertytype`.`name`, `Propertytype`.`created`, `Propertytype`.`modified` FROM `properties` AS `Property` LEFT JOIN `companies` AS `Company` ON (`Property`.`company_id` = `Company`.`id`) LEFT JOIN `users` AS `User` ON (`Property`.`user_id` = `User`.`id`) LEFT JOIN `profiles` AS `Profile` ON (`Property`.`user_id` = `Profile`.`id`) LEFT JOIN `categories` AS `Category` ON (`Property`.`category_id` = `Category`.`id`) LEFT JOIN `locations` AS `Location` ON (`Property`.`location_id` = `Location`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Property`.`status_id` = `Status`.`id`) LEFT JOIN `propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) WHERE `Property`.`published` = 1 AND `Property`.`category_id` = '' AND `Property`.`id` <> ORDER BY rand() ASC LIMIT 4"
$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 'ORDER BY rand() ASC LIMIT 4' at line 1"
if (($this->debug || $error) && Configure::read() > 0) {
e("<p style = \"text-align:left\"><b>Query:</b> {$sql} ");
if ($error) {
trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);
} else {
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 463
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 289
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 331
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 593
Model::findAll() - CORE/cake/libs/model/model.php, line 1451
PropertiesController::similarproperties() - CORE/apps/controllers/properties_controller.php, line 74
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 341
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 323
Object::requestAction() - CORE/cake/libs/object.php, line 105
include - CORE/apps/views/elements/view_right_bar.ctp, line 34
View::_render() - CORE/cake/libs/view/view.php, line 779
View::renderElement() - CORE/cake/libs/view/view.php, line 408
include - CORE/apps/views/layouts/default.ctp, line 202
View::_render() - CORE/cake/libs/view/view.php, line 779
View::renderLayout() - CORE/cake/libs/view/view.php, line 492
View::render() - CORE/cake/libs/view/view.php, line 353
Controller::render() - CORE/cake/libs/controller/controller.php, line 623
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 344
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 323
[main] - CORE/apps/webroot/index.php, line 84