Internal Server Error

Illuminate\Database\QueryException

vendor/laravel/framework/src/Illuminate/Database/Connection.php:838

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imoveis.empreendimento' in 'where clause' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: yoosit83_minhaimobiliaria, SQL: select count(*) as aggregate from `imoveis` where `imoveis`.`status` = ativo and `imoveis`.`finalidade` = venda and json_contains(`imoveis`.`empreendimento`, "pe_na_areia"))

LARAVEL 12.55.1
PHP 8.3.37
UNHANDLED
CODE 42S22
500
GET
https://www.portal.neraimob.com.br

Exception trace

10 vendor frames
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))
vendor/laravel/framework/src/Illuminate/Database/Connection.php:838
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))
vendor/laravel/framework/src/Illuminate/Database/Connection.php:794
Illuminate\Database\Connection->run(string, array, object(Closure))
vendor/laravel/framework/src/Illuminate/Database/Connection.php:411
Illuminate\Database\Connection->select(string, array, boolean)
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3505
Illuminate\Database\Query\Builder->runSelect()
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3490
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:4080
Illuminate\Database\Query\Builder->onceWithColumns(array, object(Closure))
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3489
Illuminate\Database\Query\Builder->get(array)
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:4004
Illuminate\Database\Query\Builder->aggregate(string, array)
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3932
Illuminate\Database\Query\Builder->count()
vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:2237
Illuminate\Database\Eloquent\Builder->__call(string, array)
app/Services/Listagem.php:221
216217        $caracs = [];218        foreach (Catalogo::CARACS as $slug => $c) {219            $q = self::query($intencao, $f, ['carac']);220            self::aplicarCarac($q, $slug);221            $caracs[] = ['slug' => $slug, 'label' => $c['label'], 'total' => $q->count()];222        }223224        return [225            'tipos'   => $tipos,226            'modulos' => $modulos->filter(fn ($m) => $m['total'] > 0 || in_array($m['id'], $f['modulo'] ?? []))->values(),227            'dorm'    => $dorm,228            'caracs'  => $caracs,229        ];230    }231232    /** Vocabulário da busca com sugestões (JSON embutido na página). */233
App\Services\Listagem::contagens(string, array)
app/Http/Controllers/Site/SiteController.php:65
60    public static function busca(string $intencao, array $filtros = []): array61    {62        return [63            'intencao' => $intencao,64            'filtros'  => $filtros,65            'opcoes'   => Listagem::contagens($intencao, $filtros),66            'vocab'    => Cache::remember('tpl.vocab', 600, fn () => Listagem::vocabulario()),67        ];68    }6970    public function quemSomos()71    {72        return view(app(TemplateManager::class)->view('quem-somos'), ['numeros' => self::numeros()]);73    }7475    public function proprietarios()76    {77
App\Http\Controllers\Site\SiteController::busca(string)
app/Http/Controllers/Site/SiteController.php:54
49        return view(app(TemplateManager::class)->view('home'), [50            'destaque' => $destaque,51            'cards'    => $cards,52            'vitrines' => $vitrines,53            'numeros'  => self::numeros(),54            'busca'    => $this->busca('comprar'),55            'banners'  => Banner::query()->where('ativo', true)->latest('id')->limit(5)->get(),56        ]);57    }5859    /** Dados da barra de busca (contagens + vocabulário de sugestões). */60    public static function busca(string $intencao, array $filtros = []): array61    {62        return [63            'intencao' => $intencao,64            'filtros'  => $filtros,65            'opcoes'   => Listagem::contagens($intencao, $filtros),66
47 vendor frames
App\Http\Controllers\Site\SiteController->home()
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
Illuminate\Routing\ControllerDispatcher->dispatch(object(Illuminate\Routing\Route), object(App\Http\Controllers\Site\SiteController), string)
vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
Illuminate\Routing\Route->runController()
vendor/laravel/framework/src/Illuminate/Routing/Route.php:211
Illuminate\Routing\Route->run()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:822
Illuminate\Routing\Router->Illuminate\Routing\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
Illuminate\Routing\Middleware\SubstituteBindings->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:87
Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:48
Illuminate\View\Middleware\ShareErrorsFromSession->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:120
Illuminate\Session\Middleware\StartSession->handleStatefulRequest(object(Illuminate\Http\Request), object(Illuminate\Session\Store), object(Closure))
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
Illuminate\Session\Middleware\StartSession->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:36
Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:74
Illuminate\Cookie\Middleware\EncryptCookies->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137
Illuminate\Pipeline\Pipeline->then(object(Closure))
vendor/laravel/framework/src/Illuminate/Routing/Router.php:821
Illuminate\Routing\Router->runRouteWithinStack(object(Illuminate\Routing\Route), object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Routing/Router.php:800
Illuminate\Routing\Router->runRoute(object(Illuminate\Http\Request), object(Illuminate\Routing\Route))
vendor/laravel/framework/src/Illuminate/Routing/Router.php:764
Illuminate\Routing\Router->dispatchToRoute(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Routing/Router.php:753
Illuminate\Routing\Router->dispatch(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200
Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31
Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:51
Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php:27
Illuminate\Http\Middleware\ValidatePostSize->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:109
Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php:61
Illuminate\Http\Middleware\HandleCors->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:58
Illuminate\Http\Middleware\TrustProxies->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php:22
Illuminate\Foundation\Http\Middleware\InvokeDeferredCallbacks->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php:26
Illuminate\Http\Middleware\ValidatePathEncoding->handle(object(Illuminate\Http\Request), object(Closure))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137
Illuminate\Pipeline\Pipeline->then(object(Closure))
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175
Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144
Illuminate\Foundation\Http\Kernel->handle(object(Illuminate\Http\Request))
vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1220
Illuminate\Foundation\Application->handleRequest(object(Illuminate\Http\Request))
index.php:20
1516// Bootstrap Laravel and handle the request...17/** @var Application $app */18$app = require_once __DIR__.'/bootstrap/app.php';1920$app->handleRequest(Request::capture());21

Queries

mysql
select * from `sessions` where `id` = '8WEV89DFhaGguNljgbvFOZsfFWhvZZpp9iIye24A' limit 1
2.4ms
mysql
select * from `imoveis` where `imoveis`.`status` = 'ativo' and `destaque` = 1 order by `id` desc limit 1
0.57ms
mysql
select * from `imovel_imagens` where `imovel_imagens`.`imovel_id` in (20) order by `id` asc
0.56ms
mysql
select `id`, `nome`, `cidade_id`, `numero`, `zona` from `bairros` where `bairros`.`id` in (3)
0.33ms
mysql
select `id`, `nome`, `uf` from `cidades` where `cidades`.`id` in (5)
0.22ms
mysql
select * from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`id` != 20 order by `imoveis`.`destaque` desc, `imoveis`.`id` desc limit 8
0.31ms
mysql
select * from `imovel_imagens` where `imovel_imagens`.`imovel_id` in (4, 21, 22) order by `id` asc
0.21ms
mysql
select `id`, `nome`, `cidade_id`, `numero`, `zona` from `bairros` where `bairros`.`id` in (1, 2)
0.1ms
mysql
select `id`, `nome`, `uf` from `cidades` where `cidades`.`id` in (1)
0.07ms
mysql
select * from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' and exists (select * from `imovel_imagens` where `imoveis`.`id` = `imovel_imagens`.`imovel_id`) order by `imoveis`.`id` desc limit 1
0.36ms
mysql
select * from `imovel_imagens` where `imovel_imagens`.`imovel_id` in (21) order by `id` asc
0.15ms
mysql
select `id`, `nome`, `cidade_id`, `numero`, `zona` from `bairros` where `bairros`.`id` in (2)
0.08ms
mysql
select `id`, `nome`, `uf` from `cidades` where `cidades`.`id` in (1)
0.05ms
mysql
select * from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'aluguel' and exists (select * from `imovel_imagens` where `imoveis`.`id` = `imovel_imagens`.`imovel_id`) order by `imoveis`.`id` desc limit 1
0.2ms
mysql
select * from `imovel_imagens` where `imovel_imagens`.`imovel_id` in (20) order by `id` asc
0.11ms
mysql
select `id`, `nome`, `cidade_id`, `numero`, `zona` from `bairros` where `bairros`.`id` in (3)
0.06ms
mysql
select `id`, `nome`, `uf` from `cidades` where `cidades`.`id` in (5)
0.05ms
mysql
select * from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'temporada' and exists (select * from `imovel_imagens` where `imoveis`.`id` = `imovel_imagens`.`imovel_id`) order by `imoveis`.`id` desc limit 1
0.13ms
mysql
select * from `imovel_imagens` where `imovel_imagens`.`imovel_id` in (22) order by `id` asc
0.1ms
mysql
select `id`, `nome`, `cidade_id`, `numero`, `zona` from `bairros` where `bairros`.`id` in (2)
0.05ms
mysql
select `id`, `nome`, `uf` from `cidades` where `cidades`.`id` in (1)
0.04ms
mysql
select * from `configuracoes` where `chave` = 'site_template_ativo' limit 1
0.3ms
mysql
select * from `cache` where `key` in ('laravel-cache-tpl.numeros')
0.24ms
mysql
delete from `cache` where `key` in ('laravel-cache-tpl.numeros', 'laravel-cache-illuminate:cache:flexible:created:tpl.numeros') and `expiration` <= 1795133533
0.21ms
mysql
select count(*) as aggregate from `imoveis` where `status` = 'ativo'
0.11ms
mysql
select count(*) as aggregate from `imoveis` where `status` = 'ativo' and `finalidade` in ('aluguel', 'temporada')
0.08ms
mysql
select count(distinct `bairro_id`) as aggregate from `imoveis` where `status` = 'ativo' and `bairro_id` is not null
0.15ms
mysql
select * from `bairros` order by numero IS NULL, numero, `nome` asc
0.13ms
mysql
select `id`, `nome`, `uf` from `cidades` where `cidades`.`id` in (1, 5)
0.09ms
mysql
insert into `cache` (`expiration`, `key`, `value`) values (1795133833, 'laravel-cache-tpl.numeros', 'a:4:{s:5:"total";i:4;s:7:"locacao";i:2;s:7:"bairros";i:3;s:13:"bairros_total";i:6;}') on duplicate key update `expiration` = values(`expiration`), `key` = values(`key`), `value` = values(`value`)
0.2ms
mysql
select `imoveis`.`tipo`, count(*) as total from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' group by `imoveis`.`tipo`
0.19ms
mysql
select `imoveis`.`bairro_id`, count(*) as total from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' group by `imoveis`.`bairro_id`
0.08ms
mysql
select `imoveis`.`dormitorios`, count(*) as total from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' group by `imoveis`.`dormitorios`
0.12ms
mysql
select distinct `tipo` from `imoveis` where `status` = 'ativo' and `tipo` is not null and `tipo` != '' order by `tipo` asc
0.08ms
mysql
select count(*) as aggregate from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' and json_contains(`imoveis`.`caracteristicas`, '"vista_mar"')
0.11ms
mysql
select count(*) as aggregate from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' and json_contains(`imoveis`.`caracteristicas`, '"mobiliado"')
0.06ms
mysql
select count(*) as aggregate from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' and json_contains(`imoveis`.`caracteristicas`, '"piscina_privativa"')
0.05ms
mysql
select count(*) as aggregate from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' and json_contains(`imoveis`.`caracteristicas`, '"frente_ao_golfe"')
0.05ms

Headers

accept
*/*
accept-encoding
gzip, br, zstd, deflate
content-length
0
host
www.portal.neraimob.com.br
user-agent
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

Body

// No request body

Routing

controller
App\Http\Controllers\Site\SiteController@home
route name
site.home
middleware
web

Routing parameters

// No routing parameters