[2025-05-05 14:52:21] local.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.pk_user_id does not exist
LINE 1: ..."galleries"."pk_gallery_id" inner join "users" on "users"."p...
                                                             ^ (SQL: select "galleries"."gallery_title", "galleries"."pk_gallery_id", "users"."user_name" as "created_by", "galleries_assets"."created_at", "galleries_assets"."updated_at", "artappleschema"."galleries_assets"."fk_user_asset_id" as "laravel_through_key" from "artappleschema"."galleries" inner join "artappleschema"."galleries_assets" on "artappleschema"."galleries_assets"."fk_gallery_id" = "artappleschema"."galleries"."pk_gallery_id" inner join "users" on "users"."pk_user_id" = "galleries_assets"."created_by" where ("galleries_assets"."status" != Active or "galleries"."archive_date"::date < 2025-05-05) and "artappleschema"."galleries_assets"."fk_user_asset_id" in (352) order by "galleries_assets"."created_at" desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.pk_user_id does not exist
LINE 1: ...\"galleries\".\"pk_gallery_id\" inner join \"users\" on \"users\".\"p...
                                                             ^ (SQL: select \"galleries\".\"gallery_title\", \"galleries\".\"pk_gallery_id\", \"users\".\"user_name\" as \"created_by\", \"galleries_assets\".\"created_at\", \"galleries_assets\".\"updated_at\", \"artappleschema\".\"galleries_assets\".\"fk_user_asset_id\" as \"laravel_through_key\" from \"artappleschema\".\"galleries\" inner join \"artappleschema\".\"galleries_assets\" on \"artappleschema\".\"galleries_assets\".\"fk_gallery_id\" = \"artappleschema\".\"galleries\".\"pk_gallery_id\" inner join \"users\" on \"users\".\"pk_user_id\" = \"galleries_assets\".\"created_by\" where (\"galleries_assets\".\"status\" != Active or \"galleries\".\"archive_date\"::date < 2025-05-05) and \"artappleschema\".\"galleries_assets\".\"fk_user_asset_id\" in (352) order by \"galleries_assets\".\"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 \"galleri...', Array, Object(Closure))
#1 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"galleri...', Array, Object(Closure))
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"galleri...', 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\\Eloquent\\Builder.php(625): Illuminate\\Database\\Query\\Builder->get(Array)
#7 D:\\floence-pro-API\\vendor\\illuminate\\database\\Eloquent\\Relations\\HasManyThrough.php(390): Illuminate\\Database\\Eloquent\\Builder->getModels()
#8 D:\\floence-pro-API\\vendor\\illuminate\\database\\Eloquent\\Relations\\Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\HasManyThrough->get()
#9 D:\\floence-pro-API\\vendor\\illuminate\\database\\Eloquent\\Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()
#10 D:\\floence-pro-API\\vendor\\illuminate\\database\\Eloquent\\Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, 'inactiveOrArchi...', Object(Closure))
#11 D:\\floence-pro-API\\vendor\\illuminate\\database\\Eloquent\\Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)
#12 D:\\floence-pro-API\\vendor\\illuminate\\database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Eloquent\\Builder->get(Array)
#13 D:\\floence-pro-API\\app\\Models\\UserAsset.php(302): Illuminate\\Database\\Eloquent\\Builder->first()
#14 D:\\floence-pro-API\\app\\Http\\Controllers\\UserAssetsController.php(1013): App\\Models\\UserAsset::getUserAssetById('352', 7)
#15 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\UserAssetsController->getUserAssetById('352', 7, 7)
#16 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#17 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#18 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#19 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#20 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#21 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\UserAssetsController), 'getUserAssetByI...', Array)
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(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\\UserAuthenticate.php(42): 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\\UserAuthenticate->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\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#31 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#32 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(172): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#34 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))
#35 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#36 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#37 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#38 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#39 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#40 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#41 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#42 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#43 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#44 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#45 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#46 {main}

[previous exception] [object] (PDOException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column users.pk_user_id does not exist
LINE 1: ...\"galleries\".\"pk_gallery_id\" inner join \"users\" on \"users\".\"p...
                                                             ^ 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 \"galleri...', Array)
#2 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"galleri...', Array, Object(Closure))
#3 D:\\floence-pro-API\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"galleri...', Array, Object(Closure))
#4 D:\\floence-pro-API\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"galleri...', 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\\Eloquent\\Builder.php(625): Illuminate\\Database\\Query\\Builder->get(Array)
#9 D:\\floence-pro-API\\vendor\\illuminate\\database\\Eloquent\\Relations\\HasManyThrough.php(390): Illuminate\\Database\\Eloquent\\Builder->getModels()
#10 D:\\floence-pro-API\\vendor\\illuminate\\database\\Eloquent\\Relations\\Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\HasManyThrough->get()
#11 D:\\floence-pro-API\\vendor\\illuminate\\database\\Eloquent\\Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()
#12 D:\\floence-pro-API\\vendor\\illuminate\\database\\Eloquent\\Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, 'inactiveOrArchi...', Object(Closure))
#13 D:\\floence-pro-API\\vendor\\illuminate\\database\\Eloquent\\Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)
#14 D:\\floence-pro-API\\vendor\\illuminate\\database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Eloquent\\Builder->get(Array)
#15 D:\\floence-pro-API\\app\\Models\\UserAsset.php(302): Illuminate\\Database\\Eloquent\\Builder->first()
#16 D:\\floence-pro-API\\app\\Http\\Controllers\\UserAssetsController.php(1013): App\\Models\\UserAsset::getUserAssetById('352', 7)
#17 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\UserAssetsController->getUserAssetById('352', 7, 7)
#18 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#19 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#20 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#21 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#22 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#23 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#24 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\UserAssetsController), 'getUserAssetByI...', Array)
#25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(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\\UserAuthenticate.php(42): 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\\UserAuthenticate->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\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#33 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#34 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#35 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(172): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#36 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))
#37 D:\\floence-pro-API\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#38 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#39 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#40 D:\\floence-pro-API\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#41 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#42 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#43 D:\\floence-pro-API\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#44 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#45 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#46 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#47 D:\\floence-pro-API\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#48 {main}
"}