Query: SELECT `Experience`.`id`, `Experience`.`title`, `Experience`.`country_id`, `Experience`.`state_id`, `Experience`.`city_id`, `Experience`.`topic_id`, `Experience`.`review`, `Experience`.`rating`, `Experience`.`date_visit`, `Experience`.`created`, `Experience`.`modified`, `Experience`.`user_id`, `Experience`.`address`, `Experience`.`phone`, `Experience`.`status`, `Experience`.`s_votes`, `Experience`.`point_rating`, `Experience`.`date_rating`, `Experience`.`old_id`, `Experience`.`zip`, `Experience`.`todo_id` FROM `experiences` AS `Experience` WHERE (`Experience`.`status`='Active' AND `Todo`.`status`='Active')
Warning (512): SQL Error: 1054: Unknown column 'Todo.status' in 'where clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 463]
Context |
Code$sql = "SELECT `Experience`.`id`, `Experience`.`title`, `Experience`.`country_id`, `Experience`.`state_id`, `Experience`.`city_id`, `Experience`.`topic_id`, `Experience`.`review`, `Experience`.`rating`, `Experience`.`date_visit`, `Experience`.`created`, `Experience`.`modified`, `Experience`.`user_id`, `Experience`.`address`, `Experience`.`phone`, `Experience`.`status`, `Experience`.`s_votes`, `Experience`.`point_rating`, `Experience`.`date_rating`, `Experience`.`old_id`, `Experience`.`zip`, `Experience`.`todo_id` FROM `experiences` AS `Experience` WHERE (`Experience`.`status`='Active' AND `Todo`.`status`='Active') "
$error = "1054: Unknown column 'Todo.status' in 'where clause'"
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 1385
DestinationsController::model_limit() - CORE/app/controllers/destinations_controller.php, line 77
DestinationsController::get_drop_inline_e() - CORE/app/controllers/destinations_controller.php, line 107
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 354
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 334
Object::requestAction() - CORE/cake/libs/object.php, line 101
include - CORE/app/views/elements/destinations.thtml, line 37
View::_render() - CORE/cake/libs/view/view.php, line 772
View::renderElement() - CORE/cake/libs/view/view.php, line 400
include - CORE/app/views/experiences/summary.thtml, line 4
View::_render() - CORE/cake/libs/view/view.php, line 772
View::render() - CORE/cake/libs/view/view.php, line 337
Controller::render() - CORE/cake/libs/controller/controller.php, line 663
ExperiencesController::summary() - CORE/app/controllers/experiences_controller.php, line 78
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 354
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 334
[main] - CORE/app/webroot/index.php, line 89
Warning (2): Invalid argument supplied for foreach() [CORE/app/app_model.php, line 431]
Context |
Code$table = "Experience"
$field = "country_id"
$data = false
$arr = array()
}
}
} else {
foreach ($data as $val) {
if (isset($val[$table][$field])) {
AppModel::get_simple_value() - CORE/app/app_model.php, line 431
DestinationsController::model_limit() - CORE/app/controllers/destinations_controller.php, line 78
DestinationsController::get_drop_inline_e() - CORE/app/controllers/destinations_controller.php, line 107
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 354
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 334
Object::requestAction() - CORE/cake/libs/object.php, line 101
include - CORE/app/views/elements/destinations.thtml, line 37
View::_render() - CORE/cake/libs/view/view.php, line 772
View::renderElement() - CORE/cake/libs/view/view.php, line 400
include - CORE/app/views/experiences/summary.thtml, line 4
View::_render() - CORE/cake/libs/view/view.php, line 772
View::render() - CORE/cake/libs/view/view.php, line 337
Controller::render() - CORE/cake/libs/controller/controller.php, line 663
ExperiencesController::summary() - CORE/app/controllers/experiences_controller.php, line 78
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 354
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 334
[main] - CORE/app/webroot/index.php, line 89
Query: SELECT `Experience`.`id`, `Experience`.`title`, `Experience`.`country_id`, `Experience`.`state_id`, `Experience`.`city_id`, `Experience`.`topic_id`, `Experience`.`review`, `Experience`.`rating`, `Experience`.`date_visit`, `Experience`.`created`, `Experience`.`modified`, `Experience`.`user_id`, `Experience`.`address`, `Experience`.`phone`, `Experience`.`status`, `Experience`.`s_votes`, `Experience`.`point_rating`, `Experience`.`date_rating`, `Experience`.`old_id`, `Experience`.`zip`, `Experience`.`todo_id` FROM `experiences` AS `Experience` WHERE (`Experience`.`status`='Active' AND `Todo`.`status`='Active') AND `Experience`.`country_id`='0'
