"SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(date) does not exist" error searching #125

devgiu · 2023-03-17T07:26:02Z

devgiu
Mar 17, 2023

Hi,

I don't know why or since when but suddenly my tables stopped working trying to search. I have a laravel 7 project with laravel-table v3

I created several pages with a simple laravel-table with date column and worked fine, and I didn't came back to this pages again. This week I deployed a new version with some asked features in the project several months later last update, and users started to complain about errors on pages I didn't changed in more than a year.
Error is trying to search. Table has a date column called due_date with sortable and searchable. If I remove sortable and searchable, it works. Need help to know the root of the problem and how to solve it, because there is another page with a similar error but an int column.

Illuminate\Database\QueryException SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(date) does not exist LINE 1: ... LOWER(vp_project.project_name)::text ILIKE $3 or LOWER(vp_p... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. (SQL: select count(*) as aggregate from "vp_po_data" left join "vp_project" on "vp_project"."project_key" = "vp_po_data"."project_key" left join "vp_vendor" on "vp_vendor"."vendor_key" = "vp_po_data"."vendor_key" where (LOWER(vp_po_data.client_order_number)::text ILIKE %fefe% or LOWER(vp_vendor.vendor_name)::text ILIKE %fefe% or LOWER(vp_project.project_name)::text ILIKE %fefe% or LOWER(vp_po_data.due_date)::text ILIKE %fefe%)) (View: /home/xxxx/project/resources/views/podata/index.blade.php)

Looking in the log I see this where:
where (LOWER(vp_po_data.client_order_number)::text ilike '%fefe%' or LOWER(vp_vendor.vendor_name)::text ilike '%fefe%' or LOWER(vp_project.project_name)::text ilike '%fefe%' or LOWER(vp_po_data.due_date)::text ilike '%fefe%')

Trying to run the query in dbeaver it complains and looks like it wants date field to be casted this way
LOWER(vp_po_data.due_date::text)

I'm not an expert in laravel, nor laraveltable, is the unique project I work in laravel and have no idea how to get ride of this.

Answered by Okipa

Apr 2, 2023

I mark this one as answered as it has been discussed/resolved here: #129

View full answer

Okipa · 2023-03-17T08:04:17Z

Okipa
Mar 17, 2023
Maintainer

Hi @devgiu, I think this is a bug when the package tries to search a date field using the SQL ´LOWER´ function.
I'll have to take a look at this tonight.
I get back to you once I have found a fix 👍

2 replies

devgiu Mar 17, 2023
Author

Thanks.

If makes sense for you, on another page I have a similar error but with int.

Illuminate\Database\QueryException
SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(integer) does not exist LINE 1: ... LOWER(vp_project.merch_intent)::text ILIKE $4 or LOWER(vp_p... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. (SQL: select count(*) as aggregate from "vp_project" where (LOWER(vp_project.project_code)::text ILIKE %proser% or LOWER(vp_project.project_name)::text ILIKE %proser% or LOWER(vp_project.project_descr)::text ILIKE %proser% or LOWER(vp_project.merch_intent)::text ILIKE %proser% or LOWER(vp_project.project_num)::text ILIKE %proser% or LOWER(vp_project.last_change_date)::text ILIKE %proser% or LOWER(vp_project.creation_date)::text ILIKE %proser%)) (View: /home/xxxx/project/resources/views/projects/index.blade.php)

I paste you the full stack with both errors lower(date) and with lower(int).

[2023-03-17 07:08:23] local.ERROR: SQLSTATE[42883]: Undefined function: 7 ERROR:  function lower(date) does not exist
LINE 1: ... LOWER(vp_project.project_name)::text ILIKE $3 or LOWER(vp_p...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. (SQL: select count(*) as aggregate from "vp_po_data" left join "vp_project" on "vp_project"."project_key" = "vp_po_data"."project_key" left join "vp_vendor" on "vp_vendor"."vendor_key" = "vp_po_data"."vendor_key" where (LOWER(vp_po_data.client_order_number)::text ILIKE %fefe% or LOWER(vp_vendor.vendor_name)::text ILIKE %fefe% or LOWER(vp_project.project_name)::text ILIKE %fefe% or LOWER(vp_po_data.due_date)::text ILIKE %fefe%)) (View: /home/xxxx/project/resources/views/podata/index.blade.php) {"userId":2,"exception":"[object] (Facade\\Ignition\\Exceptions\\ViewException(code: 0): SQLSTATE[42883]: Undefined function: 7 ERROR:  function lower(date) does not exist
LINE 1: ... LOWER(vp_project.project_name)::text ILIKE $3 or LOWER(vp_p...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. (SQL: select count(*) as aggregate from \"vp_po_data\" left join \"vp_project\" on \"vp_project\".\"project_key\" = \"vp_po_data\".\"project_key\" left join \"vp_vendor\" on \"vp_vendor\".\"vendor_key\" = \"vp_po_data\".\"vendor_key\" where (LOWER(vp_po_data.client_order_number)::text ILIKE %fefe% or LOWER(vp_vendor.vendor_name)::text ILIKE %fefe% or LOWER(vp_project.project_name)::text ILIKE %fefe% or LOWER(vp_po_data.due_date)::text ILIKE %fefe%)) (View: /home/xxxx/project/resources/views/podata/index.blade.php) at /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671)
[stacktrace]
#0 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback()
#1 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(339): Illuminate\\Database\\Connection->run()
#2 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2270): Illuminate\\Database\\Connection->select()
#3 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2258): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2753): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2259): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2369): Illuminate\\Database\\Query\\Builder->get()
#7 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2328): Illuminate\\Database\\Query\\Builder->runPaginationCountQuery()
#8 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(731): Illuminate\\Database\\Query\\Builder->getCountForPagination()
#9 /home/xxxx/project/vendor/okipa/laravel-table/src/Traits/Table/HasPagination.php(66): Illuminate\\Database\\Eloquent\\Builder->paginate()
#10 /home/xxxx/project/vendor/okipa/laravel-table/src/Table.php(87): Okipa\\LaravelTable\\Table->paginateFromQuery()
#11 /home/xxxx/project/vendor/okipa/laravel-table/src/Table.php(68): Okipa\\LaravelTable\\Table->configure()
#12 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Support/helpers.php(259): Okipa\\LaravelTable\\Table->toHtml()
#13 /home/xxxx/project/resources/views/podata/index.blade.php(10): e()
#14 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php(41): include('/home/gpunzi/ve...')
#15 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php(57): Illuminate\\View\\Engines\\PhpEngine->evaluatePath()
#16 /home/xxxx/project/vendor/facade/ignition/src/Views/Engines/CompilerEngine.php(37): Illuminate\\View\\Engines\\CompilerEngine->get()
#17 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(139): Facade\\Ignition\\Views\\Engines\\CompilerEngine->get()
#18 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(122): Illuminate\\View\\View->getContents()
#19 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(91): Illuminate\\View\\View->renderContents()
#20 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Http/Response.php(62): Illuminate\\View\\View->render()
#21 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Http/Response.php(34): Illuminate\\Http\\Response->setContent()
#22 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(759): Illuminate\\Http\\Response->__construct()
#23 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(731): Illuminate\\Routing\\Router::toResponse()
#24 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(685): Illuminate\\Routing\\Router->prepareResponse()
#25 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#26 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#27 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#28 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#30 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#31 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#32 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#33 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#34 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(62): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#36 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle()
#37 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#39 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#41 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(687): Illuminate\\Pipeline\\Pipeline->then()
#43 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(662): Illuminate\\Routing\\Router->runRouteWithinStack()
#44 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(628): Illuminate\\Routing\\Router->runRoute()
#45 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(617): Illuminate\\Routing\\Router->dispatchToRoute()
#46 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Routing\\Router->dispatch()
#47 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#48 /home/xxxx/project/app/Http/Middleware/GenerateMenus.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\\Http\\Middleware\\GenerateMenus->handle()
#50 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#52 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#53 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#54 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#55 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#56 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#57 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#58 /home/xxxx/project/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#59 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle()
#60 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#61 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(140): Illuminate\\Pipeline\\Pipeline->then()
#62 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(109): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#63 /home/xxxx/project/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle()
#64 {main}

[previous exception] [object] (Illuminate\\Database\\QueryException(code: 42883): SQLSTATE[42883]: Undefined function: 7 ERROR:  function lower(date) does not exist
LINE 1: ... LOWER(vp_project.project_name)::text ILIKE $3 or LOWER(vp_p...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. (SQL: select count(*) as aggregate from \"vp_po_data\" left join \"vp_project\" on \"vp_project\".\"project_key\" = \"vp_po_data\".\"project_key\" left join \"vp_vendor\" on \"vp_vendor\".\"vendor_key\" = \"vp_po_data\".\"vendor_key\" where (LOWER(vp_po_data.client_order_number)::text ILIKE %fefe% or LOWER(vp_vendor.vendor_name)::text ILIKE %fefe% or LOWER(vp_project.project_name)::text ILIKE %fefe% or LOWER(vp_po_data.due_date)::text ILIKE %fefe%)) at /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671)
[stacktrace]
#0 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback()
#1 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(339): Illuminate\\Database\\Connection->run()
#2 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2270): Illuminate\\Database\\Connection->select()
#3 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2258): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2753): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2259): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2369): Illuminate\\Database\\Query\\Builder->get()
#7 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2328): Illuminate\\Database\\Query\\Builder->runPaginationCountQuery()
#8 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(731): Illuminate\\Database\\Query\\Builder->getCountForPagination()
#9 /home/xxxx/project/vendor/okipa/laravel-table/src/Traits/Table/HasPagination.php(66): Illuminate\\Database\\Eloquent\\Builder->paginate()
#10 /home/xxxx/project/vendor/okipa/laravel-table/src/Table.php(87): Okipa\\LaravelTable\\Table->paginateFromQuery()
#11 /home/xxxx/project/vendor/okipa/laravel-table/src/Table.php(68): Okipa\\LaravelTable\\Table->configure()
#12 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Support/helpers.php(259): Okipa\\LaravelTable\\Table->toHtml()
#13 /home/xxxx/project/storage/framework/views/2bfcbae912a8c959309dd42ed9cd094229f6bf07.php(8): e()
#14 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php(41): include('/home/gpunzi/ve...')
#15 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php(57): Illuminate\\View\\Engines\\PhpEngine->evaluatePath()
#16 /home/xxxx/project/vendor/facade/ignition/src/Views/Engines/CompilerEngine.php(37): Illuminate\\View\\Engines\\CompilerEngine->get()
#17 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(139): Facade\\Ignition\\Views\\Engines\\CompilerEngine->get()
#18 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(122): Illuminate\\View\\View->getContents()
#19 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(91): Illuminate\\View\\View->renderContents()
#20 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Http/Response.php(62): Illuminate\\View\\View->render()
#21 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Http/Response.php(34): Illuminate\\Http\\Response->setContent()
#22 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(759): Illuminate\\Http\\Response->__construct()
#23 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(731): Illuminate\\Routing\\Router::toResponse()
#24 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(685): Illuminate\\Routing\\Router->prepareResponse()
#25 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#26 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#27 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#28 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#30 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#31 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#32 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#33 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#34 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(62): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#36 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle()
#37 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#39 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#41 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(687): Illuminate\\Pipeline\\Pipeline->then()
#43 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(662): Illuminate\\Routing\\Router->runRouteWithinStack()
#44 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(628): Illuminate\\Routing\\Router->runRoute()
#45 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(617): Illuminate\\Routing\\Router->dispatchToRoute()
#46 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Routing\\Router->dispatch()
#47 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#48 /home/xxxx/project/app/Http/Middleware/GenerateMenus.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\\Http\\Middleware\\GenerateMenus->handle()
#50 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#52 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#53 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#54 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#55 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#56 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#57 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#58 /home/xxxx/project/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#59 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle()
#60 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#61 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(140): Illuminate\\Pipeline\\Pipeline->then()
#62 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(109): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#63 /home/xxxx/project/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle()
#64 {main}

[previous exception] [object] (PDOException(code: 42883): SQLSTATE[42883]: Undefined function: 7 ERROR:  function lower(date) does not exist
LINE 1: ... LOWER(vp_project.project_name)::text ILIKE $3 or LOWER(vp_p...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. at /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:336)
[stacktrace]
#0 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(336): PDOStatement->execute()
#1 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback()
#3 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(339): Illuminate\\Database\\Connection->run()
#4 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2270): Illuminate\\Database\\Connection->select()
#5 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2258): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2753): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2259): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2369): Illuminate\\Database\\Query\\Builder->get()
#9 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2328): Illuminate\\Database\\Query\\Builder->runPaginationCountQuery()
#10 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(731): Illuminate\\Database\\Query\\Builder->getCountForPagination()
#11 /home/xxxx/project/vendor/okipa/laravel-table/src/Traits/Table/HasPagination.php(66): Illuminate\\Database\\Eloquent\\Builder->paginate()
#12 /home/xxxx/project/vendor/okipa/laravel-table/src/Table.php(87): Okipa\\LaravelTable\\Table->paginateFromQuery()
#13 /home/xxxx/project/vendor/okipa/laravel-table/src/Table.php(68): Okipa\\LaravelTable\\Table->configure()
#14 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Support/helpers.php(259): Okipa\\LaravelTable\\Table->toHtml()
#15 /home/xxxx/project/storage/framework/views/2bfcbae912a8c959309dd42ed9cd094229f6bf07.php(8): e()
#16 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php(41): include('/home/gpunzi/ve...')
#17 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php(57): Illuminate\\View\\Engines\\PhpEngine->evaluatePath()
#18 /home/xxxx/project/vendor/facade/ignition/src/Views/Engines/CompilerEngine.php(37): Illuminate\\View\\Engines\\CompilerEngine->get()
#19 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(139): Facade\\Ignition\\Views\\Engines\\CompilerEngine->get()
#20 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(122): Illuminate\\View\\View->getContents()
#21 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(91): Illuminate\\View\\View->renderContents()
#22 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Http/Response.php(62): Illuminate\\View\\View->render()
#23 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Http/Response.php(34): Illuminate\\Http\\Response->setContent()
#24 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(759): Illuminate\\Http\\Response->__construct()
#25 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(731): Illuminate\\Routing\\Router::toResponse()
#26 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(685): Illuminate\\Routing\\Router->prepareResponse()
#27 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#28 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#30 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#31 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#32 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#33 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#34 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#36 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#37 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(62): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#38 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle()
#39 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#41 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#43 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#44 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(687): Illuminate\\Pipeline\\Pipeline->then()
#45 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(662): Illuminate\\Routing\\Router->runRouteWithinStack()
#46 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(628): Illuminate\\Routing\\Router->runRoute()
#47 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(617): Illuminate\\Routing\\Router->dispatchToRoute()
#48 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Routing\\Router->dispatch()
#49 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#50 /home/xxxx/project/app/Http/Middleware/GenerateMenus.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\\Http\\Middleware\\GenerateMenus->handle()
#52 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#53 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#54 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#55 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#56 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#57 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#58 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#59 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#60 /home/xxxx/project/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#61 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle()
#62 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#63 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(140): Illuminate\\Pipeline\\Pipeline->then()
#64 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(109): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#65 /home/xxxx/project/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle()
#66 {main}
"} 
[2023-03-17 08:44:41] local.ERROR: SQLSTATE[42883]: Undefined function: 7 ERROR:  function lower(integer) does not exist
LINE 1: ... LOWER(vp_project.merch_intent)::text ILIKE $4 or LOWER(vp_p...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. (SQL: select count(*) as aggregate from "vp_project" where (LOWER(vp_project.project_code)::text ILIKE %proser% or LOWER(vp_project.project_name)::text ILIKE %proser% or LOWER(vp_project.project_descr)::text ILIKE %proser% or LOWER(vp_project.merch_intent)::text ILIKE %proser% or LOWER(vp_project.project_num)::text ILIKE %proser% or LOWER(vp_project.last_change_date)::text ILIKE %proser% or LOWER(vp_project.creation_date)::text ILIKE %proser%)) (View: /home/xxxx/project/resources/views/projects/index.blade.php) {"userId":2,"exception":"[object] (Facade\\Ignition\\Exceptions\\ViewException(code: 0): SQLSTATE[42883]: Undefined function: 7 ERROR:  function lower(integer) does not exist
LINE 1: ... LOWER(vp_project.merch_intent)::text ILIKE $4 or LOWER(vp_p...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. (SQL: select count(*) as aggregate from \"vp_project\" where (LOWER(vp_project.project_code)::text ILIKE %proser% or LOWER(vp_project.project_name)::text ILIKE %proser% or LOWER(vp_project.project_descr)::text ILIKE %proser% or LOWER(vp_project.merch_intent)::text ILIKE %proser% or LOWER(vp_project.project_num)::text ILIKE %proser% or LOWER(vp_project.last_change_date)::text ILIKE %proser% or LOWER(vp_project.creation_date)::text ILIKE %proser%)) (View: /home/xxxx/project/resources/views/projects/index.blade.php) at /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671)
[stacktrace]
#0 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback()
#1 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(339): Illuminate\\Database\\Connection->run()
#2 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2270): Illuminate\\Database\\Connection->select()
#3 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2258): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2753): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2259): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2369): Illuminate\\Database\\Query\\Builder->get()
#7 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2328): Illuminate\\Database\\Query\\Builder->runPaginationCountQuery()
#8 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(731): Illuminate\\Database\\Query\\Builder->getCountForPagination()
#9 /home/xxxx/project/vendor/okipa/laravel-table/src/Traits/Table/HasPagination.php(66): Illuminate\\Database\\Eloquent\\Builder->paginate()
#10 /home/xxxx/project/vendor/okipa/laravel-table/src/Table.php(87): Okipa\\LaravelTable\\Table->paginateFromQuery()
#11 /home/xxxx/project/vendor/okipa/laravel-table/src/Table.php(68): Okipa\\LaravelTable\\Table->configure()
#12 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Support/helpers.php(259): Okipa\\LaravelTable\\Table->toHtml()
#13 /home/xxxx/project/resources/views/projects/index.blade.php(7): e()
#14 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php(41): include('/home/gpunzi/ve...')
#15 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php(57): Illuminate\\View\\Engines\\PhpEngine->evaluatePath()
#16 /home/xxxx/project/vendor/facade/ignition/src/Views/Engines/CompilerEngine.php(37): Illuminate\\View\\Engines\\CompilerEngine->get()
#17 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(139): Facade\\Ignition\\Views\\Engines\\CompilerEngine->get()
#18 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(122): Illuminate\\View\\View->getContents()
#19 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(91): Illuminate\\View\\View->renderContents()
#20 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Http/Response.php(62): Illuminate\\View\\View->render()
#21 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Http/Response.php(34): Illuminate\\Http\\Response->setContent()
#22 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(759): Illuminate\\Http\\Response->__construct()
#23 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(731): Illuminate\\Routing\\Router::toResponse()
#24 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(685): Illuminate\\Routing\\Router->prepareResponse()
#25 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#26 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#27 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#28 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#30 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#31 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#32 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#33 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#34 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(62): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#36 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle()
#37 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#39 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#41 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(687): Illuminate\\Pipeline\\Pipeline->then()
#43 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(662): Illuminate\\Routing\\Router->runRouteWithinStack()
#44 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(628): Illuminate\\Routing\\Router->runRoute()
#45 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(617): Illuminate\\Routing\\Router->dispatchToRoute()
#46 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Routing\\Router->dispatch()
#47 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#48 /home/xxxx/project/app/Http/Middleware/GenerateMenus.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\\Http\\Middleware\\GenerateMenus->handle()
#50 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#52 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#53 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#54 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#55 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#56 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#57 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#58 /home/xxxx/project/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#59 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle()
#60 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#61 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(140): Illuminate\\Pipeline\\Pipeline->then()
#62 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(109): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#63 /home/xxxx/project/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle()
#64 {main}

[previous exception] [object] (Illuminate\\Database\\QueryException(code: 42883): SQLSTATE[42883]: Undefined function: 7 ERROR:  function lower(integer) does not exist
LINE 1: ... LOWER(vp_project.merch_intent)::text ILIKE $4 or LOWER(vp_p...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. (SQL: select count(*) as aggregate from \"vp_project\" where (LOWER(vp_project.project_code)::text ILIKE %proser% or LOWER(vp_project.project_name)::text ILIKE %proser% or LOWER(vp_project.project_descr)::text ILIKE %proser% or LOWER(vp_project.merch_intent)::text ILIKE %proser% or LOWER(vp_project.project_num)::text ILIKE %proser% or LOWER(vp_project.last_change_date)::text ILIKE %proser% or LOWER(vp_project.creation_date)::text ILIKE %proser%)) at /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671)
[stacktrace]
#0 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback()
#1 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(339): Illuminate\\Database\\Connection->run()
#2 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2270): Illuminate\\Database\\Connection->select()
#3 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2258): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2753): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2259): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2369): Illuminate\\Database\\Query\\Builder->get()
#7 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2328): Illuminate\\Database\\Query\\Builder->runPaginationCountQuery()
#8 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(731): Illuminate\\Database\\Query\\Builder->getCountForPagination()
#9 /home/xxxx/project/vendor/okipa/laravel-table/src/Traits/Table/HasPagination.php(66): Illuminate\\Database\\Eloquent\\Builder->paginate()
#10 /home/xxxx/project/vendor/okipa/laravel-table/src/Table.php(87): Okipa\\LaravelTable\\Table->paginateFromQuery()
#11 /home/xxxx/project/vendor/okipa/laravel-table/src/Table.php(68): Okipa\\LaravelTable\\Table->configure()
#12 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Support/helpers.php(259): Okipa\\LaravelTable\\Table->toHtml()
#13 /home/xxxx/project/storage/framework/views/5503b66dc08fefbd6e68dbfbb339b1a5f2ff2d58.php(5): e()
#14 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php(41): include('/home/gpunzi/ve...')
#15 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php(57): Illuminate\\View\\Engines\\PhpEngine->evaluatePath()
#16 /home/xxxx/project/vendor/facade/ignition/src/Views/Engines/CompilerEngine.php(37): Illuminate\\View\\Engines\\CompilerEngine->get()
#17 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(139): Facade\\Ignition\\Views\\Engines\\CompilerEngine->get()
#18 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(122): Illuminate\\View\\View->getContents()
#19 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(91): Illuminate\\View\\View->renderContents()
#20 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Http/Response.php(62): Illuminate\\View\\View->render()
#21 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Http/Response.php(34): Illuminate\\Http\\Response->setContent()
#22 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(759): Illuminate\\Http\\Response->__construct()
#23 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(731): Illuminate\\Routing\\Router::toResponse()
#24 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(685): Illuminate\\Routing\\Router->prepareResponse()
#25 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#26 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#27 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#28 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#30 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#31 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#32 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#33 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#34 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(62): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#36 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle()
#37 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#39 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#41 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(687): Illuminate\\Pipeline\\Pipeline->then()
#43 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(662): Illuminate\\Routing\\Router->runRouteWithinStack()
#44 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(628): Illuminate\\Routing\\Router->runRoute()
#45 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(617): Illuminate\\Routing\\Router->dispatchToRoute()
#46 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Routing\\Router->dispatch()
#47 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#48 /home/xxxx/project/app/Http/Middleware/GenerateMenus.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\\Http\\Middleware\\GenerateMenus->handle()
#50 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#52 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#53 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#54 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#55 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#56 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#57 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#58 /home/xxxx/project/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#59 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle()
#60 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#61 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(140): Illuminate\\Pipeline\\Pipeline->then()
#62 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(109): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#63 /home/xxxx/project/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle()
#64 {main}

[previous exception] [object] (PDOException(code: 42883): SQLSTATE[42883]: Undefined function: 7 ERROR:  function lower(integer) does not exist
LINE 1: ... LOWER(vp_project.merch_intent)::text ILIKE $4 or LOWER(vp_p...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. at /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:336)
[stacktrace]
#0 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(336): PDOStatement->execute()
#1 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback()
#3 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(339): Illuminate\\Database\\Connection->run()
#4 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2270): Illuminate\\Database\\Connection->select()
#5 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2258): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2753): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2259): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2369): Illuminate\\Database\\Query\\Builder->get()
#9 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2328): Illuminate\\Database\\Query\\Builder->runPaginationCountQuery()
#10 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(731): Illuminate\\Database\\Query\\Builder->getCountForPagination()
#11 /home/xxxx/project/vendor/okipa/laravel-table/src/Traits/Table/HasPagination.php(66): Illuminate\\Database\\Eloquent\\Builder->paginate()
#12 /home/xxxx/project/vendor/okipa/laravel-table/src/Table.php(87): Okipa\\LaravelTable\\Table->paginateFromQuery()
#13 /home/xxxx/project/vendor/okipa/laravel-table/src/Table.php(68): Okipa\\LaravelTable\\Table->configure()
#14 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Support/helpers.php(259): Okipa\\LaravelTable\\Table->toHtml()
#15 /home/xxxx/project/storage/framework/views/5503b66dc08fefbd6e68dbfbb339b1a5f2ff2d58.php(5): e()
#16 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php(41): include('/home/gpunzi/ve...')
#17 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php(57): Illuminate\\View\\Engines\\PhpEngine->evaluatePath()
#18 /home/xxxx/project/vendor/facade/ignition/src/Views/Engines/CompilerEngine.php(37): Illuminate\\View\\Engines\\CompilerEngine->get()
#19 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(139): Facade\\Ignition\\Views\\Engines\\CompilerEngine->get()
#20 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(122): Illuminate\\View\\View->getContents()
#21 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/View.php(91): Illuminate\\View\\View->renderContents()
#22 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Http/Response.php(62): Illuminate\\View\\View->render()
#23 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Http/Response.php(34): Illuminate\\Http\\Response->setContent()
#24 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(759): Illuminate\\Http\\Response->__construct()
#25 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(731): Illuminate\\Routing\\Router::toResponse()
#26 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(685): Illuminate\\Routing\\Router->prepareResponse()
#27 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#28 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#30 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#31 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#32 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#33 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#34 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#35 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#36 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#37 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(62): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#38 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle()
#39 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#41 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#43 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#44 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(687): Illuminate\\Pipeline\\Pipeline->then()
#45 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(662): Illuminate\\Routing\\Router->runRouteWithinStack()
#46 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(628): Illuminate\\Routing\\Router->runRoute()
#47 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(617): Illuminate\\Routing\\Router->dispatchToRoute()
#48 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Routing\\Router->dispatch()
#49 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#50 /home/xxxx/project/app/Http/Middleware/GenerateMenus.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#51 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\\Http\\Middleware\\GenerateMenus->handle()
#52 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#53 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#54 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#55 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#56 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#57 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#58 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#59 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle()
#60 /home/xxxx/project/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#61 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle()
#62 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#63 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(140): Illuminate\\Pipeline\\Pipeline->then()
#64 /home/xxxx/project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(109): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#65 /home/xxxx/project/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle()
#66 {main}
"}

Okipa Mar 28, 2023
Maintainer

@devgiu Sorry, I couldn't take a look about this sooner, I was gone in vacation.

I'll look at this this week !

Okipa · 2023-04-02T19:48:09Z

Okipa
Apr 2, 2023
Maintainer

I mark this one as answered as it has been discussed/resolved here: #129

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

"SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(date) does not exist" error searching #125

{{title}}

Replies: 2 comments 2 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Select a reply

"SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(date) does not exist" error searching #125

devgiu Mar 17, 2023

Replies: 2 comments · 2 replies

Okipa Mar 17, 2023 Maintainer

devgiu Mar 17, 2023 Author

Okipa Mar 28, 2023 Maintainer

Okipa Apr 2, 2023 Maintainer

devgiu
Mar 17, 2023

Replies: 2 comments 2 replies

Okipa
Mar 17, 2023
Maintainer

devgiu Mar 17, 2023
Author

Okipa Mar 28, 2023
Maintainer

Okipa
Apr 2, 2023
Maintainer