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 prop_event_only='no' AND prop_hidden = 'no' AND prop_active = 'yes'' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 440]

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 prop_event_only='no' AND prop_hidden = 'no' AND prop_active = 'yes' ORDER B' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 440]

$sql = "SELECT `Property`.`id`, `Property`.`island_id`, `Property`.`area_id`, `Property`.`city_id`, `Property`.`user_id`, `Property`.`view_id`, `Property`.`occupancy_id`, `Property`.`price_id`, `Property`.`prop_page_title`, `Property`.`prop_name`, `Property`.`prop_featured`, `Property`.`prop_prev_description`, `Property`.`prop_description`, `Property`.`prop_metadesc`, `Property`.`prop_keywords`, `Property`.`prop_event`, `Property`.`prop_event_only`, `Property`.`prop_event_specifications`, `Property`.`prop_price_min`, `Property`.`prop_price_max`, `Property`.`prop_sq_feet`, `Property`.`prop_bed`, `Property`.`prop_bath`, `Property`.`prop_palm_rating`, `Property`.`prop_dep_clean_fee`, `Property`.`prop_sec_deposit_min`, `Property`.`prop_sec_deposit_max`, `Property`.`prop_clean_service`, `Property`.`prop_clean_service_text`, `Property`.`prop_pool`, `Property`.`prop_pool_heat_fee`, `Property`.`prop_jacuzzi`, `Property`.`prop_jacuzzi_text`, `Property`.`prop_air_condition`, `Property`.`prop_air_condition_text`, `Property`.`prop_door_screens`, `Property`.`prop_min_stay`, `Property`.`prop_internet`, `Property`.`prop_internet_text`, `Property`.`prop_bed_config`, `Property`.`prop_island`, `Property`.`prop_max_occupancy`, `Property`.`prop_other`, `Property`.`prop_notes`, `Property`.`prop_user_notes`, `Property`.`prop_last_min_rate`, `Property`.`prop_last_min_price`, `Property`.`prop_last_min_from_date`, `Property`.`prop_last_min_to_date`, `Property`.`prop_prev_img`, `Property`.`prop_hidden`, `Property`.`prop_ohana`, `Property`.`prop_active`, `Property`.`prop_holiday_on`, `Property`.`prop_holiday_from_date`, `Property`.`prop_holiday_to_date`, `Property`.`prop_holiday_min_rate`, `Property`.`prop_holiday_max_rate`, `Property`.`prop_holiday_min_stay`, `Property`.`prop_holiday_notes` FROM `hh_properties` AS `Property` WHERE area_id= AND prop_event_only='no' AND prop_hidden = 'no' AND prop_active = 'yes' ORDER BY `prop_name` ASC LIMIT 20" $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 prop_event_only='no' AND prop_hidden = 'no' AND prop_active = 'yes' ORDER B' at line 1"

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 440 DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 166 DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 297 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 571 Model::find() - CORE/cake/libs/model/model.php, line 1502 Model::findAll() - CORE/cake/libs/model/model.php, line 1540 Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1167 IslandsController::lanai() - CORE/app/controllers/islands_controller.php, line 569 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 276 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 248 [main] - CORE/app/webroot/index.php, line 84

:

Showing Page 1 of 1

<< Back To Lanai

Warning (2): Invalid argument supplied for foreach() [CORE/app/views/islands/lanai-area.ctp, line 37]

Context | Code

$this	=	array("name" => "Islands", "here" => "/islands/lanai/lanai.html", "parent" => null, "action" => "lanai", "model" => null, "association" => null, "field" => "", "fieldSuffix" => null, "modelId" => null, "uses" => false, "helpers" => array, "viewPath" => "islands", "layoutPath" => null, "viewVars" => array, "__scripts" => array, "pageTitle" => null, "models" => array, "base" => "", "layout" => "default", "autoRender" => true, "autoLayout" => true, "params" => array, "hasRendered" => false, "loaded" => array, "ext" => ".ctp", "subDir" => null, "themeWeb" => null, "plugin" => null, "pluginPath" => null, "pluginPaths" => array, "passedArgs" => array, "__passedVars" => array, "uuids" => array, "_log" => null, "webroot" => "/", "modelNames" => array, "data" => array, "webservices" => null, "cacheAction" => false)
$___viewFn	=	"/home/hawaii34/public_html/app/views/islands/lanai-area.ctp"
$___dataForView	=	array("island_nms" => array, "area" => false, "heading" => ": ", "pricing" => array, "views" => array, "cities" => array, "properties" => false)
$loadHelpers	=	true
$cached	=	false
$loadedHelpers	=	array("Html" => array, "Javascript" => array, "Form" => array, "Session" => array, "Ajax" => array, "Paginator" => array)
$helper	=	array("helpers" => array, "__defaultModel" => "Property", "options" => array, "base" => "", "webroot" => "/", "themeWeb" => null, "here" => "/islands/lanai/lanai.html", "params" => array, "action" => "lanai", "plugin" => null, "data" => array, "namedArgs" => null, "argSeparator" => null, "validationErrors" => null, "tags" => array, "__tainted" => null, "__cleaned" => null, "_log" => null, "Html" => array, "Ajax" => array)
$replace	=	"p"
$camelBackedHelper	=	"paginator"
$html	=	array("tags" => array, "base" => "", "here" => "/islands/lanai/lanai.html", "params" => array, "action" => "lanai", "data" => array, "_crumbs" => array, "__docTypes" => array, "helpers" => array, "webroot" => "/", "themeWeb" => null, "plugin" => null, "namedArgs" => null, "argSeparator" => null, "validationErrors" => null, "__tainted" => null, "__cleaned" => null, "_log" => null, "Html" => array, "Javascript" => array, "Form" => array)
$subHelpers	=	array(0 => "Html", 1 => "Ajax")
$subHelper	=	"Ajax"
$javascript	=	array("__scriptBuffer" => null, "_cachedEvents" => array, "_cacheEvents" => false, "_cacheToFile" => false, "_cacheAll" => false, "_rules" => array, "enabled" => true, "safe" => false, "tags" => array, "helpers" => array, "base" => "", "webroot" => "/", "themeWeb" => null, "here" => "/islands/lanai/lanai.html", "params" => array, "action" => "lanai", "plugin" => null, "data" => array, "namedArgs" => null, "argSeparator" => null, "validationErrors" => null, "__tainted" => null, "__cleaned" => null, "_log" => null, "Html" => array, "Javascript" => array, "Form" => array)
$form	=	array("helpers" => array, "fieldset" => array, "__options" => array, "fields" => array, "requestType" => "post", "base" => "", "webroot" => "/", "themeWeb" => null, "here" => "/islands/lanai/lanai.html", "params" => array, "action" => "lanai", "plugin" => null, "data" => array, "namedArgs" => null, "argSeparator" => null, "validationErrors" => null, "tags" => array, "__tainted" => null, "__cleaned" => null, "_log" => null, "Html" => array)
$session	=	array("helpers" => null, "__active" => true, "valid" => false, "error" => false, "_userAgent" => "4876e4fe30f4c2c80a8d1ed4e282ac75", "path" => false, "lastError" => null, "security" => null, "time" => 1328323694, "sessionTime" => false, "watchKeys" => array, "_log" => null, "base" => "", "webroot" => "/", "here" => "/islands/lanai/lanai.html", "params" => array, "action" => "lanai", "data" => array, "themeWeb" => null, "plugin" => null)
$ajax	=	array("helpers" => array, "Html" => array, "Javascript" => array, "callbacks" => array, "ajaxOptions" => array, "dragOptions" => array, "dropOptions" => array, "sortOptions" => array, "sliderOptions" => array, "editorOptions" => array, "autoCompleteOptions" => array, "__ajaxBuffer" => array, "base" => "", "webroot" => "/", "themeWeb" => null, "here" => "/islands/lanai/lanai.html", "params" => array, "action" => "lanai", "plugin" => null, "data" => array, "namedArgs" => null, "argSeparator" => null, "validationErrors" => null, "tags" => array, "__tainted" => null, "__cleaned" => null, "_log" => null, "Form" => array)
$paginator	=	array("helpers" => array, "__defaultModel" => "Property", "options" => array, "base" => "", "webroot" => "/", "themeWeb" => null, "here" => "/islands/lanai/lanai.html", "params" => array, "action" => "lanai", "plugin" => null, "data" => array, "namedArgs" => null, "argSeparator" => null, "validationErrors" => null, "tags" => array, "__tainted" => null, "__cleaned" => null, "_log" => null, "Html" => array, "Ajax" => array)
$island_nms	=	array(3 => "Hawaii", 4 => "Kauai", 5 => "Lanai", 1 => "Maui", 6 => "Molokai", 2 => "Oahu")
$area	=	false
$heading	=	": "
$pricing	=	array(6 => "$3000 + Per Night", 7 => "* Call For Pricing", 5 => "$2,000 - $3,000 Per Night", 4 => "$1,500 - $2,000 Per Night", 3 => "$900 - $1,500 Per Night", 2 => "$500 - $900 Per Night", 1 => "$200 - $500 Per Night")
$views	=	array(1 => "Beachfront", 2 => "Oceanfront", 3 => "Oceanview", 4 => "Across The Street From the Beach ", 5 => "Garden View")
$cities	=	array(1 => "Hilo", 2 => "Kailua-Kona", 3 => "Kohala Coast", 4 => "Anahola", 5 => "Kapaa", 6 => "Princeville", 7 => "Poipu", 8 => "Waimea", 9 => "Kahana", 10 => "Kapalua", 11 => "Napili", 12 => "Kihei", 13 => "Wailea", 14 => "Makena", 15 => "Lahaina", 16 => "Ka'anapali", 17 => "North Shore", 18 => "West Shore", 19 => "Diamond Head", 20 => "Kahala", 21 => "Koko Head", 22 => "Kailua", 23 => "North Shore", 24 => "Laie", 25 => "Spreckelsville", 26 => "Kuau", 27 => "Waiehu", 28 => "Lanai City", 29 => "Haena", 30 => "Hanalei", 31 => "Kilauea", 32 => "Anini", 33 => "Keauhou", 35 => "Honolulu", 36 => "Lanikai", 37 => "Hawaii Kai", 38 => "Waimanalo", 39 => "Hualalai", 41 => "Manele Bay", 42 => "Manele Bay", 43 => "Puako")
$properties	=	false
$BASE	=	""
$params	=	array("pass" => array, "controller" => "islands", "action" => "lanai", "plugin" => null, "url" => array, "form" => array, "bare" => 0, "webservices" => null, "paging" => array, "models" => array)
$page_title	=	null


?>



</div>



<?php 




        foreach($properties as $property) { 



            echo $this->renderElement('property',array('property'=>$property,'price'=>$pricing,'views'=>$views,'cities'=>$cities));

include - CORE/app/views/islands/lanai-area.ctp, line 37
View::_render() - CORE/cake/libs/view/view.php, line 765
View::render() - CORE/cake/libs/view/view.php, line 320
Controller::render() - CORE/cake/libs/controller/controller.php, line 664
IslandsController::lanai() - CORE/app/controllers/islands_controller.php, line 580
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 276
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 248
[main] - CORE/app/webroot/index.php, line 84

Showing Page 1 of 1

:

Have questions? Call your Hawaiian Experts today at 866-96-ALOHA (2-5642)