[2025-11-20 11:54:50] local.ERROR: SQLSTATE[08006] [7] could not translate host name "artapplestage.cbmxrfjtcgug.us-east-2.rds.amazonaws.com" to address: Host name lookup failure (SQL: select * from "artappleschema"."app_parms" where "name" = GlobalSearch limit 1) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 7): SQLSTATE[08006] [7] could not translate host name \"artapplestage.cbmxrfjtcgug.us-east-2.rds.amazonaws.com\" to address: Host name lookup failure (SQL: select * from \"artappleschema\".\"app_parms\" where \"name\" = GlobalSearch limit 1) at C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php:712) [stacktrace] #0 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(784): Illuminate\\Database\\Connection->runQueryCallback('select * from \"...', Array, Object(Closure)) #1 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(763): Illuminate\\Database\\Connection->tryAgainIfCausedByLostConnection(Object(Illuminate\\Database\\QueryException), 'select * from \"...', Array, Object(Closure)) #2 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(674): Illuminate\\Database\\Connection->handleQueryException(Object(Illuminate\\Database\\QueryException), 'select * from \"...', Array, Object(Closure)) #3 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select * from \"...', Array, Object(Closure)) #4 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select * from \"...', Array, true) #5 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #6 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Eloquent\\Builder.php(625): Illuminate\\Database\\Query\\Builder->get(Array) #9 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Eloquent\\Builder.php(609): Illuminate\\Database\\Eloquent\\Builder->getModels(Array) #10 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Eloquent\\Builder->get(Array) #11 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Models\\AppParms.php(23): Illuminate\\Database\\Eloquent\\Builder->first() #12 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Controllers\\SearchController.php(241): App\\Models\\AppParms::getAppParmsByName('GlobalSearch') #13 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request)) #14 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #15 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #16 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #17 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #18 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #19 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #20 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array) #21 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #22 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #23 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #24 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #25 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #26 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #27 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #28 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #29 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #30 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array) #31 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #32 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #33 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #34 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #35 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #36 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #37 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #38 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #39 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #40 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #41 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL) #42 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\public\\index.php(28): Laravel\\Lumen\\Application->run() #43 {main} [previous exception] [object] (PDOException(code: 7): SQLSTATE[08006] [7] could not translate host name \"artapplestage.cbmxrfjtcgug.us-east-2.rds.amazonaws.com\" to address: Host name lookup failure at C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connectors\\Connector.php:70) [stacktrace] #0 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connectors\\Connector.php(70): PDO->__construct('pgsql:host=arta...', 'postgres', Object(SensitiveParameterValue), Array) #1 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connectors\\Connector.php(100): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('pgsql:host=arta...', 'postgres', 'Ew$pk246!%*', Array) #2 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connectors\\Connector.php(49): Illuminate\\Database\\Connectors\\Connector->tryAgainIfCausedByLostConnection(Object(PDOException), 'pgsql:host=arta...', 'postgres', 'Ew$pk246!%*', Array) #3 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connectors\\PostgresConnector.php(32): Illuminate\\Database\\Connectors\\Connector->createConnection('pgsql:host=arta...', Array, Array) #4 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connectors\\ConnectionFactory.php(184): Illuminate\\Database\\Connectors\\PostgresConnector->connect(Array) #5 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}() #6 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(1064): call_user_func(Object(Closure)) #7 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(1100): Illuminate\\Database\\Connection->getPdo() #8 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(442): Illuminate\\Database\\Connection->getReadPdo() #9 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(368): Illuminate\\Database\\Connection->getPdoForSelect(true) #10 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select * from \"...', Array) #11 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(784): Illuminate\\Database\\Connection->runQueryCallback('select * from \"...', Array, Object(Closure)) #12 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(763): Illuminate\\Database\\Connection->tryAgainIfCausedByLostConnection(Object(Illuminate\\Database\\QueryException), 'select * from \"...', Array, Object(Closure)) #13 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(674): Illuminate\\Database\\Connection->handleQueryException(Object(Illuminate\\Database\\QueryException), 'select * from \"...', Array, Object(Closure)) #14 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select * from \"...', Array, Object(Closure)) #15 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select * from \"...', Array, true) #16 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #17 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #18 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #19 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Eloquent\\Builder.php(625): Illuminate\\Database\\Query\\Builder->get(Array) #20 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Eloquent\\Builder.php(609): Illuminate\\Database\\Eloquent\\Builder->getModels(Array) #21 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Eloquent\\Builder->get(Array) #22 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Models\\AppParms.php(23): Illuminate\\Database\\Eloquent\\Builder->first() #23 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Controllers\\SearchController.php(241): App\\Models\\AppParms::getAppParmsByName('GlobalSearch') #24 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request)) #25 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #26 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #27 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #28 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #29 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #30 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #31 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array) #32 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #33 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #34 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #35 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #36 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #37 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #38 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #39 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #40 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #41 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array) #42 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #43 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #44 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #45 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #46 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #47 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #48 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #49 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #50 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #51 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #52 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL) #53 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\public\\index.php(28): Laravel\\Lumen\\Application->run() #54 {main} "} [2025-11-20 12:07:34] local.ERROR: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "ELSE" LINE 4: ELSE 'NOT FOR SALE' ^ (SQL: select "artappleschema"."user_assets".*, "artappleschema"."users"."pk_user_id", "artappleschema"."users"."user_name", "artappleschema"."countries"."pk_country_id", "artappleschema"."countries"."country_currency", "artappleschema"."user_roles"."fk_user_id", "artappleschema"."user_roles"."fk_user_type_id", CASE WHEN sale_type = 'For Sale' OR sale_type IS NULL THEN CONCAT(countries.country_currency, ' ', TO_CHAR(artappleschema.user_assets.price, 'FM999,999,999') ELSE 'NOT FOR SALE' END AS price from "artappleschema"."user_assets" inner join "artappleschema"."users" on "artappleschema"."user_assets"."fk_user_id" = "artappleschema"."users"."pk_user_id" inner join "artappleschema"."countries" on "artappleschema"."countries"."pk_country_id" = "artappleschema"."user_assets"."fk_country_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 %test% or LOWER(artappleschema.user_assets.description) LIKE %test%) order by "created_at" desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42601): SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ELSE\" LINE 4: ELSE 'NOT FOR SALE' ^ (SQL: select \"artappleschema\".\"user_assets\".*, \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"user_name\", \"artappleschema\".\"countries\".\"pk_country_id\", \"artappleschema\".\"countries\".\"country_currency\", \"artappleschema\".\"user_roles\".\"fk_user_id\", \"artappleschema\".\"user_roles\".\"fk_user_type_id\", CASE WHEN sale_type = 'For Sale' OR sale_type IS NULL THEN CONCAT(countries.country_currency, ' ', TO_CHAR(artappleschema.user_assets.price, 'FM999,999,999') ELSE 'NOT FOR SALE' END AS price from \"artappleschema\".\"user_assets\" inner join \"artappleschema\".\"users\" on \"artappleschema\".\"user_assets\".\"fk_user_id\" = \"artappleschema\".\"users\".\"pk_user_id\" inner join \"artappleschema\".\"countries\" on \"artappleschema\".\"countries\".\"pk_country_id\" = \"artappleschema\".\"user_assets\".\"fk_country_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 %test% or LOWER(artappleschema.user_assets.description) LIKE %test%) order by \"created_at\" desc) at C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php:712) [stacktrace] #0 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure)) #1 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure)) #2 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true) #3 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #4 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Controllers\\SearchController.php(375): Illuminate\\Database\\Query\\Builder->get() #7 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request)) #8 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #9 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #10 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #11 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #12 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #13 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #14 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array) #15 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #16 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #17 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #18 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #19 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #20 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #21 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #22 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #23 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #24 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array) #25 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #26 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #27 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #28 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #29 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #30 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #31 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #32 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #33 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #34 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #35 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL) #36 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\public\\index.php(28): Laravel\\Lumen\\Application->run() #37 {main} [previous exception] [object] (PDOException(code: 42601): SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ELSE\" LINE 4: ELSE 'NOT FOR SALE' ^ at C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php:373) [stacktrace] #0 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(373): PDOStatement->execute() #1 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"artappl...', Array) #2 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure)) #3 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure)) #4 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true) #5 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #6 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Controllers\\SearchController.php(375): Illuminate\\Database\\Query\\Builder->get() #9 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request)) #10 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #11 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #12 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #13 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #14 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #15 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #16 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array) #17 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #18 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #19 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #20 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #21 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #22 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #23 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #24 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #25 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #26 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array) #27 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #28 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #29 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #30 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #31 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #32 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #33 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #34 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #35 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #36 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #37 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL) #38 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\public\\index.php(28): Laravel\\Lumen\\Application->run() #39 {main} "} [2025-11-20 12:08:43] local.ERROR: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "ELSE" LINE 4: ELSE 'NOT FOR SALE' ^ (SQL: select "artappleschema"."user_assets".*, "artappleschema"."users"."pk_user_id", "artappleschema"."users"."user_name", "artappleschema"."countries"."pk_country_id", "artappleschema"."countries"."country_currency", "artappleschema"."user_roles"."fk_user_id", "artappleschema"."user_roles"."fk_user_type_id", CASE WHEN sale_type = 'For Sale' OR sale_type IS NULL THEN CONCAT(PKR, ' ', TO_CHAR(artappleschema.user_assets.price, 'FM999,999,999') ELSE 'NOT FOR SALE' END AS price from "artappleschema"."user_assets" inner join "artappleschema"."users" on "artappleschema"."user_assets"."fk_user_id" = "artappleschema"."users"."pk_user_id" inner join "artappleschema"."countries" on "artappleschema"."countries"."pk_country_id" = "artappleschema"."user_assets"."fk_country_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 %test% or LOWER(artappleschema.user_assets.description) LIKE %test%) order by "created_at" desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42601): SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ELSE\" LINE 4: ELSE 'NOT FOR SALE' ^ (SQL: select \"artappleschema\".\"user_assets\".*, \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"user_name\", \"artappleschema\".\"countries\".\"pk_country_id\", \"artappleschema\".\"countries\".\"country_currency\", \"artappleschema\".\"user_roles\".\"fk_user_id\", \"artappleschema\".\"user_roles\".\"fk_user_type_id\", CASE WHEN sale_type = 'For Sale' OR sale_type IS NULL THEN CONCAT(PKR, ' ', TO_CHAR(artappleschema.user_assets.price, 'FM999,999,999') ELSE 'NOT FOR SALE' END AS price from \"artappleschema\".\"user_assets\" inner join \"artappleschema\".\"users\" on \"artappleschema\".\"user_assets\".\"fk_user_id\" = \"artappleschema\".\"users\".\"pk_user_id\" inner join \"artappleschema\".\"countries\" on \"artappleschema\".\"countries\".\"pk_country_id\" = \"artappleschema\".\"user_assets\".\"fk_country_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 %test% or LOWER(artappleschema.user_assets.description) LIKE %test%) order by \"created_at\" desc) at C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php:712) [stacktrace] #0 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure)) #1 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure)) #2 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true) #3 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #4 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Controllers\\SearchController.php(375): Illuminate\\Database\\Query\\Builder->get() #7 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request)) #8 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #9 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #10 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #11 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #12 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #13 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #14 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array) #15 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #16 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #17 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #18 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #19 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #20 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #21 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #22 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #23 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #24 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array) #25 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #26 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #27 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #28 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #29 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #30 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #31 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #32 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #33 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #34 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #35 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL) #36 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\public\\index.php(28): Laravel\\Lumen\\Application->run() #37 {main} [previous exception] [object] (PDOException(code: 42601): SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ELSE\" LINE 4: ELSE 'NOT FOR SALE' ^ at C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php:373) [stacktrace] #0 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(373): PDOStatement->execute() #1 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"artappl...', Array) #2 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure)) #3 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure)) #4 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true) #5 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #6 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Controllers\\SearchController.php(375): Illuminate\\Database\\Query\\Builder->get() #9 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request)) #10 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #11 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #12 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #13 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #14 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #15 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #16 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array) #17 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #18 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #19 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #20 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #21 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #22 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #23 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #24 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #25 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #26 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array) #27 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #28 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #29 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #30 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #31 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #32 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #33 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #34 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #35 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #36 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #37 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL) #38 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\public\\index.php(28): Laravel\\Lumen\\Application->run() #39 {main} "} [2025-11-20 12:10:02] local.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR: column "pkr" does not exist LINE 4: CONCAT(PKR, ' ', ^ (SQL: select "artappleschema"."user_assets".*, "artappleschema"."users"."pk_user_id", "artappleschema"."users"."user_name", "artappleschema"."countries"."pk_country_id", "artappleschema"."countries"."country_currency", "artappleschema"."user_roles"."fk_user_id", "artappleschema"."user_roles"."fk_user_type_id", CASE WHEN sale_type = 'For Sale' OR sale_type IS NULL OR sale_type = '' THEN CONCAT(PKR, ' ', TO_CHAR(artappleschema.user_assets.price, 'FM999,999,999')) ELSE 'NOT FOR SALE' END AS price from "artappleschema"."user_assets" inner join "artappleschema"."users" on "artappleschema"."user_assets"."fk_user_id" = "artappleschema"."users"."pk_user_id" inner join "artappleschema"."countries" on "artappleschema"."countries"."pk_country_id" = "artappleschema"."user_assets"."fk_country_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 %test% or LOWER(artappleschema.user_assets.description) LIKE %test%) order by "created_at" desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR: column \"pkr\" does not exist LINE 4: CONCAT(PKR, ' ', ^ (SQL: select \"artappleschema\".\"user_assets\".*, \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"user_name\", \"artappleschema\".\"countries\".\"pk_country_id\", \"artappleschema\".\"countries\".\"country_currency\", \"artappleschema\".\"user_roles\".\"fk_user_id\", \"artappleschema\".\"user_roles\".\"fk_user_type_id\", CASE WHEN sale_type = 'For Sale' OR sale_type IS NULL OR sale_type = '' THEN CONCAT(PKR, ' ', TO_CHAR(artappleschema.user_assets.price, 'FM999,999,999')) ELSE 'NOT FOR SALE' END AS price from \"artappleschema\".\"user_assets\" inner join \"artappleschema\".\"users\" on \"artappleschema\".\"user_assets\".\"fk_user_id\" = \"artappleschema\".\"users\".\"pk_user_id\" inner join \"artappleschema\".\"countries\" on \"artappleschema\".\"countries\".\"pk_country_id\" = \"artappleschema\".\"user_assets\".\"fk_country_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 %test% or LOWER(artappleschema.user_assets.description) LIKE %test%) order by \"created_at\" desc) at C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php:712) [stacktrace] #0 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure)) #1 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure)) #2 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true) #3 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #4 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Controllers\\SearchController.php(378): Illuminate\\Database\\Query\\Builder->get() #7 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request)) #8 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #9 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #10 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #11 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #12 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #13 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #14 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array) #15 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #16 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #17 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #18 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #19 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #20 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #21 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #22 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #23 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #24 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array) #25 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #26 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #27 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #28 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #29 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #30 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #31 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #32 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #33 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #34 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #35 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL) #36 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\public\\index.php(28): Laravel\\Lumen\\Application->run() #37 {main} [previous exception] [object] (PDOException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR: column \"pkr\" does not exist LINE 4: CONCAT(PKR, ' ', ^ at C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php:373) [stacktrace] #0 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(373): PDOStatement->execute() #1 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"artappl...', Array) #2 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure)) #3 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure)) #4 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true) #5 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #6 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Controllers\\SearchController.php(378): Illuminate\\Database\\Query\\Builder->get() #9 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request)) #10 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #11 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #12 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #13 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #14 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #15 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #16 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array) #17 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #18 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #19 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #20 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #21 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #22 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #23 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #24 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #25 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #26 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array) #27 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #28 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #29 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #30 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #31 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #32 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #33 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #34 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #35 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #36 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #37 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL) #38 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\public\\index.php(28): Laravel\\Lumen\\Application->run() #39 {main} "} [2025-11-20 12:10:48] local.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR: column "pkr" does not exist LINE 4: CONCAT(PKR, ' ', ^ (SQL: select "artappleschema"."user_assets".*, "artappleschema"."users"."pk_user_id", "artappleschema"."users"."user_name", "artappleschema"."countries"."pk_country_id", "artappleschema"."countries"."country_currency", "artappleschema"."user_roles"."fk_user_id", "artappleschema"."user_roles"."fk_user_type_id", CASE WHEN sale_type = 'For Sale' THEN CONCAT(PKR, ' ', TO_CHAR(artappleschema.user_assets.price, 'FM999,999,999')) ELSE 'NOT FOR SALE' END AS price from "artappleschema"."user_assets" inner join "artappleschema"."users" on "artappleschema"."user_assets"."fk_user_id" = "artappleschema"."users"."pk_user_id" inner join "artappleschema"."countries" on "artappleschema"."countries"."pk_country_id" = "artappleschema"."user_assets"."fk_country_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 %test% or LOWER(artappleschema.user_assets.description) LIKE %test%) order by "created_at" desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR: column \"pkr\" does not exist LINE 4: CONCAT(PKR, ' ', ^ (SQL: select \"artappleschema\".\"user_assets\".*, \"artappleschema\".\"users\".\"pk_user_id\", \"artappleschema\".\"users\".\"user_name\", \"artappleschema\".\"countries\".\"pk_country_id\", \"artappleschema\".\"countries\".\"country_currency\", \"artappleschema\".\"user_roles\".\"fk_user_id\", \"artappleschema\".\"user_roles\".\"fk_user_type_id\", CASE WHEN sale_type = 'For Sale' THEN CONCAT(PKR, ' ', TO_CHAR(artappleschema.user_assets.price, 'FM999,999,999')) ELSE 'NOT FOR SALE' END AS price from \"artappleschema\".\"user_assets\" inner join \"artappleschema\".\"users\" on \"artappleschema\".\"user_assets\".\"fk_user_id\" = \"artappleschema\".\"users\".\"pk_user_id\" inner join \"artappleschema\".\"countries\" on \"artappleschema\".\"countries\".\"pk_country_id\" = \"artappleschema\".\"user_assets\".\"fk_country_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 %test% or LOWER(artappleschema.user_assets.description) LIKE %test%) order by \"created_at\" desc) at C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php:712) [stacktrace] #0 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure)) #1 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure)) #2 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true) #3 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #4 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Controllers\\SearchController.php(378): Illuminate\\Database\\Query\\Builder->get() #7 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request)) #8 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #9 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #10 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #11 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #12 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #13 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #14 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array) #15 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #16 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #17 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #18 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #19 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #20 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #21 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #22 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #23 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #24 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array) #25 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #26 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #27 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #28 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #29 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #30 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #31 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #32 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #33 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #34 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #35 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL) #36 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\public\\index.php(28): Laravel\\Lumen\\Application->run() #37 {main} [previous exception] [object] (PDOException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR: column \"pkr\" does not exist LINE 4: CONCAT(PKR, ' ', ^ at C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php:373) [stacktrace] #0 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(373): PDOStatement->execute() #1 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"artappl...', Array) #2 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure)) #3 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure)) #4 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true) #5 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #6 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Controllers\\SearchController.php(378): Illuminate\\Database\\Query\\Builder->get() #9 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request)) #10 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #11 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #12 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #13 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #14 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #15 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #16 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array) #17 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #18 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #19 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #20 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #21 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #22 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #23 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #24 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #25 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #26 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array) #27 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #28 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #29 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #30 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #31 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #32 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #33 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #34 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #35 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #36 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #37 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL) #38 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\public\\index.php(28): Laravel\\Lumen\\Application->run() #39 {main} "} [2025-11-20 12:53:31] local.ERROR: SQLSTATE[42702]: Ambiguous column: 7 ERROR: ORDER BY "price" is ambiguous LINE 7: ...appleschema"."user_assets"."status" = $1 order by "price" as... ^ (SQL: select "artappleschema"."user_assets".*, "artappleschema"."countries"."pk_country_id", "artappleschema"."countries"."country_currency", CASE WHEN sale_type = 'For Sale' OR sale_type IS NULL OR sale_type = '' THEN 'PKR ' || TO_CHAR(artappleschema.user_assets.price, 'FM999,999,999') ELSE 'NOT FOR SALE' END AS price from "artappleschema"."user_assets" inner join "artappleschema"."countries" on "artappleschema"."countries"."pk_country_id" = "artappleschema"."user_assets"."fk_country_id" where "artappleschema"."user_assets"."status" = Created order by "price" asc limit 10 offset 0) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42702): SQLSTATE[42702]: Ambiguous column: 7 ERROR: ORDER BY \"price\" is ambiguous LINE 7: ...appleschema\".\"user_assets\".\"status\" = $1 order by \"price\" as... ^ (SQL: select \"artappleschema\".\"user_assets\".*, \"artappleschema\".\"countries\".\"pk_country_id\", \"artappleschema\".\"countries\".\"country_currency\", CASE WHEN sale_type = 'For Sale' OR sale_type IS NULL OR sale_type = '' THEN 'PKR ' || TO_CHAR(artappleschema.user_assets.price, 'FM999,999,999') ELSE 'NOT FOR SALE' END AS price from \"artappleschema\".\"user_assets\" inner join \"artappleschema\".\"countries\" on \"artappleschema\".\"countries\".\"pk_country_id\" = \"artappleschema\".\"user_assets\".\"fk_country_id\" where \"artappleschema\".\"user_assets\".\"status\" = Created order by \"price\" asc limit 10 offset 0) at C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php:712) [stacktrace] #0 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure)) #1 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure)) #2 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true) #3 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #4 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2433): Illuminate\\Database\\Query\\Builder->get(Array) #7 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Controllers\\SearchController.php(389): Illuminate\\Database\\Query\\Builder->paginate(10) #8 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request)) #9 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #10 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #11 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #12 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #13 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #14 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #15 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array) #16 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #17 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #18 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #19 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #20 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #21 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #22 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #23 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #24 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #25 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array) #26 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #27 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #28 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #29 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #30 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #31 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #32 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #33 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #34 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #35 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #36 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL) #37 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\public\\index.php(28): Laravel\\Lumen\\Application->run() #38 {main} [previous exception] [object] (PDOException(code: 42702): SQLSTATE[42702]: Ambiguous column: 7 ERROR: ORDER BY \"price\" is ambiguous LINE 7: ...appleschema\".\"user_assets\".\"status\" = $1 order by \"price\" as... ^ at C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php:373) [stacktrace] #0 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(373): PDOStatement->execute() #1 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select \"artappl...', Array) #2 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select \"artappl...', Array, Object(Closure)) #3 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Connection.php(359): Illuminate\\Database\\Connection->run('select \"artappl...', Array, Object(Closure)) #4 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2413): Illuminate\\Database\\Connection->select('select \"artappl...', Array, true) #5 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #6 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2401): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\database\\Query\\Builder.php(2433): Illuminate\\Database\\Query\\Builder->get(Array) #9 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Controllers\\SearchController.php(389): Illuminate\\Database\\Query\\Builder->paginate(10) #10 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\SearchController->dynamicJoinSearch(Object(Laravel\\Lumen\\Http\\Request)) #11 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #12 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure)) #13 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure)) #14 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL) #15 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array) #16 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(354): Laravel\\Lumen\\Application->callControllerCallable(Array, Array) #17 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\SearchController), 'dynamicJoinSear...', Array) #18 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array) #19 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(262): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array) #20 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #21 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\UserAuthenticate.php(42): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #22 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\UserAuthenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #23 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #24 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #25 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #26 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(261): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #27 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array) #28 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #29 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\ResponseWithDate.php(11): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #30 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\ResponseWithDate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #31 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #32 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\app\\Http\\Middleware\\CorsMiddleware.php(37): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #33 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure)) #34 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #35 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request)) #36 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #37 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure)) #38 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL) #39 C:\\Users\\HaseebRashid\\Downloads\\1757591373484-floenceProd-20250911(a)\\public\\index.php(28): Laravel\\Lumen\\Application->run() #40 {main} "}