Illuminate\Database\QueryException: 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 ') AND imenik.paket = paket.idpaket AND paket > '1' AND active= '-1' ORDER BY ...' at line 1 (Connection: mysql, SQL: SELECT imenik.idcustomer, paket, categories_imenik.idcategory, tvrtka, opistvrtke, ime, prezime, opcina, adresa, logo, poddomena, adresa, zip, grad, kvart, tel, email, web, prior, nofollow, radnovrijeme, mapskord, folder, paket.prioritet FROM imenik, categories_imenik, paket WHERE imenik.idcustomer=categories_imenik.idcustomer AND categories_imenik.idCategory='197' AND () AND imenik.paket = paket.idpaket AND paket > '1' AND active= '-1' ORDER BY FIELD (imenik.grad, '10030')) in file C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Database\Connection.php on line 829 #0 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Database\Connection.php(783): Illuminate\Database\Connection->runQueryCallback() #1 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Database\Connection.php(414): Illuminate\Database\Connection->run() #2 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php(509): Illuminate\Database\Connection->select() #3 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(355): Illuminate\Database\DatabaseManager->__call() #4 C:\inetpub\vhosts\ecroatia.info\httpdocs\app\Helpers\HelperApi.php(4167): Illuminate\Support\Facades\Facade::__callStatic() #5 C:\inetpub\vhosts\ecroatia.info\httpdocs\app\Http\Controllers\Frontend\CategoryController.php(481): App\Helpers\HelperApi->getCategoryResults() #6 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(54): App\Http\Controllers\Frontend\CategoryController->showCategory() #7 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction() #8 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Routing\Route.php(259): Illuminate\Routing\ControllerDispatcher->dispatch() #9 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Routing\Route.php(205): Illuminate\Routing\Route->runController() #10 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Routing\Router.php(806): Illuminate\Routing\Route->run() #11 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(144): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #12 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #13 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(183): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #14 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #15 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(183): Illuminate\View\Middleware\ShareErrorsFromSession->handle() #16 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #17 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest() #18 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(183): Illuminate\Session\Middleware\StartSession->handle() #19 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #20 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(183): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #21 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #22 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(183): Illuminate\Cookie\Middleware\EncryptCookies->handle() #23 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #24 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Routing\Router.php(805): Illuminate\Pipeline\Pipeline->then() #25 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Routing\Router.php(784): Illuminate\Routing\Router->runRouteWithinStack() #26 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Routing\Router.php(748): Illuminate\Routing\Router->runRoute() #27 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Routing\Router.php(737): Illuminate\Routing\Router->dispatchToRoute() #28 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(200): Illuminate\Routing\Router->dispatch() #29 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(144): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #30 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #31 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(183): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #32 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #33 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(175): Illuminate\Pipeline\Pipeline->then() #34 C:\inetpub\vhosts\ecroatia.info\httpdocs\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #35 C:\inetpub\vhosts\ecroatia.info\httpdocs\index.php(51): Illuminate\Foundation\Http\Kernel->handle() #36 {main}