Warning (512): SQL Error: 1054: Unknown column 'index.html' in 'where clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
$sql = "SELECT COUNT(*) AS `count` FROM `itens` AS `Item` WHERE `Item`.`id` IN (select item_id from exames_itens where exame_id = `index`.`html`) " $error = "1054: Unknown column 'index.html' in 'where 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 337 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 647 Model::find() - CORE/cake/libs/model/model.php, line 1963 Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1066 EspecialidadesController::itens() - APP/controllers/especialidades_controller.php, line 23 Object::dispatchMethod() - CORE/cake/libs/object.php, line 119 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 88
Query: SELECT COUNT(*) AS `count` FROM `itens` AS `Item` WHERE `Item`.`id` IN (select item_id from exames_itens where exame_id = `index`.`html`)
Query: SELECT `Item`.`id`, `Item`.`imagem`, `Item`.`referencia`, `Item`.`nome`, `Item`.`descricao` FROM `itens` AS `Item` WHERE `Item`.`id` IN (select item_id from exames_itens where exame_id = `index`.`html`) LIMIT 10
Warning (2): Invalid argument supplied for foreach() [APP/views/especialidades/itens.ctp, line 21]
$___viewFn = "/home2/mtwems/pagina/app/views/especialidades/itens.ctp" $___dataForView = array( "especialidade" => array( "Especialidade" => array(), "Exame" => array() ), "exames" => array( array(), array(), array(), array() ), "nome_exame" => false, "itens" => false ) $loadHelpers = true $cached = false $loadedHelpers = array( "Html" => HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/especialidades/itens/4/index.html" HtmlHelper::$params = array HtmlHelper::$action = "itens" 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, "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 = "/especialidades/itens/4/index.html" AjaxHelper::$params = array AjaxHelper::$action = "itens" 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 = "/especialidades/itens/4/index.html" JavascriptHelper::$params = array JavascriptHelper::$action = "itens" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL JavascriptHelper::$_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 = "/especialidades/itens/4/index.html" FormHelper::$params = array FormHelper::$action = "itens" 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 = NULL PaginatorHelper::$options = array PaginatorHelper::$base = "" PaginatorHelper::$webroot = "/" PaginatorHelper::$themeWeb = NULL PaginatorHelper::$here = "/especialidades/itens/4/index.html" PaginatorHelper::$params = array PaginatorHelper::$action = "itens" 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, "Session" => SessionHelper SessionHelper::$helpers = NULL SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "b260d25dcd9c138e5e653c28eaa88044" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = NULL SessionHelper::$time = 1328637299 SessionHelper::$sessionTime = false SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_log = NULL SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/especialidades/itens/4/index.html" SessionHelper::$params = array SessionHelper::$action = "itens" SessionHelper::$data = NULL SessionHelper::$themeWeb = NULL SessionHelper::$plugin = NULL ) $helper = "Session" $camelBackedHelper = "session" $html = HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/especialidades/itens/4/index.html" HtmlHelper::$params = array HtmlHelper::$action = "itens" 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 $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 = "/especialidades/itens/4/index.html" AjaxHelper::$params = array AjaxHelper::$action = "itens" 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 = "/especialidades/itens/4/index.html" JavascriptHelper::$params = array JavascriptHelper::$action = "itens" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL JavascriptHelper::$_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 = "/especialidades/itens/4/index.html" FormHelper::$params = array FormHelper::$action = "itens" 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 = NULL PaginatorHelper::$options = array PaginatorHelper::$base = "" PaginatorHelper::$webroot = "/" PaginatorHelper::$themeWeb = NULL PaginatorHelper::$here = "/especialidades/itens/4/index.html" PaginatorHelper::$params = array PaginatorHelper::$action = "itens" 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 $session = SessionHelper SessionHelper::$helpers = NULL SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "b260d25dcd9c138e5e653c28eaa88044" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = NULL SessionHelper::$time = 1328637299 SessionHelper::$sessionTime = false SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_log = NULL SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/especialidades/itens/4/index.html" SessionHelper::$params = array SessionHelper::$action = "itens" SessionHelper::$data = NULL SessionHelper::$themeWeb = NULL SessionHelper::$plugin = NULL $especialidade = array( "Especialidade" => array( "id" => "4", "nome" => "Ginecologia", "descricao" => "Texto sobre Ginecologia", "imagem" => "icoGinecologia.jpg" ), "Exame" => array( array(), array(), array(), array() ) ) $exames = array( array( "Exame" => array(), "Especialidade" => array(), "Item" => array() ), array( "Exame" => array(), "Especialidade" => array(), "Item" => array() ), array( "Exame" => array(), "Especialidade" => array(), "Item" => array() ), array( "Exame" => array(), "Especialidade" => array(), "Item" => array() ) ) $nome_exame = false $itens = false $exame = array( "Exame" => array( "id" => "26", "nome" => "Equipamentos", "descricao" => "Texto sobre Equipamentos", "especialidade_id" => "4" ), "Especialidade" => array( "id" => "4", "nome" => "Ginecologia", "descricao" => "Texto sobre Ginecologia", "imagem" => "icoGinecologia.jpg" ), "Item" => array() )
<h2><?php echo $nome_exame['Exame']['nome']; ?></h2><?php foreach ($itens as $item): ?>
include - APP/views/especialidades/itens.ctp, line 21 View::_render() - CORE/cake/libs/view/view.php, line 662 View::render() - CORE/cake/libs/view/view.php, line 376 Controller::render() - CORE/cake/libs/controller/controller.php, line 799 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 230 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 88
© 2009 Europa Médico Service
