Warning (512): Erro: 1055: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'estramet_db.ObraGaleria.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [CORE/cake/libs/model/datasources/dbo_source.php, line 681]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 `Obra`.`id`, `Obra`.`title`, `Obra`.`cidade`, `ObraGaleria`.`title`, `ObraGaleria`.`image`, `ObraSegmento`.`id`, `ObraSegmento`.`name`, `ObraTipo`.`id`, `ObraTipo`.`name`, COUNT( ObraGaleria.id ) as fotos FROM `obras` AS `Obra` LEFT JOIN `obra_segmentos` AS `ObraSegmento` ON (`ObraSegmento`.`id` = `Obra`.`obra_segmento_id`) LEFT JOIN `obra_tipos` AS `ObraTipo` ON (`ObraTipo`.`id` = `Obra`.`obra_tipo_id`) LEFT JOIN `obra_galerias` AS `ObraGaleria` ON (`Obra`.`id` = `ObraGaleria`.`obra_id`) WHERE `Obra`.`ativo` = '1' GROUP BY `Obra`.`id` ORDER BY `Obra`.`created` DESC LIMIT 20" $error = "1055: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'estramet_db.ObraGaleria.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by" $out = nullDboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 681 DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266 DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 410 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 820 Model::find() - CORE/cake/libs/model/model.php, line 2093 AppModel::find() - APP/app_model.php, line 66 Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1228 ObrasController::index() - APP/controllers/obras_controller.php, line 35 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 [main] - APP/webroot/index.php, line 145
Query: SELECT `Obra`.`id`, `Obra`.`title`, `Obra`.`cidade`, `ObraGaleria`.`title`, `ObraGaleria`.`image`, `ObraSegmento`.`id`, `ObraSegmento`.`name`, `ObraTipo`.`id`, `ObraTipo`.`name`, COUNT( ObraGaleria.id ) as fotos FROM `obras` AS `Obra` LEFT JOIN `obra_segmentos` AS `ObraSegmento` ON (`ObraSegmento`.`id` = `Obra`.`obra_segmento_id`) LEFT JOIN `obra_tipos` AS `ObraTipo` ON (`ObraTipo`.`id` = `Obra`.`obra_tipo_id`) LEFT JOIN `obra_galerias` AS `ObraGaleria` ON (`Obra`.`id` = `ObraGaleria`.`obra_id`) WHERE `Obra`.`ativo` = '1' GROUP BY `Obra`.`id` ORDER BY `Obra`.`created` DESC LIMIT 20
Estrametal Construções Ltda.
Warning (2): Invalid argument supplied for foreach() [APP/views/obras/index.ctp, line 29]Code | Context<ul class="lista"><?php foreach ( $obras as $obra ) :$___viewFn = "/home/estramet/public_html/app/views/obras/index.ctp" $___dataForView = array( "logged" => false, "section" => "global", "languages" => array( "por" => "Trocar Idioma" ), "language" => "pt-br", "protocolo" => "http", "webroot" => "http://www.estrametal.com.br/", "cookieDisabled" => true, "url" => "obras_realizadas", "diario" => null, "diarioLogado" => false, "linhaTempo" => array(), "usuario" => null, "produtos" => array( array(), array(), array() ), "obras" => false, "segmentosToSelect" => array( "Indústrias", "Comércio e Serviço", "Esportiva / Cultural" ), "tiposToSelect" => array( "Estruturas Metálicas", "Estruturas em concreto", "Pisos Industriais" ), "static_url" => "/" ) $loadHelpers = true $cached = false $jqueryEngine = JqueryEngineHelper JqueryEngineHelper::$_optionMap = array JqueryEngineHelper::$_callbackArguments = array JqueryEngineHelper::$jQueryObject = "$" JqueryEngineHelper::$useNative = true JqueryEngineHelper::$selection = NULL JqueryEngineHelper::$bufferedMethods = array JqueryEngineHelper::$helpers = NULL JqueryEngineHelper::$base = "" JqueryEngineHelper::$webroot = "/" JqueryEngineHelper::$theme = NULL JqueryEngineHelper::$here = "/obras_realizadas" JqueryEngineHelper::$params = array JqueryEngineHelper::$action = "index" JqueryEngineHelper::$plugin = NULL JqueryEngineHelper::$data = NULL JqueryEngineHelper::$namedArgs = NULL JqueryEngineHelper::$argSeparator = NULL JqueryEngineHelper::$validationErrors = NULL JqueryEngineHelper::$tags = array JqueryEngineHelper::$__tainted = NULL JqueryEngineHelper::$__cleaned = NULL $js = JsHelper JsHelper::$bufferScripts = true JsHelper::$helpers = array JsHelper::$__jsVars = array JsHelper::$__bufferedScripts = array JsHelper::$__engineName = "JqueryEngine" JsHelper::$setVariable = "app" JsHelper::$base = "" JsHelper::$webroot = "/" JsHelper::$theme = NULL JsHelper::$here = "/obras_realizadas" JsHelper::$params = array JsHelper::$action = "index" JsHelper::$plugin = NULL JsHelper::$data = NULL JsHelper::$namedArgs = NULL JsHelper::$argSeparator = NULL JsHelper::$validationErrors = NULL JsHelper::$tags = array JsHelper::$__tainted = NULL JsHelper::$__cleaned = NULL JsHelper::$Html = HtmlHelper object JsHelper::$Form = FormHelper object JsHelper::$JqueryEngine = JqueryEngineHelper object $paginator = PaginatorHelper PaginatorHelper::$helpers = array PaginatorHelper::$__defaultModel = NULL PaginatorHelper::$_ajaxHelperClass = "Js" PaginatorHelper::$options = array PaginatorHelper::$base = "" PaginatorHelper::$webroot = "/" PaginatorHelper::$theme = NULL PaginatorHelper::$here = "/obras_realizadas" 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::$Html = HtmlHelper object PaginatorHelper::$Js = JsHelper object $textos = TextosHelper TextosHelper::$helpers = array TextosHelper::$base = "" TextosHelper::$webroot = "/" TextosHelper::$theme = NULL TextosHelper::$here = "/obras_realizadas" TextosHelper::$params = array TextosHelper::$action = "index" TextosHelper::$plugin = NULL TextosHelper::$data = NULL TextosHelper::$namedArgs = NULL TextosHelper::$argSeparator = NULL TextosHelper::$validationErrors = NULL TextosHelper::$tags = array TextosHelper::$__tainted = NULL TextosHelper::$__cleaned = NULL TextosHelper::$Html = HtmlHelper object $number = NumberHelper NumberHelper::$_currencies = array NumberHelper::$_currencyDefaults = array NumberHelper::$helpers = NULL NumberHelper::$base = "" NumberHelper::$webroot = "/" NumberHelper::$theme = NULL NumberHelper::$here = "/obras_realizadas" NumberHelper::$params = array NumberHelper::$action = "index" NumberHelper::$plugin = NULL NumberHelper::$data = NULL NumberHelper::$namedArgs = NULL NumberHelper::$argSeparator = NULL NumberHelper::$validationErrors = NULL NumberHelper::$tags = array NumberHelper::$__tainted = NULL NumberHelper::$__cleaned = NULL $time = TimeHelper TimeHelper::$helpers = NULL TimeHelper::$base = "" TimeHelper::$webroot = "/" TimeHelper::$theme = NULL TimeHelper::$here = "/obras_realizadas" TimeHelper::$params = array TimeHelper::$action = "index" TimeHelper::$plugin = NULL TimeHelper::$data = NULL TimeHelper::$namedArgs = NULL TimeHelper::$argSeparator = NULL TimeHelper::$validationErrors = NULL TimeHelper::$tags = array TimeHelper::$__tainted = NULL TimeHelper::$__cleaned = NULL $formatacao = FormatacaoHelper FormatacaoHelper::$helpers = array FormatacaoHelper::$base = "" FormatacaoHelper::$webroot = "/" FormatacaoHelper::$theme = NULL FormatacaoHelper::$here = "/obras_realizadas" FormatacaoHelper::$params = array FormatacaoHelper::$action = "index" FormatacaoHelper::$plugin = NULL FormatacaoHelper::$data = NULL FormatacaoHelper::$namedArgs = NULL FormatacaoHelper::$argSeparator = NULL FormatacaoHelper::$validationErrors = NULL FormatacaoHelper::$tags = array FormatacaoHelper::$__tainted = NULL FormatacaoHelper::$__cleaned = NULL FormatacaoHelper::$Time = TimeHelper object FormatacaoHelper::$Number = NumberHelper object $session = SessionHelper SessionHelper::$helpers = array SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "medium" SessionHelper::$time = 1737290989 SessionHelper::$sessionTime = 1737314989 SessionHelper::$cookieLifeTime = 1440000 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$host = NULL SessionHelper::$timeout = NULL SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/obras_realizadas" SessionHelper::$params = array SessionHelper::$action = "index" SessionHelper::$data = NULL SessionHelper::$theme = NULL SessionHelper::$plugin = NULL $form = FormHelper FormHelper::$helpers = array FormHelper::$fieldset = array FormHelper::$__options = array FormHelper::$fields = array FormHelper::$requestType = "get" FormHelper::$defaultModel = "Obra" FormHelper::$_inputDefaults = array FormHelper::$base = "" FormHelper::$webroot = "/" FormHelper::$theme = NULL FormHelper::$here = "/obras_realizadas" 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::$Html = HtmlHelper object $html = HtmlHelper HtmlHelper::$tags = array HtmlHelper::$_crumbs = array HtmlHelper::$__includedScripts = array HtmlHelper::$_scriptBlockOptions = array HtmlHelper::$__docTypes = array HtmlHelper::$helpers = NULL HtmlHelper::$base = "" HtmlHelper::$webroot = "/" HtmlHelper::$theme = NULL HtmlHelper::$here = "/obras_realizadas" HtmlHelper::$params = array HtmlHelper::$action = "index" HtmlHelper::$plugin = NULL HtmlHelper::$data = NULL HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL $logged = false $section = "global" $languages = array( "por" => "Trocar Idioma" ) $language = "pt-br" $protocolo = "http" $webroot = "http://www.estrametal.com.br/" $cookieDisabled = true $url = "obras_realizadas" $diario = null $diarioLogado = false $linhaTempo = array() $usuario = null $produtos = array( array( "Produto" => array() ), array( "Produto" => array() ), array( "Produto" => array() ) ) $obras = false $segmentosToSelect = array( "Indústrias", "Comércio e Serviço", "Esportiva / Cultural" ) $tiposToSelect = array( "Estruturas Metálicas", "Estruturas em concreto", "Pisos Industriais" ) $static_url = "/" $titulo = "Obras Realizadas"include - APP/views/obras/index.ctp, line 29 View::_render() - CORE/cake/libs/view/view.php, line 723 View::render() - CORE/cake/libs/view/view.php, line 419 Controller::render() - CORE/cake/libs/controller/controller.php, line 913 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 [main] - APP/webroot/index.php, line 145
Acesse para acompanhar o andamento de obras.
© Copyright. Todos direitos reservados à Estrametal Estruturas Metálicas.