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 ') LEFT JOIN `cms_5_business` AS `Business` ON (`BusinessEvent`.`business_id` = `' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
$sql = "SELECT `BusinessEvent`.`id`, `BusinessEvent`.`business_id`, `BusinessEvent`.`event_id`, `Business`.`id`, `Business`.`account_id`, `Business`.`name`, `Business`.`phone`, `Business`.`fax`, `Business`.`email`, `Business`.`url`, `Business`.`logo`, `Business`.`address1`, `Business`.`address2`, `Business`.`address3`, `Business`.`city`, `Business`.`state`, `Business`.`zip`, `Business`.`directions`, `Business`.`seo_title`, `Business`.`seo_keywords`, `Business`.`seo_description`, `Business`.`twitter_url`, `Business`.`facebook_url`, `Business`.`youtube_url`, `Business`.`flickr_url`, `Business`.`category_id`, `Business`.`is_premium`, `Business`.`status`, `Business`.`created`, `Business`.`created_by_user`, `Business`.`modified`, `Business`.`last_updated_by_user`, `Business`.`state_id`, `Business`.`slug`, `Event`.`id`, `Event`.`account_id`, `Event`.`title`, `Event`.`summary`, `Event`.`description`, `Event`.`facebook_url`, `Event`.`domain_url`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`close_date`, `Event`.`close_note`, `Event`.`active_flag`, `Event`.`recurring_event_flag`, `Event`.`recurring_type`, `Event`.`recurring_interval`, `Event`.`recurring_day`, `Event`.`total_slots`, `Event`.`require_payment_flag`, `Event`.`payment_gateway_id`, `Event`.`amount`, `Event`.`credit_card_statement_description`, `Event`.`refund_policy`, `Event`.`routing_recipients`, `Event`.`auto_responder`, `Event`.`created`, `Event`.`created_by_user`, `Event`.`modified`, `Event`.`last_updated_by_user`, `Event`.`slug` FROM `cms_5_business_events` AS `BusinessEvent` inner JOIN events AS `Events` ON (`BusinessEvent`.`event_id` = `Events`.`id`) inner JOIN business_events AS `BusinessEvents` ON (`BusinessEvents`.`business_id` =) LEFT JOIN `cms_5_business` AS `Business` ON (`BusinessEvent`.`business_id` = `Business`.`id`) LEFT JOIN `cms_5_events` AS `Event` ON (`BusinessEvent`.`event_id` = `Event`.`id`) WHERE 1 = 1 "
$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 ') LEFT JOIN `cms_5_business` AS `Business` ON (`BusinessEvent`.`business_id` = `' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 526
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 337
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 654
Model::find() - CORE/cake/libs/model/model.php, line 2040
BusinessesController::view() - APP/controllers/businesses_controller.php, line 75
Object::dispatchMethod() - CORE/cake/libs/object.php, line 117
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193
[main] - APP/webroot/index_cake.php, line 87
Query: SELECT `BusinessEvent`.`id`, `BusinessEvent`.`business_id`, `BusinessEvent`.`event_id`, `Business`.`id`, `Business`.`account_id`, `Business`.`name`, `Business`.`phone`, `Business`.`fax`, `Business`.`email`, `Business`.`url`, `Business`.`logo`, `Business`.`address1`, `Business`.`address2`, `Business`.`address3`, `Business`.`city`, `Business`.`state`, `Business`.`zip`, `Business`.`directions`, `Business`.`seo_title`, `Business`.`seo_keywords`, `Business`.`seo_description`, `Business`.`twitter_url`, `Business`.`facebook_url`, `Business`.`youtube_url`, `Business`.`flickr_url`, `Business`.`category_id`, `Business`.`is_premium`, `Business`.`status`, `Business`.`created`, `Business`.`created_by_user`, `Business`.`modified`, `Business`.`last_updated_by_user`, `Business`.`state_id`, `Business`.`slug`, `Event`.`id`, `Event`.`account_id`, `Event`.`title`, `Event`.`summary`, `Event`.`description`, `Event`.`facebook_url`, `Event`.`domain_url`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`close_date`, `Event`.`close_note`, `Event`.`active_flag`, `Event`.`recurring_event_flag`, `Event`.`recurring_type`, `Event`.`recurring_interval`, `Event`.`recurring_day`, `Event`.`total_slots`, `Event`.`require_payment_flag`, `Event`.`payment_gateway_id`, `Event`.`amount`, `Event`.`credit_card_statement_description`, `Event`.`refund_policy`, `Event`.`routing_recipients`, `Event`.`auto_responder`, `Event`.`created`, `Event`.`created_by_user`, `Event`.`modified`, `Event`.`last_updated_by_user`, `Event`.`slug` FROM `cms_5_business_events` AS `BusinessEvent` inner JOIN events AS `Events` ON (`BusinessEvent`.`event_id` = `Events`.`id`) inner JOIN business_events AS `BusinessEvents` ON (`BusinessEvents`.`business_id` =) LEFT JOIN `cms_5_business` AS `Business` ON (`BusinessEvent`.`business_id` = `Business`.`id`) LEFT JOIN `cms_5_events` AS `Event` ON (`BusinessEvent`.`event_id` = `Event`.`id`) WHERE 1 = 1
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 '' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
$sql = "select * from cms_5_business_videos as business_videos where business_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 '' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 526
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 337
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 221
Model::query() - CORE/cake/libs/model/model.php, line 2369
BusinessesController::view() - APP/controllers/businesses_controller.php, line 84
Object::dispatchMethod() - CORE/cake/libs/object.php, line 117
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193
[main] - APP/webroot/index_cake.php, line 87
Query: select * from cms_5_business_videos as business_videos where business_id=
Query: select * from cms_5_business_attributes as business_attributes where business_id=
Warning (2): Invalid argument supplied for foreach() [APP/controllers/businesses_controller.php, line 93]
$amenities = array();
foreach ($business_attributes as $v) $amenities[$v['business_attributes']['id']] = $v['business_attributes']['attribute'];
BusinessesController::view() - APP/controllers/businesses_controller.php, line 93
Object::dispatchMethod() - CORE/cake/libs/object.php, line 117
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193
[main] - APP/webroot/index_cake.php, line 87
Query: select * from cms_5_business_hours as business_hours where business_id=
Query: select * from cms_5_business_specials as business_specials where business_id=
Query: select * from cms_5_business_pictures as business_pictures where business_id=
Query: select * from cms_5_business_videos as business_videos where business_id=
