[2022-07-05 13:34:56] development.ERROR: Undefined variable:  {"exception":"[object] (ErrorException(code: 0): Undefined variable:  at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php:120)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RegistersExceptionHandlers.php(47): Laravel\\Lumen\\Application->handleError(8, 'Undefined varia...', 'C:\\\\xampp2\\\\htdoc...', 120)
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(120): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(8, 'Undefined varia...', 'C:\\\\xampp2\\\\htdoc...', 120, Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#30 {main}
"} 
[2022-07-05 13:34:58] development.ERROR: Undefined variable:  {"exception":"[object] (ErrorException(code: 0): Undefined variable:  at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php:120)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RegistersExceptionHandlers.php(47): Laravel\\Lumen\\Application->handleError(8, 'Undefined varia...', 'C:\\\\xampp2\\\\htdoc...', 120)
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(120): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(8, 'Undefined varia...', 'C:\\\\xampp2\\\\htdoc...', 120, Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#30 {main}
"} 
[2022-07-05 13:35:05] development.ERROR: Undefined variable:  {"exception":"[object] (ErrorException(code: 0): Undefined variable:  at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php:120)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RegistersExceptionHandlers.php(47): Laravel\\Lumen\\Application->handleError(8, 'Undefined varia...', 'C:\\\\xampp2\\\\htdoc...', 120)
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(120): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(8, 'Undefined varia...', 'C:\\\\xampp2\\\\htdoc...', 120, Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#30 {main}
"} 
[2022-07-05 13:38:16] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IS NULL 
            THEN (paisje_id='' AND user='7')
	ELSE (Reagjent_id=''...' at line 3 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE
        CASE
	WHEN  IS NULL 
            THEN (paisje_id='' AND user='7')
	ELSE (Reagjent_id='' AND user='7')
           ) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IS NULL 
            THEN (paisje_id='' AND user='7')
\tELSE (Reagjent_id=''...' at line 3 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE
        CASE
\tWHEN  IS NULL 
            THEN (paisje_id='' AND user='7')
\tELSE (Reagjent_id='' AND user='7')
           ) at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(124): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#33 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IS NULL 
            THEN (paisje_id='' AND user='7')
\tELSE (Reagjent_id=''...' at line 3 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT * FROM `...')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT * FROM `...', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(124): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#35 {main}
"} 
[2022-07-05 13:38:53] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE
        CASE
	WHEN '' IS NULL 
            THEN (paisje_id='' AND user='7')
	ELSE (Reagjent_id='' AND user='7')
           ) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE
        CASE
\tWHEN '' IS NULL 
            THEN (paisje_id='' AND user='7')
\tELSE (Reagjent_id='' AND user='7')
           ) at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(124): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#33 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT * FROM `...')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT * FROM `...', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(124): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#35 {main}
"} 
[2022-07-05 13:39:09] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IS NULL 
            THEN (paisje_id='' AND user='7')
	ELSE (Reagjent_id=''...' at line 3 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE
        CASE
	WHEN  IS NULL 
            THEN (paisje_id='' AND user='7')
	ELSE (Reagjent_id='' AND user='7')
           ) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IS NULL 
            THEN (paisje_id='' AND user='7')
\tELSE (Reagjent_id=''...' at line 3 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE
        CASE
\tWHEN  IS NULL 
            THEN (paisje_id='' AND user='7')
\tELSE (Reagjent_id='' AND user='7')
           ) at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(124): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#33 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IS NULL 
            THEN (paisje_id='' AND user='7')
\tELSE (Reagjent_id=''...' at line 3 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT * FROM `...')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT * FROM `...', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(124): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#35 {main}
"} 
[2022-07-05 13:39:19] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE
        CASE
	WHEN null IS NULL 
            THEN (paisje_id='' AND user='7')
	ELSE (Reagjent_id='null' AND user='7')
           ) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE
        CASE
\tWHEN null IS NULL 
            THEN (paisje_id='' AND user='7')
\tELSE (Reagjent_id='null' AND user='7')
           ) at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(124): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#33 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT * FROM `...')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT * FROM `...', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(124): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#35 {main}
"} 
[2022-07-05 13:39:23] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE
        CASE
	WHEN null IS NULL 
            THEN (paisje_id='' AND user='7')
	ELSE (Reagjent_id='null' AND user='7')
           ) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE
        CASE
\tWHEN null IS NULL 
            THEN (paisje_id='' AND user='7')
\tELSE (Reagjent_id='null' AND user='7')
           ) at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(124): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#33 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 5 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT * FROM `...')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT * FROM `...', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(124): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#35 {main}
"} 
[2022-07-05 13:47:45] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OR (Reagjent_id='1' AND user='7'' at line 1 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE  OR (Reagjent_id='1' AND user='7') {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OR (Reagjent_id='1' AND user='7'' at line 1 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE  OR (Reagjent_id='1' AND user='7') at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(121): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#33 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OR (Reagjent_id='1' AND user='7'' at line 1 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT * FROM `...')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT * FROM `...', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(121): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#35 {main}
"} 
[2022-07-05 13:48:15] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE   (Reagjent_id='1' AND user='7') {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE   (Reagjent_id='1' AND user='7') at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(121): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#33 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT * FROM `...')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT * FROM `...', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(121): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#35 {main}
"} 
[2022-07-05 13:48:37] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE (Reagjent_id='1' AND user='7') {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 (SQL: SELECT * FROM `blerjapaisjev_temporary` WHERE (Reagjent_id='1' AND user='7') at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(121): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#33 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT * FROM `...')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT * FROM `...', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT * FROM `...', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT * FROM `...', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT * FROM `...')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(121): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->blerjatemp(Object(Laravel\\Lumen\\Http\\Request))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'blerjatemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(169): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#35 {main}
"} 
[2022-07-05 13:52:47] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as e...' at line 2 (SQL: SELECT bt.*,br.emri_prodhuesit,p.emri_pajisjes
        CASE bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as emri_pajisjes
        end
        WHEN  FROM blerjapaisjev_temporary bt 
        LEFT JOIN firma_prodhuese_pajisjeve br ON br.id=bt.brand_id 
        LEFT JOIN pajisja p ON p.id=bt.paisje_id
        LEFT JOIN stockureagjent st ON st.ID=bt.Reagjent_id
         WHERE user=7) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as e...' at line 2 (SQL: SELECT bt.*,br.emri_prodhuesit,p.emri_pajisjes
        CASE bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as emri_pajisjes
        end
        WHEN  FROM blerjapaisjev_temporary bt 
        LEFT JOIN firma_prodhuese_pajisjeve br ON br.id=bt.brand_id 
        LEFT JOIN pajisja p ON p.id=bt.paisje_id
        LEFT JOIN stockureagjent st ON st.ID=bt.Reagjent_id
         WHERE user=7) at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT bt.*,br....', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT bt.*,br....', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT bt.*,br....')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(230): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->gettemp('7')
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(173): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#34 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as e...' at line 2 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT bt.*,br....')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT bt.*,br....', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT bt.*,br....', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT bt.*,br....', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT bt.*,br....')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(230): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->gettemp('7')
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(173): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#35 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#36 {main}
"} 
[2022-07-05 13:52:48] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as e...' at line 2 (SQL: SELECT bt.*,br.emri_prodhuesit,p.emri_pajisjes
        CASE bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as emri_pajisjes
        end
        WHEN  FROM blerjapaisjev_temporary bt 
        LEFT JOIN firma_prodhuese_pajisjeve br ON br.id=bt.brand_id 
        LEFT JOIN pajisja p ON p.id=bt.paisje_id
        LEFT JOIN stockureagjent st ON st.ID=bt.Reagjent_id
         WHERE user=7) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as e...' at line 2 (SQL: SELECT bt.*,br.emri_prodhuesit,p.emri_pajisjes
        CASE bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as emri_pajisjes
        end
        WHEN  FROM blerjapaisjev_temporary bt 
        LEFT JOIN firma_prodhuese_pajisjeve br ON br.id=bt.brand_id 
        LEFT JOIN pajisja p ON p.id=bt.paisje_id
        LEFT JOIN stockureagjent st ON st.ID=bt.Reagjent_id
         WHERE user=7) at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT bt.*,br....', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT bt.*,br....', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT bt.*,br....')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(230): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->gettemp('7')
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(173): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#34 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as e...' at line 2 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT bt.*,br....')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT bt.*,br....', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT bt.*,br....', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT bt.*,br....', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT bt.*,br....')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(230): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->gettemp('7')
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(173): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#35 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#36 {main}
"} 
[2022-07-05 13:53:08] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri...' at line 2 (SQL: SELECT bt.*,br.emri_prodhuesit,p.emri_pajisjes
        CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as emri_pajisjes
        
        WHEN  FROM blerjapaisjev_temporary bt 
        LEFT JOIN firma_prodhuese_pajisjeve br ON br.id=bt.brand_id 
        LEFT JOIN pajisja p ON p.id=bt.paisje_id
        LEFT JOIN stockureagjent st ON st.ID=bt.Reagjent_id
         WHERE user=7) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri...' at line 2 (SQL: SELECT bt.*,br.emri_prodhuesit,p.emri_pajisjes
        CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as emri_pajisjes
        
        WHEN  FROM blerjapaisjev_temporary bt 
        LEFT JOIN firma_prodhuese_pajisjeve br ON br.id=bt.brand_id 
        LEFT JOIN pajisja p ON p.id=bt.paisje_id
        LEFT JOIN stockureagjent st ON st.ID=bt.Reagjent_id
         WHERE user=7) at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT bt.*,br....', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT bt.*,br....', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT bt.*,br....')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(230): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->gettemp('7')
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(173): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#34 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri...' at line 2 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT bt.*,br....')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT bt.*,br....', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT bt.*,br....', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT bt.*,br....', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT bt.*,br....')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(230): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->gettemp('7')
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(173): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#35 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#36 {main}
"} 
[2022-07-05 13:53:32] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri...' at line 2 (SQL: SELECT bt.*,br.emri_prodhuesit,p.emri_pajisjes
        CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as emri_pajisjes
        END
        WHEN  FROM blerjapaisjev_temporary bt 
        LEFT JOIN firma_prodhuese_pajisjeve br ON br.id=bt.brand_id 
        LEFT JOIN pajisja p ON p.id=bt.paisje_id
        LEFT JOIN stockureagjent st ON st.ID=bt.Reagjent_id
         WHERE user=7) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri...' at line 2 (SQL: SELECT bt.*,br.emri_prodhuesit,p.emri_pajisjes
        CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as emri_pajisjes
        END
        WHEN  FROM blerjapaisjev_temporary bt 
        LEFT JOIN firma_prodhuese_pajisjeve br ON br.id=bt.brand_id 
        LEFT JOIN pajisja p ON p.id=bt.paisje_id
        LEFT JOIN stockureagjent st ON st.ID=bt.Reagjent_id
         WHERE user=7) at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT bt.*,br....', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT bt.*,br....', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT bt.*,br....')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(230): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->gettemp('7')
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(173): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#34 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri...' at line 2 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT bt.*,br....')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT bt.*,br....', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT bt.*,br....', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT bt.*,br....', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT bt.*,br....')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(230): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->gettemp('7')
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(173): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#35 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#36 {main}
"} 
[2022-07-05 13:54:20] development.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri...' at line 2 (SQL: SELECT bt.*,br.emri_prodhuesit,p.emri_pajisjes
        CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as emri_pajisjes
        END
          FROM blerjapaisjev_temporary bt 
        LEFT JOIN firma_prodhuese_pajisjeve br ON br.id=bt.brand_id 
        LEFT JOIN pajisja p ON p.id=bt.paisje_id
        LEFT JOIN stockureagjent st ON st.ID=bt.Reagjent_id
         WHERE user=7) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri...' at line 2 (SQL: SELECT bt.*,br.emri_prodhuesit,p.emri_pajisjes
        CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri as emri_pajisjes
        END
          FROM blerjapaisjev_temporary bt 
        LEFT JOIN firma_prodhuese_pajisjeve br ON br.id=bt.brand_id 
        LEFT JOIN pajisja p ON p.id=bt.paisje_id
        LEFT JOIN stockureagjent st ON st.ID=bt.Reagjent_id
         WHERE user=7) at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:712)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT bt.*,br....', Array, Object(Closure))
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT bt.*,br....', Array, Object(Closure))
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT bt.*,br....')
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(230): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->gettemp('7')
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array, Array)
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array)
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(173): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#34 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE WHEN bt.Reagjent_id IS NULL THEN p.emri_pajisjes 
        ELSE  st.Emri...' at line 2 at C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php:368)
[stacktrace]
#0 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(368): PDO->prepare('SELECT bt.*,br....')
#1 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('SELECT bt.*,br....', Array)
#2 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('SELECT bt.*,br....', Array, Object(Closure))
#3 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\Connection.php(376): Illuminate\\Database\\Connection->run('SELECT bt.*,br....', Array, Object(Closure))
#4 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\database\\DatabaseManager.php(442): Illuminate\\Database\\Connection->select('SELECT bt.*,br....')
#5 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\support\\Facades\\Facade.php(261): Illuminate\\Database\\DatabaseManager->__call('select', Array)
#6 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Controllers\\PorosiController.php(230): Illuminate\\Support\\Facades\\Facade::__callStatic('select', Array)
#7 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(36): App\\Http\\Controllers\\PorosiController->gettemp('7')
#8 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#9 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#10 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#11 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#12 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(389): Illuminate\\Container\\Container->call(Array, Array)
#13 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(374): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#14 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#15 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\Authenticate.php(93): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#16 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\Authenticate->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#17 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#18 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#19 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#20 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(375): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#21 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(351): Laravel\\Lumen\\Application->callLumenControllerWithMiddleware(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array, Array)
#22 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(329): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\PorosiController), 'gettemp', Array)
#23 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(282): Laravel\\Lumen\\Application->callControllerAction(Array)
#24 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(267): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#25 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(237): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#26 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(173): Laravel\\Lumen\\Application->handleDispatcherResponse(Array)
#27 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(48): Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#28 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\app\\Http\\Middleware\\CorsMiddleware.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#29 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(167): App\\Http\\Middleware\\CorsMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#30 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\illuminate\\pipeline\\Pipeline.php(103): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(426): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#33 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(175): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#34 C:\\xampp2\\htdocs\\atomi\\thelogin\\lumenapi\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(112): Laravel\\Lumen\\Application->dispatch(NULL)
#35 C:\\xampp2\\htdocs\\atomi\\thelogin\\api\\index.php(30): Laravel\\Lumen\\Application->run()
#36 {main}
"}