[2025-05-06 07:57:13] local.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR: column users.fk_user_type_id does not exist LINE 1: ...users" left join "artappleschema"."user_types" on "artapples... ^ HINT: Perhaps you meant to reference the column "users.fk_user_type_id-1". (SQL: select "artappleschema"."users"."picture_location", "artappleschema"."users"."pk_user_id", "artappleschema"."users"."artist_name" from "artappleschema"."users" left join "artappleschema"."user_types" on "artappleschema"."users"."fk_user_type_id" = "artappleschema"."user_types"."pk_user_type_id" left join "artappleschema"."user_assets" on "artappleschema"."users"."pk_user_id" = "artappleschema"."user_assets"."fk_user_id" where "artappleschema"."user_types"."user_type" = ARTIST and "artappleschema"."users"."active" = 1 and "artappleschema"."user_assets"."pk_user_asset_id" is not null and "artappleschema"."user_assets"."status" = Created and "artappleschema"."users"."status" = confirmed group by "artappleschema"."users"."pk_user_id", "artappleschema"."users"."picture_location", "artappleschema"."users"."artist_name") {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR: column users.fk_user_type_id does not exist LINE 1: ...users\" left join \"artappleschema\".\"user_types\" on \"artapples... ^ HINT: Perhaps you meant to reference the column \"users.fk_user_type_id-1\". (SQL: select \"artappleschema\".\"users\".\"picture_location\", \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"artist_name\" from \"artappleschema\".\"users\" left join \"artappleschema\".\"user_types\" on \"artappleschema\".\"users\".\"fk_user_type_id\" = \"artappleschema\".\"user_types\".\"pk_user_type_id\" left join \"artappleschema\".\"user_assets\" on \"artappleschema\".\"users\".\"pk_user_id\" = \"artappleschema\".\"user_assets\".\"fk_user_id\" where \"artappleschema\".\"user_types\".\"user_type\" = ARTIST and \"artappleschema\".\"users\".\"active\" = 1 and \"artappleschema\".\"user_assets\".\"pk_user_asset_id\" is not null and \"artappleschema\".\"user_assets\".\"status\" = Created and \"artappleschema\".\"users\".\"status\" = confirmed group by \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"picture_location\", \"artappleschema\".\"users\".\"artist_name\") 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\\Models\\User.php(137): Illuminate\\Database\\Query\\Builder->get() #7 D:\\floence-pro-API\\app\\Services\\UserServices.php(506): App\\Models\\User::getArtists() #8 D:\\floence-pro-API\\app\\Http\\Controllers\\UserController.php(61): App\\Services\\UserServices::getArtists() #9 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\UserController->getArtists() #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\\UserController), 'getArtists', 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: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR: column users.fk_user_type_id does not exist LINE 1: ...users\" left join \"artappleschema\".\"user_types\" on \"artapples... ^ HINT: Perhaps you meant to reference the column \"users.fk_user_type_id-1\". 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\\Models\\User.php(137): Illuminate\\Database\\Query\\Builder->get() #9 D:\\floence-pro-API\\app\\Services\\UserServices.php(506): App\\Models\\User::getArtists() #10 D:\\floence-pro-API\\app\\Http\\Controllers\\UserController.php(61): App\\Services\\UserServices::getArtists() #11 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\UserController->getArtists() #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\\UserController), 'getArtists', 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-06 07:57:30] local.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR: column users.fk_user_type_id does not exist LINE 1: ...users" left join "artappleschema"."user_types" on "artapples... ^ HINT: Perhaps you meant to reference the column "users.fk_user_type_id-1". (SQL: select "artappleschema"."users"."pk_user_id", "artappleschema"."users"."user_name", "artappleschema"."users"."email", "artappleschema"."users"."phone", "artappleschema"."users"."address1", "artappleschema"."users"."address2", "artappleschema"."users"."city", "artappleschema"."users"."zip", "artappleschema"."users"."artist_name", "artappleschema"."users"."dob", "artappleschema"."users"."gender", "artappleschema"."users"."state", "artappleschema"."users"."biography", "artappleschema"."users"."picture_location", "artappleschema"."user_types"."user_type", "artappleschema"."users"."country", "artappleschema"."users"."countrycode" from "artappleschema"."users" left join "artappleschema"."user_types" on "artappleschema"."users"."fk_user_type_id" = "artappleschema"."user_types"."pk_user_type_id" where "artappleschema"."users"."status" != deleted and "artappleschema"."users"."pk_user_id" = 7) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR: column users.fk_user_type_id does not exist LINE 1: ...users\" left join \"artappleschema\".\"user_types\" on \"artapples... ^ HINT: Perhaps you meant to reference the column \"users.fk_user_type_id-1\". (SQL: select \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"user_name\", \"artappleschema\".\"users\".\"email\", \"artappleschema\".\"users\".\"phone\", \"artappleschema\".\"users\".\"address1\", \"artappleschema\".\"users\".\"address2\", \"artappleschema\".\"users\".\"city\", \"artappleschema\".\"users\".\"zip\", \"artappleschema\".\"users\".\"artist_name\", \"artappleschema\".\"users\".\"dob\", \"artappleschema\".\"users\".\"gender\", \"artappleschema\".\"users\".\"state\", \"artappleschema\".\"users\".\"biography\", \"artappleschema\".\"users\".\"picture_location\", \"artappleschema\".\"user_types\".\"user_type\", \"artappleschema\".\"users\".\"country\", \"artappleschema\".\"users\".\"countrycode\" from \"artappleschema\".\"users\" left join \"artappleschema\".\"user_types\" on \"artappleschema\".\"users\".\"fk_user_type_id\" = \"artappleschema\".\"user_types\".\"pk_user_type_id\" where \"artappleschema\".\"users\".\"status\" != deleted and \"artappleschema\".\"users\".\"pk_user_id\" = 7) 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\\Models\\User.php(90): Illuminate\\Database\\Query\\Builder->get() #7 D:\\floence-pro-API\\app\\Http\\Controllers\\GalleriesController.php(529): App\\Models\\User::getUserById(7) #8 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\GalleriesController->getAllGalleriesForHomeWithSorting(Object(Laravel\\Lumen\\Http\\Request), 'Date', '1', NULL) #9 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #10 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #11 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #12 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #13 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #14 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\GalleriesController), 'getAllGalleries...', Array) #16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #18 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)) #19 D:\\floence-pro-API\\app\\Http\\Middleware\\UserAuthenticate.php(42): 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\\UserAuthenticate->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(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array) #26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(172): Laravel\\Lumen\\Application->handleDispatcherResponse(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: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR: column users.fk_user_type_id does not exist LINE 1: ...users\" left join \"artappleschema\".\"user_types\" on \"artapples... ^ HINT: Perhaps you meant to reference the column \"users.fk_user_type_id-1\". 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\\Models\\User.php(90): Illuminate\\Database\\Query\\Builder->get() #9 D:\\floence-pro-API\\app\\Http\\Controllers\\GalleriesController.php(529): App\\Models\\User::getUserById(7) #10 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\GalleriesController->getAllGalleriesForHomeWithSorting(Object(Laravel\\Lumen\\Http\\Request), 'Date', '1', NULL) #11 D:\\floence-pro-API\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #12 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #13 D:\\floence-pro-API\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #14 D:\\floence-pro-API\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #15 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #16 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #17 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\GalleriesController), 'getAllGalleries...', Array) #18 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #19 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(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\\UserAuthenticate.php(42): 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\\UserAuthenticate->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\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #25 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #26 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #27 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array) #28 D:\\floence-pro-API\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(172): Laravel\\Lumen\\Application->handleDispatcherResponse(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} "}