Warning (512)SQL Error: 1054: Unknown column 'Date.destination_id' in 'on clause'CORE/cake/libs/model/datasources/dbo_source.php , line 525 ]
Code |
Context $sql = "SELECT COUNT(*) AS `count` FROM `dates` AS `Date` LEFT JOIN `destinations` AS `Destination` ON (`Date`.`destination_id` = `Destination`.`id`) WHERE 1 = 1 "
$error = "1054: Unknown column 'Date.destination_id' in 'on clause'"
$out = null $out = null; if ($error) { trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING); DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 525
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 336
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 653
Model::find() - CORE/cake/libs/model/model.php, line 1988
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1070
Scaffold::__scaffoldIndex() - CORE/cake/libs/controller/scaffold.php, line 225
Scaffold::__scaffold() - CORE/cake/libs/controller/scaffold.php, line 409
Scaffold::__construct() - CORE/cake/libs/controller/scaffold.php, line 175
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 217
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88 Query: SELECT COUNT(*) AS `count` FROM `dates` AS `Date` LEFT JOIN `destinations` AS `Destination` ON (`Date`.`destination_id` = `Destination`.`id`) WHERE 1 = 1
Query: SELECT `Date`.`id`, `Date`.`name`, `Date`.`description`, `Date`.`created`, `Date`.`modified`, `Date`.`seo`, `Destination`.`id`, `Destination`.`name`, `Destination`.`description`, `Destination`.`created`, `Destination`.`modified`, `Destination`.`municipio_id`, `Destination`.`departamento_id`, `Destination`.`seo` FROM `dates` AS `Date` LEFT JOIN `destinations` AS `Destination` ON (`Date`.`destination_id` = `Destination`.`id`) WHERE 1 = 1 LIMIT 20
GoGuate - Scaffold :: Index :: Dates
Meet Guatemala
Land where men, nature, and time have coincided and where they dwell together for ever. More than 3000 years ago a people endowed with extraordinary skills formed one of the most well known and most respected civilizations in history, the Maya
Dates
Page 0 of 1, showing 1 records out of total, starting on record 0, ending on
Id Name Description Created Modified Seo Actions
Warning (2)CORE/cake/libs/view/scaffolds/index.ctp , line 41 ]
Code |
Context $___viewFn = "/var/www/clients/client1/web7/web/cake/libs/view/scaffolds/index.ctp"
$___dataForView = array(
"modelClass" => "Date",
"primaryKey" => "id",
"displayField" => "name",
"singularVar" => "date",
"pluralVar" => "dates",
"singularHumanName" => "Date",
"pluralHumanName" => "Dates",
"scaffoldFields" => array(
"id",
"name",
"description",
"created",
"modified",
"seo"
),
"associations" => array(
"belongsTo" => array()
),
"dates" => false,
"cakeDebug" => DatesController
DatesController::$name = "Dates"
DatesController::$helpers = array
DatesController::$scaffold = NULL
DatesController::$here = "/dates"
DatesController::$webroot = "/"
DatesController::$action = "index"
DatesController::$uses = false
DatesController::$params = array
DatesController::$data = NULL
DatesController::$paginate = array
DatesController::$viewPath = "dates"
DatesController::$layoutPath = NULL
DatesController::$viewVars = array
DatesController::$pageTitle = "Scaffold :: Index :: Dates"
DatesController::$modelNames = array
DatesController::$base = ""
DatesController::$layout = "default"
DatesController::$autoRender = false
DatesController::$autoLayout = true
DatesController::$Component = Component object
DatesController::$components = array
DatesController::$view = "scaffold"
DatesController::$ext = ".ctp"
DatesController::$output = NULL
DatesController::$plugin = NULL
DatesController::$cacheAction = false
DatesController::$persistModel = false
DatesController::$passedArgs = array
DatesController::$methods = array
DatesController::$modelClass = "Date"
DatesController::$modelKey = "date"
DatesController::$validationErrors = NULL
DatesController::$_log = NULL
DatesController::$Session = SessionComponent object
DatesController::$Date = Date object
DatesController::$theme = NULL
)
$loadHelpers = true
$cached = false
$loadedHelpers = array(
"Html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/dates"
HtmlHelper::$params = array
HtmlHelper::$action = "index"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
"Form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/dates"
FormHelper::$params = array
FormHelper::$action = "index"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object,
"Paginator" => PaginatorHelper
PaginatorHelper::$helpers = array
PaginatorHelper::$__defaultModel = "Date"
PaginatorHelper::$options = array
PaginatorHelper::$base = ""
PaginatorHelper::$webroot = "/"
PaginatorHelper::$themeWeb = NULL
PaginatorHelper::$here = "/dates"
PaginatorHelper::$params = array
PaginatorHelper::$action = "index"
PaginatorHelper::$plugin = NULL
PaginatorHelper::$data = NULL
PaginatorHelper::$namedArgs = NULL
PaginatorHelper::$argSeparator = NULL
PaginatorHelper::$validationErrors = NULL
PaginatorHelper::$tags = array
PaginatorHelper::$__tainted = NULL
PaginatorHelper::$__cleaned = NULL
PaginatorHelper::$_log = NULL
PaginatorHelper::$Html = HtmlHelper object
PaginatorHelper::$Ajax = AjaxHelper object,
"Ajax" => AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/dates"
AjaxHelper::$params = array
AjaxHelper::$action = "index"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object,
"Javascript" => JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/dates"
JavascriptHelper::$params = array
JavascriptHelper::$action = "index"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
"Session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "830f04d7d2e0c57449ec82e7bc486369"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1337575276
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/dates"
SessionHelper::$params = array
SessionHelper::$action = "index"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$helper = "Session"
$camelBackedHelper = "session"
$html = HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/dates"
HtmlHelper::$params = array
HtmlHelper::$action = "index"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$form = FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/dates"
FormHelper::$params = array
FormHelper::$action = "index"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object
$paginator = PaginatorHelper
PaginatorHelper::$helpers = array
PaginatorHelper::$__defaultModel = "Date"
PaginatorHelper::$options = array
PaginatorHelper::$base = ""
PaginatorHelper::$webroot = "/"
PaginatorHelper::$themeWeb = NULL
PaginatorHelper::$here = "/dates"
PaginatorHelper::$params = array
PaginatorHelper::$action = "index"
PaginatorHelper::$plugin = NULL
PaginatorHelper::$data = NULL
PaginatorHelper::$namedArgs = NULL
PaginatorHelper::$argSeparator = NULL
PaginatorHelper::$validationErrors = NULL
PaginatorHelper::$tags = array
PaginatorHelper::$__tainted = NULL
PaginatorHelper::$__cleaned = NULL
PaginatorHelper::$_log = NULL
PaginatorHelper::$Html = HtmlHelper object
PaginatorHelper::$Ajax = AjaxHelper object
$ajax = AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/dates"
AjaxHelper::$params = array
AjaxHelper::$action = "index"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object
$javascript = JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/dates"
JavascriptHelper::$params = array
JavascriptHelper::$action = "index"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$session = SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "830f04d7d2e0c57449ec82e7bc486369"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1337575276
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/dates"
SessionHelper::$params = array
SessionHelper::$action = "index"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$modelClass = "Date"
$primaryKey = "id"
$displayField = "name"
$singularVar = "date"
$pluralVar = "dates"
$singularHumanName = "Date"
$pluralHumanName = "Dates"
$scaffoldFields = array(
"id",
"name",
"description",
"created",
"modified",
"seo"
)
$associations = array(
"belongsTo" => array(
"Destination" => array()
)
)
$dates = false
$cakeDebug = DatesController
DatesController::$name = "Dates"
DatesController::$helpers = array
DatesController::$scaffold = NULL
DatesController::$here = "/dates"
DatesController::$webroot = "/"
DatesController::$action = "index"
DatesController::$uses = false
DatesController::$params = array
DatesController::$data = NULL
DatesController::$paginate = array
DatesController::$viewPath = "dates"
DatesController::$layoutPath = NULL
DatesController::$viewVars = array
DatesController::$pageTitle = "Scaffold :: Index :: Dates"
DatesController::$modelNames = array
DatesController::$base = ""
DatesController::$layout = "default"
DatesController::$autoRender = false
DatesController::$autoLayout = true
DatesController::$Component = Component object
DatesController::$components = array
DatesController::$view = "scaffold"
DatesController::$ext = ".ctp"
DatesController::$output = NULL
DatesController::$plugin = NULL
DatesController::$cacheAction = false
DatesController::$persistModel = false
DatesController::$passedArgs = array
DatesController::$methods = array
DatesController::$modelClass = "Date"
DatesController::$modelKey = "date"
DatesController::$validationErrors = NULL
DatesController::$_log = NULL
DatesController::$Session = SessionComponent object
DatesController::$Date = Date object
DatesController::$theme = NULL
$_field = "seo"
$i = 0 <?php $i = 0; foreach (${$pluralVar} as ${$singularVar}): include - CORE/cake/libs/view/scaffolds/index.ctp, line 41
View::_render() - CORE/cake/libs/view/view.php, line 666
View::render() - CORE/cake/libs/view/view.php, line 376
Controller::render() - CORE/cake/libs/controller/controller.php, line 803
Scaffold::__scaffoldIndex() - CORE/cake/libs/controller/scaffold.php, line 226
Scaffold::__scaffold() - CORE/cake/libs/controller/scaffold.php, line 409
Scaffold::__construct() - CORE/cake/libs/controller/scaffold.php, line 175
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 217
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
© GoGuate 2010. All rights reserved.
hi@goguate.com
+(502) 7763-0068 & +(502) 5292-6036
14 av A 3-35 Zona 1, Quetzaltenango
(default) 14 queries took 6 ms
Nr Query Error Affected Num. rows Took (ms)
1 DESCRIBE `dates` 6 6 1 2 DESCRIBE `destinations` 8 8 1 3 DESCRIBE `municipios` 2 2 0 4 DESCRIBE `departamentos` 2 2 0 5 DESCRIBE `schools` 7 7 0 6 DESCRIBE `hotels` 7 7 1 7 DESCRIBE `restaurants` 7 7 1 8 DESCRIBE `packages` 7 7 0 9 DESCRIBE `operators` 8 8 0 10 DESCRIBE `destinations_packages` 2 2 0 11 DESCRIBE `activities` 6 6 1 12 DESCRIBE `activities_destinations` 2 2 0 13 SELECT COUNT(*) AS `count` FROM `dates` AS `Date` LEFT JOIN `destinations` AS `Destination` ON (`Date`.`destination_id` = `Destination`.`id`) WHERE 1 = 1 1054: Unknown column 'Date.destination_id' in 'on clause' 0 14 SELECT `Date`.`id`, `Date`.`name`, `Date`.`description`, `Date`.`created`, `Date`.`modified`, `Date`.`seo`, `Destination`.`id`, `Destination`.`name`, `Destination`.`description`, `Destination`.`created`, `Destination`.`modified`, `Destination`.`municipio_id`, `Destination`.`departamento_id`, `Destination`.`seo` FROM `dates` AS `Date` LEFT JOIN `destinations` AS `Destination` ON (`Date`.`destination_id` = `Destination`.`id`) WHERE 1 = 1 LIMIT 20 1054: Unknown column 'Date.destination_id' in 'on clause' 1
hi@goguate.com
+(502) 7763-0068 & +(502) 5292-6036
14 av A 3-35 Zona 1, Quetzaltenango
