[2025-05-07 08:10:12] local.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column user_assets.pk_user_id does not exist
LINE 1: ...er_assets" inner join "artappleschema"."users" on "artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column "user_assets.fk_user_id". (SQL: select "artappleschema"."user_assets".*, "artappleschema"."users"."pk_user_id", "artappleschema"."users"."user_name", "artappleschema"."user_roles"."fk_user_id", "artappleschema"."user_roles"."fk_user_type_id" from "artappleschema"."user_assets" inner join "artappleschema"."users" on "artappleschema"."user_assets"."pk_user_id" = "artappleschema"."users"."fk_user_id" inner join "artappleschema"."user_roles" on "artappleschema"."users"."pk_user_id" = "artappleschema"."user_roles"."fk_user_id" where "artappleschema"."user_assets"."status" = Created and (LOWER(artappleschema.user_assets.artwork_title) LIKE %a% or LOWER(artappleschema.user_assets.description) LIKE %a%) order by "created_at" desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column user_assets.pk_user_id does not exist
LINE 1: ...er_assets\" inner join \"artappleschema\".\"users\" on \"artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column \"user_assets.fk_user_id\". (SQL: select \"artappleschema\".\"user_assets\".*, \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"user_name\", \"artappleschema\".\"user_roles\".\"fk_user_id\", \"artappleschema\".\"user_roles\".\"fk_user_type_id\" from \"artappleschema\".\"user_assets\" inner join \"artappleschema\".\"users\" on \"artappleschema\".\"user_assets\".\"pk_user_id\" = \"artappleschema\".\"users\".\"fk_user_id\" inner join \"artappleschema\".\"user_roles\" on \"artappleschema\".\"users\".\"pk_user_id\" = \"artappleschema\".\"user_roles\".\"fk_user_id\" where \"artappleschema\".\"user_assets\".\"status\" = Created and (LOWER(artappleschema.user_assets.artwork_title) LIKE %a% or LOWER(artappleschema.user_assets.description) LIKE %a%) order by \"created_at\" desc) at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure))
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure))
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true)
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#6 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(363): Illuminate\\Database\\Query\\Builder->get()
#7 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#8 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#20 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#28 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#31 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#34 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#36 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#37 {main}

[previous exception] [object] (PDOException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column user_assets.pk_user_id does not exist
LINE 1: ...er_assets\" inner join \"artappleschema\".\"users\" on \"artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column \"user_assets.fk_user_id\". at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:373)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(373): PDOStatement->execute()
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"artappl...', Array)
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure))
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure))
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true)
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#6 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#8 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(363): Illuminate\\Database\\Query\\Builder->get()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#12 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#13 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#20 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#23 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#27 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#30 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#34 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#36 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#37 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#38 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#39 {main}
"} 
[2025-05-07 08:10:32] local.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column user_assets.pk_user_id does not exist
LINE 1: ...er_assets" inner join "artappleschema"."users" on "artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column "user_assets.fk_user_id". (SQL: select "artappleschema"."user_assets".*, "artappleschema"."users"."pk_user_id", "artappleschema"."users"."user_name", "artappleschema"."user_roles"."fk_user_id", "artappleschema"."user_roles"."fk_user_type_id" from "artappleschema"."user_assets" inner join "artappleschema"."users" on "artappleschema"."user_assets"."pk_user_id" = "artappleschema"."users"."fk_user_id" inner join "artappleschema"."user_roles" on "artappleschema"."users"."pk_user_id" = "artappleschema"."user_roles"."fk_user_id" where "artappleschema"."user_assets"."status" = Created and (LOWER(artappleschema.user_assets.artwork_title) LIKE %a% or LOWER(artappleschema.user_assets.description) LIKE %a%) order by "created_at" desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column user_assets.pk_user_id does not exist
LINE 1: ...er_assets\" inner join \"artappleschema\".\"users\" on \"artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column \"user_assets.fk_user_id\". (SQL: select \"artappleschema\".\"user_assets\".*, \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"user_name\", \"artappleschema\".\"user_roles\".\"fk_user_id\", \"artappleschema\".\"user_roles\".\"fk_user_type_id\" from \"artappleschema\".\"user_assets\" inner join \"artappleschema\".\"users\" on \"artappleschema\".\"user_assets\".\"pk_user_id\" = \"artappleschema\".\"users\".\"fk_user_id\" inner join \"artappleschema\".\"user_roles\" on \"artappleschema\".\"users\".\"pk_user_id\" = \"artappleschema\".\"user_roles\".\"fk_user_id\" where \"artappleschema\".\"user_assets\".\"status\" = Created and (LOWER(artappleschema.user_assets.artwork_title) LIKE %a% or LOWER(artappleschema.user_assets.description) LIKE %a%) order by \"created_at\" desc) at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure))
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure))
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true)
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#6 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(363): Illuminate\\Database\\Query\\Builder->get()
#7 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#8 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#20 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#28 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#31 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#34 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#36 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#37 {main}

[previous exception] [object] (PDOException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column user_assets.pk_user_id does not exist
LINE 1: ...er_assets\" inner join \"artappleschema\".\"users\" on \"artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column \"user_assets.fk_user_id\". at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:373)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(373): PDOStatement->execute()
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"artappl...', Array)
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure))
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure))
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true)
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#6 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#8 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(363): Illuminate\\Database\\Query\\Builder->get()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#12 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#13 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#20 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#23 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#27 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#30 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#34 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#36 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#37 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#38 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#39 {main}
"} 
[2025-05-07 08:15:58] local.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.fk_user_id does not exist
LINE 1: ...r_id" inner join "artappleschema"."user_roles" on "artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column "users.pk_user_id". (SQL: select "artappleschema"."user_assets".*, "artappleschema"."users"."pk_user_id", "artappleschema"."users"."user_name", "artappleschema"."user_roles"."fk_user_id", "artappleschema"."user_roles"."fk_user_type_id" from "artappleschema"."user_assets" inner join "artappleschema"."users" on "artappleschema"."user_assets"."fk_user_id" = "artappleschema"."users"."pk_user_id" inner join "artappleschema"."user_roles" on "artappleschema"."users"."fk_user_id" = "artappleschema"."user_roles"."pk_user_id" where "artappleschema"."user_assets"."status" = Created and (LOWER(artappleschema.user_assets.artwork_title) LIKE %a% or LOWER(artappleschema.user_assets.description) LIKE %a%) order by "created_at" desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.fk_user_id does not exist
LINE 1: ...r_id\" inner join \"artappleschema\".\"user_roles\" on \"artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column \"users.pk_user_id\". (SQL: select \"artappleschema\".\"user_assets\".*, \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"user_name\", \"artappleschema\".\"user_roles\".\"fk_user_id\", \"artappleschema\".\"user_roles\".\"fk_user_type_id\" from \"artappleschema\".\"user_assets\" inner join \"artappleschema\".\"users\" on \"artappleschema\".\"user_assets\".\"fk_user_id\" = \"artappleschema\".\"users\".\"pk_user_id\" inner join \"artappleschema\".\"user_roles\" on \"artappleschema\".\"users\".\"fk_user_id\" = \"artappleschema\".\"user_roles\".\"pk_user_id\" where \"artappleschema\".\"user_assets\".\"status\" = Created and (LOWER(artappleschema.user_assets.artwork_title) LIKE %a% or LOWER(artappleschema.user_assets.description) LIKE %a%) order by \"created_at\" desc) at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure))
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure))
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true)
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#6 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(363): Illuminate\\Database\\Query\\Builder->get()
#7 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#8 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#20 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#28 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#31 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#34 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#36 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#37 {main}

[previous exception] [object] (PDOException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.fk_user_id does not exist
LINE 1: ...r_id\" inner join \"artappleschema\".\"user_roles\" on \"artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column \"users.pk_user_id\". at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:373)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(373): PDOStatement->execute()
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"artappl...', Array)
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure))
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure))
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true)
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#6 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#8 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(363): Illuminate\\Database\\Query\\Builder->get()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#12 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#13 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#20 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#23 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#27 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#30 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#34 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#36 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#37 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#38 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#39 {main}
"} 
[2025-05-07 08:17:01] local.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.fk_user_id does not exist
LINE 1: ...er_assets" inner join "artappleschema"."users" on "artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column "users.pk_user_id". (SQL: select "artappleschema"."user_assets".*, "artappleschema"."users"."pk_user_id", "artappleschema"."users"."user_name", "artappleschema"."user_roles"."fk_user_id", "artappleschema"."user_roles"."fk_user_type_id" from "artappleschema"."user_assets" inner join "artappleschema"."users" on "artappleschema"."users"."fk_user_id" = "artappleschema"."user_assets"."pk_user_id" inner join "artappleschema"."user_roles" on "artappleschema"."user_roles"."fk_user_id" = "artappleschema"."users"."pk_user_id" where "artappleschema"."user_assets"."status" = Created and (LOWER(artappleschema.user_assets.artwork_title) LIKE %a% or LOWER(artappleschema.user_assets.description) LIKE %a%) order by "created_at" desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.fk_user_id does not exist
LINE 1: ...er_assets\" inner join \"artappleschema\".\"users\" on \"artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column \"users.pk_user_id\". (SQL: select \"artappleschema\".\"user_assets\".*, \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"user_name\", \"artappleschema\".\"user_roles\".\"fk_user_id\", \"artappleschema\".\"user_roles\".\"fk_user_type_id\" from \"artappleschema\".\"user_assets\" inner join \"artappleschema\".\"users\" on \"artappleschema\".\"users\".\"fk_user_id\" = \"artappleschema\".\"user_assets\".\"pk_user_id\" inner join \"artappleschema\".\"user_roles\" on \"artappleschema\".\"user_roles\".\"fk_user_id\" = \"artappleschema\".\"users\".\"pk_user_id\" where \"artappleschema\".\"user_assets\".\"status\" = Created and (LOWER(artappleschema.user_assets.artwork_title) LIKE %a% or LOWER(artappleschema.user_assets.description) LIKE %a%) order by \"created_at\" desc) at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure))
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure))
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true)
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#6 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(362): Illuminate\\Database\\Query\\Builder->get()
#7 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#8 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#20 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#28 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#31 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#34 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#36 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#37 {main}

[previous exception] [object] (PDOException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.fk_user_id does not exist
LINE 1: ...er_assets\" inner join \"artappleschema\".\"users\" on \"artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column \"users.pk_user_id\". at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:373)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(373): PDOStatement->execute()
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"artappl...', Array)
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure))
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure))
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true)
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#6 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#8 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(362): Illuminate\\Database\\Query\\Builder->get()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#12 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#13 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#20 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#23 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#27 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#30 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#34 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#36 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#37 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#38 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#39 {main}
"} 
[2025-05-07 08:18:19] local.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.fk_user_id does not exist
LINE 1: ...er_assets" inner join "artappleschema"."users" on "artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column "users.pk_user_id". (SQL: select "artappleschema"."user_assets".*, "artappleschema"."users"."pk_user_id", "artappleschema"."users"."user_name", "artappleschema"."user_roles"."fk_user_id", "artappleschema"."user_roles"."fk_user_type_id" from "artappleschema"."user_assets" inner join "artappleschema"."users" on "artappleschema"."users"."fk_user_id" = "artappleschema"."user_assets"."pk_user_id" inner join "artappleschema"."user_roles" on "artappleschema"."user_roles"."fk_user_id" = "artappleschema"."users"."pk_user_id" where "artappleschema"."user_assets"."status" = Created and (LOWER(artappleschema.user_assets.artwork_title) LIKE %a% or LOWER(artappleschema.user_assets.description) LIKE %a%) order by "created_at" desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.fk_user_id does not exist
LINE 1: ...er_assets\" inner join \"artappleschema\".\"users\" on \"artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column \"users.pk_user_id\". (SQL: select \"artappleschema\".\"user_assets\".*, \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"user_name\", \"artappleschema\".\"user_roles\".\"fk_user_id\", \"artappleschema\".\"user_roles\".\"fk_user_type_id\" from \"artappleschema\".\"user_assets\" inner join \"artappleschema\".\"users\" on \"artappleschema\".\"users\".\"fk_user_id\" = \"artappleschema\".\"user_assets\".\"pk_user_id\" inner join \"artappleschema\".\"user_roles\" on \"artappleschema\".\"user_roles\".\"fk_user_id\" = \"artappleschema\".\"users\".\"pk_user_id\" where \"artappleschema\".\"user_assets\".\"status\" = Created and (LOWER(artappleschema.user_assets.artwork_title) LIKE %a% or LOWER(artappleschema.user_assets.description) LIKE %a%) order by \"created_at\" desc) at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure))
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure))
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true)
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#6 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(364): Illuminate\\Database\\Query\\Builder->get()
#7 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#8 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#20 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#28 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#31 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#34 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#36 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#37 {main}

[previous exception] [object] (PDOException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.fk_user_id does not exist
LINE 1: ...er_assets\" inner join \"artappleschema\".\"users\" on \"artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column \"users.pk_user_id\". at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:373)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(373): PDOStatement->execute()
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"artappl...', Array)
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure))
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure))
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true)
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#6 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#8 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(364): Illuminate\\Database\\Query\\Builder->get()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#12 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#13 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#20 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#23 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#27 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#30 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#34 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#36 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#37 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#38 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#39 {main}
"} 
[2025-05-07 08:20:32] local.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.fk_user_id does not exist
LINE 1: ...r_id" inner join "artappleschema"."user_roles" on "artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column "users.pk_user_id". (SQL: select "artappleschema"."user_assets".*, "artappleschema"."users"."pk_user_id", "artappleschema"."users"."user_name", "artappleschema"."user_roles"."fk_user_id", "artappleschema"."user_roles"."fk_user_type_id" from "artappleschema"."user_assets" inner join "artappleschema"."users" on "artappleschema"."user_assets"."fk_user_id" = "artappleschema"."users"."pk_user_id" inner join "artappleschema"."user_roles" on "artappleschema"."users"."fk_user_id" = "artappleschema"."user_roles"."pk_user_id" where "artappleschema"."user_assets"."status" = Created and (LOWER(artappleschema.user_assets.artwork_title) LIKE %a% or LOWER(artappleschema.user_assets.description) LIKE %a%) order by "created_at" desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.fk_user_id does not exist
LINE 1: ...r_id\" inner join \"artappleschema\".\"user_roles\" on \"artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column \"users.pk_user_id\". (SQL: select \"artappleschema\".\"user_assets\".*, \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"user_name\", \"artappleschema\".\"user_roles\".\"fk_user_id\", \"artappleschema\".\"user_roles\".\"fk_user_type_id\" from \"artappleschema\".\"user_assets\" inner join \"artappleschema\".\"users\" on \"artappleschema\".\"user_assets\".\"fk_user_id\" = \"artappleschema\".\"users\".\"pk_user_id\" inner join \"artappleschema\".\"user_roles\" on \"artappleschema\".\"users\".\"fk_user_id\" = \"artappleschema\".\"user_roles\".\"pk_user_id\" where \"artappleschema\".\"user_assets\".\"status\" = Created and (LOWER(artappleschema.user_assets.artwork_title) LIKE %a% or LOWER(artappleschema.user_assets.description) LIKE %a%) order by \"created_at\" desc) at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure))
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure))
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true)
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#6 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(373): Illuminate\\Database\\Query\\Builder->get()
#7 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#8 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#20 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#28 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#31 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#34 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#36 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#37 {main}

[previous exception] [object] (PDOException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.fk_user_id does not exist
LINE 1: ...r_id\" inner join \"artappleschema\".\"user_roles\" on \"artapples...
                                                             ^
HINT:  Perhaps you meant to reference the column \"users.pk_user_id\". at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:373)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(373): PDOStatement->execute()
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"artappl...', Array)
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure))
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure))
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true)
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#6 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#8 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(373): Illuminate\\Database\\Query\\Builder->get()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#12 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#13 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#20 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#23 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#27 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#30 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#34 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#36 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#37 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#38 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#39 {main}
"} 
[2025-05-07 08:21:08] local.ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR:  missing FROM-clause entry for table "user_roles"
LINE 1: ... where "artappleschema"."users"."status" = $1 and "artapples...
                                                             ^ (SQL: select count(*) as aggregate from "artappleschema"."users" where "artappleschema"."users"."status" = confirmed and "artappleschema"."user_roles"."fk_user_type_id" in (1, 3) and (LOWER(user_name) LIKE %a% or LOWER(biography) LIKE %a% or LOWER(artist_name) LIKE %a%)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42P01): SQLSTATE[42P01]: Undefined table: 7 ERROR:  missing FROM-clause entry for table \"user_roles\"
LINE 1: ... where \"artappleschema\".\"users\".\"status\" = $1 and \"artapples...
                                                             ^ (SQL: select count(*) as aggregate from \"artappleschema\".\"users\" where \"artappleschema\".\"users\".\"status\" = confirmed and \"artappleschema\".\"user_roles\".\"fk_user_type_id\" in (1, 3) and (LOWER(user_name) LIKE %a% or LOWER(biography) LIKE %a% or LOWER(artist_name) LIKE %a%)) at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select count(*)...', Array, Object(Closure))
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select count(*)...', Array, true)
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#6 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2863): Illuminate\\Database\\Query\\Builder->get(Array)
#7 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2791): Illuminate\\Database\\Query\\Builder->aggregate('count', Array)
#8 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(428): Illuminate\\Database\\Query\\Builder->count()
#9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#10 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#12 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#13 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#20 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#23 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#27 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#30 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#34 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#36 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#37 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#38 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#39 {main}

[previous exception] [object] (PDOException(code: 42P01): SQLSTATE[42P01]: Undefined table: 7 ERROR:  missing FROM-clause entry for table \"user_roles\"
LINE 1: ... where \"artappleschema\".\"users\".\"status\" = $1 and \"artapples...
                                                             ^ at D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php:373)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(373): PDOStatement->execute()
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select count(*)...', Array)
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select count(*)...', Array, Object(Closure))
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select count(*)...', Array, true)
#5 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect()
#6 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#8 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2863): Illuminate\\Database\\Query\\Builder->get(Array)
#9 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2791): Illuminate\\Database\\Query\\Builder->aggregate('count', Array)
#10 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(428): Illuminate\\Database\\Query\\Builder->count()
#11 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#12 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#13 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#14 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#15 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#20 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#21 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#23 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#27 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#28 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#29 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#32 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#33 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#34 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#36 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#37 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#38 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#39 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#40 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#41 {main}
"} 
[2025-05-07 08:33:47] local.ERROR: Undefined array key "foreign_key" {"exception":"[object] (ErrorException(code: 0): Undefined array key \"foreign_key\" at D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php:287)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RegistersExceptionHandlers.php(47): Laravel\\Lumen\\Application->handleError(2, 'Undefined array...', 'D:\\\\floence-pro-...', 287)
#1 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(287): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(2, 'Undefined array...', 'D:\\\\floence-pro-...', 287)
#2 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#3 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#4 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#5 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#6 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#7 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#8 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#9 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#10 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#11 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#12 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#20 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#29 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#30 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#31 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#32 {main}
"} 
[2025-05-07 08:34:04] local.ERROR: Undefined array key "foreign_key" {"exception":"[object] (ErrorException(code: 0): Undefined array key \"foreign_key\" at D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php:287)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RegistersExceptionHandlers.php(47): Laravel\\Lumen\\Application->handleError(2, 'Undefined array...', 'D:\\\\floence-pro-...', 287)
#1 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(287): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(2, 'Undefined array...', 'D:\\\\floence-pro-...', 287)
#2 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#3 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#4 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#5 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#6 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#7 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#8 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#9 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#10 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#11 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#12 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#20 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#29 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#30 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#31 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#32 {main}
"} 
[2025-05-07 08:34:23] local.ERROR: Undefined array key "foreign_key" {"exception":"[object] (ErrorException(code: 0): Undefined array key \"foreign_key\" at D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php:287)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RegistersExceptionHandlers.php(47): Laravel\\Lumen\\Application->handleError(2, 'Undefined array...', 'D:\\\\floence-pro-...', 287)
#1 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(287): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(2, 'Undefined array...', 'D:\\\\floence-pro-...', 287)
#2 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#3 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#4 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#5 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#6 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#7 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#8 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#9 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#10 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#11 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#12 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#20 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#29 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#30 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#31 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#32 {main}
"} 
[2025-05-07 08:36:17] local.ERROR: Undefined array key "primary_key" {"exception":"[object] (ErrorException(code: 0): Undefined array key \"primary_key\" at D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php:288)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RegistersExceptionHandlers.php(47): Laravel\\Lumen\\Application->handleError(2, 'Undefined array...', 'D:\\\\floence-pro-...', 288)
#1 D:\\floence-pro-API\\app\\Http\\Controllers\\SearchController.php(288): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(2, 'Undefined array...', 'D:\\\\floence-pro-...', 288)
#2 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request))
#3 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#4 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#5 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#6 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#7 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#8 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#9 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array)
#10 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#11 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#12 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#20 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#21 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#29 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#30 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#31 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#32 {main}
"} 
[2025-05-07 09:42:51] local.ERROR: The payload is invalid. {"exception":"[object] (Illuminate\\Contracts\\Encryption\\DecryptException(code: 0): The payload is invalid. at D:\\floence-pro-API\\vendor\\illuminate\\encryption\\Encrypter.php:221)
[stacktrace]
#0 D:\\floence-pro-API\\vendor\\illuminate\\encryption\\Encrypter.php(158): Illuminate\\Encryption\\Encrypter->getJsonPayload(NULL)
#1 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\helpers.php(98): Illuminate\\Encryption\\Encrypter->decrypt('136')
#2 D:\\floence-pro-API\\app\\Http\\Controllers\\GalleriesController.php(34): decrypt('136')
#3 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\GalleriesController->getGalleries('136')
#4 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#5 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#6 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#7 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#8 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#9 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#10 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\GalleriesController), 'getGalleries', Array)
#11 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#12 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#13 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(172): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#20 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#21 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#26 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#27 {main}
"}