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 `RoomPrice`.`price_type` = "brochure" GROUP BY `RoomPrice`.`room_type_id` ' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 673]

Code | Context

            $out = null;
            if ($error) {
                trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);

$sql	=	"SELECT `RoomPrice`.`room_type_id`, `RoomPriceValue`.`value` FROM `room_prices` AS `RoomPrice` JOIN roomprice_values AS `RoomPriceValue` ON (`RoomPriceValue`.`room_price_id` = `RoomPrice`.`id` AND `RoomPriceValue`.`currency_id` = 1)  WHERE `RoomPrice`.`trip_id` =  AND `RoomPrice`.`price_type` = "brochure"  GROUP BY `RoomPrice`.`room_type_id`  ORDER BY `RoomPrice`.`room_type_id` ASC "
$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 `RoomPrice`.`price_type` = "brochure"  GROUP BY `RoomPrice`.`room_type_id`  ' at line 1"
$out	=	null

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 673
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 263
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 407
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 812
Model::find() - CORE/cake/libs/model/model.php, line 2087
Trip::listPrices() - APP/models/trip.php, line 462
TripsController::view_plain() - APP/controllers/trips_controller.php, line 1106
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 91

Query: SELECT `RoomPrice`.`room_type_id`, `RoomPriceValue`.`value` FROM `room_prices` AS `RoomPrice` JOIN roomprice_values AS `RoomPriceValue` ON (`RoomPriceValue`.`room_price_id` = `RoomPrice`.`id` AND `RoomPriceValue`.`currency_id` = 1) WHERE `RoomPrice`.`trip_id` = AND `RoomPrice`.`price_type` = "brochure" GROUP BY `RoomPrice`.`room_type_id` ORDER BY `RoomPrice`.`room_type_id` ASC

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 `RoomPrice`.`price_type` = "current" GROUP BY `RoomPrice`.`room_type_id` O' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 673]

Code | Context

            $out = null;
            if ($error) {
                trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);

$sql	=	"SELECT `RoomPrice`.`room_type_id`, `RoomPriceValue`.`value` FROM `room_prices` AS `RoomPrice` JOIN roomprice_values AS `RoomPriceValue` ON (`RoomPriceValue`.`room_price_id` = `RoomPrice`.`id` AND `RoomPriceValue`.`currency_id` = 1)  WHERE `RoomPrice`.`trip_id` =  AND `RoomPrice`.`price_type` = "current"  GROUP BY `RoomPrice`.`room_type_id`  ORDER BY `RoomPrice`.`room_type_id` ASC "
$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 `RoomPrice`.`price_type` = "current"  GROUP BY `RoomPrice`.`room_type_id`  O' at line 1"
$out	=	null

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 673
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 263
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 407
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 812
Model::find() - CORE/cake/libs/model/model.php, line 2087
Trip::listPrices() - APP/models/trip.php, line 462
TripsController::view_plain() - APP/controllers/trips_controller.php, line 1107
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 91

Query: SELECT `RoomPrice`.`room_type_id`, `RoomPriceValue`.`value` FROM `room_prices` AS `RoomPrice` JOIN roomprice_values AS `RoomPriceValue` ON (`RoomPriceValue`.`room_price_id` = `RoomPrice`.`id` AND `RoomPriceValue`.`currency_id` = 1) WHERE `RoomPrice`.`trip_id` = AND `RoomPrice`.`price_type` = "current" GROUP BY `RoomPrice`.`room_type_id` ORDER BY `RoomPrice`.`room_type_id` ASC

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 ') WHERE 1 = 1 GROUP BY `RoomType`.`id`' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 673]

Code | Context

            $out = null;
            if ($error) {
                trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);

$sql	=	"SELECT `RoomType`.* FROM `room_types` AS `RoomType` JOIN rooms AS `Room` ON (`Room`.`room_type_id` = `RoomType`.`id` AND `Room`.`ship_configuration_id` =)  WHERE 1 = 1  GROUP BY `RoomType`.`id`  "
$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 ')  WHERE 1 = 1  GROUP BY `RoomType`.`id`' at line 1"
$out	=	null

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 673
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 263
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 407
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 812
Model::find() - CORE/cake/libs/model/model.php, line 2087
TripsController::view_plain() - APP/controllers/trips_controller.php, line 1124
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 91

Query: SELECT `RoomType`.* FROM `room_types` AS `RoomType` JOIN rooms AS `Room` ON (`Room`.`room_type_id` = `RoomType`.`id` AND `Room`.`ship_configuration_id` =) WHERE 1 = 1 GROUP BY `RoomType`.`id`

Warning (2): Invalid argument supplied for foreach() [APP/controllers/trips_controller.php, line 1133]

Code | Context

        foreach($roomTypeOrder as $roomTypeId)
        {
            foreach($roomTypes as $roomType)

$voyageNumber	=	"11128"
$trip	=	false
$stops	=	array()
$brochurePrices	=	array()
$currentPrices	=	array()
$roomTypes	=	false
$roomTypeOrder	=	array(
	1,
	2,
	8,
	7,
	6,
	5,
	4
)
$sortedRoomTypes	=	array()
$roomTypeId	=	1

TripsController::view_plain() - APP/controllers/trips_controller.php, line 1133
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 91

Details of Voyage #

Booking request Print

Click on underlined Ports of Call to see Yachting Land Adventures details

Date	Ports of Call	Arrive	Depart
22-FEB-2012, Wednesday	.
22-FEB-2012, Wednesday		Morning	10:00

Book Today and Save Specials

Class	USD
Government, Port, Document Issuance, Handling & Service fees	$0

"Book Today and Save" fares are capacity controlled and may change without notice. The fares are per person based on double occupancy. Single and third person rates are also available. SeaDream Yacht Club strongly recommends that all guests purchase travel insurance. The Travel Guard Insurance plan can be purchased for 8.75% of the total invoice

Brochure fare

Class	USD
Government, Port, Document Issuance, Handling & Service fees	$0

www.seadream.com

Details of Voyage #

Book Today and Save Specials

Brochure fare

Sign up for "Yacht Mail"

Book a Voyage

The Yachts

Lifestyle

More