29. Illuminate\Database\QueryException
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php625
28. CategoryController index
<#unknown>0
27. Illuminate\Routing\Router Illuminate\Routing\{closure}
<#unknown>0
26. PDOException
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php301
25. PDOStatement execute
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php301
24. Illuminate\Database\Connection Illuminate\Database\{closure}
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php617
23. Illuminate\Database\Connection runQueryCallback
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php581
22. Illuminate\Database\Connection run
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php304
21. Illuminate\Database\Connection select
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Query/­Builder.php1412
20. Illuminate\Database\Query\Builder runSelect
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Query/­Builder.php1397
19. Illuminate\Database\Query\Builder getFresh
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Query/­Builder.php1384
18. Illuminate\Database\Query\Builder get
…/­app/­TCApp/­Repositories/­FeatureRepository.php90
17. TCApp\Repositories\FeatureRepository byProductCategory
…/­app/­controllers/­CategoryController.php48
16. CategoryController index
<#unknown>0
15. call_user_func_array
…/­vendor/­laravel/­framework/­src/­Illuminate/­Routing/­Controller.php231
14. Illuminate\Routing\Controller callAction
…/­bootstrap/­compiled.php5848
13. Illuminate\Routing\ControllerDispatcher call
…/­bootstrap/­compiled.php5836
12. Illuminate\Routing\ControllerDispatcher dispatch
…/­bootstrap/­compiled.php5041
11. Illuminate\Routing\Router Illuminate\Routing\{closure}
<#unknown>0
10. call_user_func_array
…/­bootstrap/­compiled.php5399
9. Illuminate\Routing\Route run
…/­bootstrap/­compiled.php5066
8. Illuminate\Routing\Router dispatchToRoute
…/­bootstrap/­compiled.php5054
7. Illuminate\Routing\Router dispatch
…/­bootstrap/­compiled.php715
6. Illuminate\Foundation\Application dispatch
…/­bootstrap/­compiled.php696
5. Illuminate\Foundation\Application handle
…/­bootstrap/­compiled.php7826
4. Illuminate\Session\Middleware handle
…/­bootstrap/­compiled.php8433
3. Illuminate\Cookie\Queue handle
…/­bootstrap/­compiled.php8380
2. Illuminate\Cookie\Guard handle
…/­bootstrap/­compiled.php11046
1. Stack\StackedHttpKernel handle
…/­bootstrap/­compiled.php657
0. Illuminate\Foundation\Application run
…/­public/­index.php50

Illuminate \ Database \ QueryException (08P01)

Callstack information; navigate with mouse or keyboard using Ctrl+↑ or Ctrl+↓
Copy-to-clipboard button
Exception message and its type
Code snippet where the error was thrown
Server state information
Application provided context information
Illuminate\Database\QueryException thrown with message "SQLSTATE[08P01]: <<Unknown error>>: 7 ERROR: bind message supplies 1 parameters, but prepared statement "pdo_stmt_00000005" requires 0 (SQL: select "feature_categories"."id", "feature_categories"."name", "feature_categories"."slug", "feature_categories"."type_slug", "feature_categories"."image", "feature_categories"."min", "feature_categories"."max", "feature_categories"."step", "feature_categories"."unit", "feature_categories"."multiple_choice", "feature_categories"."description", "feature_categories_types"."contain_options", "product_categories_feature_categories"."in_search" from "feature_categories" inner join "feature_categories_types" on "feature_categories"."type_slug" = "feature_categories_types"."slug" inner join "product_categories_feature_categories" on "feature_categories"."id" = "product_categories_feature_categories"."feature_category_id" where "feature_categories"."deleted_at" is null and "product_categories_feature_categories"."deleted_at" is null and "feature_categories_types"."deleted_at" is null and 0 = 1 order by "product_categories_feature_categories"."sort" asc)" Stacktrace: #29 Illuminate\Database\QueryException in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625 #28 CategoryController:index in <#unknown>:0 #27 Illuminate\Routing\Router:Illuminate\Routing\{closure} in <#unknown>:0 #26 PDOException in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:301 #25 PDOStatement:execute in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:301 #24 Illuminate\Database\Connection:Illuminate\Database\{closure} in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:617 #23 Illuminate\Database\Connection:runQueryCallback in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:581 #22 Illuminate\Database\Connection:run in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:304 #21 Illuminate\Database\Connection:select in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1412 #20 Illuminate\Database\Query\Builder:runSelect in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1397 #19 Illuminate\Database\Query\Builder:getFresh in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1384 #18 Illuminate\Database\Query\Builder:get in /var/www/html/app/TCApp/Repositories/FeatureRepository.php:90 #17 TCApp\Repositories\FeatureRepository:byProductCategory in /var/www/html/app/controllers/CategoryController.php:48 #16 CategoryController:index in <#unknown>:0 #15 call_user_func_array in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:231 #14 Illuminate\Routing\Controller:callAction in /var/www/html/bootstrap/compiled.php:5848 #13 Illuminate\Routing\ControllerDispatcher:call in /var/www/html/bootstrap/compiled.php:5836 #12 Illuminate\Routing\ControllerDispatcher:dispatch in /var/www/html/bootstrap/compiled.php:5041 #11 Illuminate\Routing\Router:Illuminate\Routing\{closure} in <#unknown>:0 #10 call_user_func_array in /var/www/html/bootstrap/compiled.php:5399 #9 Illuminate\Routing\Route:run in /var/www/html/bootstrap/compiled.php:5066 #8 Illuminate\Routing\Router:dispatchToRoute in /var/www/html/bootstrap/compiled.php:5054 #7 Illuminate\Routing\Router:dispatch in /var/www/html/bootstrap/compiled.php:715 #6 Illuminate\Foundation\Application:dispatch in /var/www/html/bootstrap/compiled.php:696 #5 Illuminate\Foundation\Application:handle in /var/www/html/bootstrap/compiled.php:7826 #4 Illuminate\Session\Middleware:handle in /var/www/html/bootstrap/compiled.php:8433 #3 Illuminate\Cookie\Queue:handle in /var/www/html/bootstrap/compiled.php:8380 #2 Illuminate\Cookie\Guard:handle in /var/www/html/bootstrap/compiled.php:11046 #1 Stack\StackedHttpKernel:handle in /var/www/html/bootstrap/compiled.php:657 #0 Illuminate\Foundation\Application:run in /var/www/html/public/index.php:50

SQLSTATE[08P01]: <<Unknown error>>: 7 ERROR: bind message supplies 1 parameters, but prepared statement "pdo_stmt_00000005" requires 0 (SQL: select "feature_categories"."id", "feature_categories"."name", "feature_categories"."slug", "feature_categories"."type_slug", "feature_categories"."image", "feature_categories"."min", "feature_categories"."max", "feature_categories"."step", "feature_categories"."unit", "feature_categories"."multiple_choice", "feature_categories"."description", "feature_categories_types"."contain_options", "product_categories_feature_categories"."in_search" from "feature_categories" inner join "feature_categories_types" on "feature_categories"."type_slug" = "feature_categories_types"."slug" inner join "product_categories_feature_categories" on "feature_categories"."id" = "product_categories_feature_categories"."feature_category_id" where "feature_categories"."deleted_at" is null and "product_categories_feature_categories"."deleted_at" is null and "feature_categories_types"."deleted_at" is null and 0 = 1 order by "product_categories_feature_categories"."sort" asc)

		}

		// If an exception occurs when attempting to run a query, we'll format the error
		// message to include the bindings with SQL, which will make this exception a
		// lot more helpful to the developer instead of just the database's errors.
		catch (\Exception $e)
		{
			throw new QueryException(
				$query, $this->prepareBindings($bindings), $e
			);
<#unknown>
<#unknown>
			if ($me->pretending()) return array();

			// For select statements, we'll simply execute the query and return an array
			// of the database result set. Each element in the array will be a single
			// row from the database table, and will either be an array or objects.
			$statement = $this->getPdoForSelect($useReadPdo)->prepare($query);

			$statement->execute($me->prepareBindings($bindings));

			return $statement->fetchAll($me->getFetchMode());
Exception message: SQLSTATE[08P01]: <<Unknown error>>: 7 ERROR: bind message supplies 1 parameters, but prepared statement "pdo_stmt_00000005" requires 0
			if ($me->pretending()) return array();

			// For select statements, we'll simply execute the query and return an array
			// of the database result set. Each element in the array will be a single
			// row from the database table, and will either be an array or objects.
			$statement = $this->getPdoForSelect($useReadPdo)->prepare($query);

			$statement->execute($me->prepareBindings($bindings));

			return $statement->fetchAll($me->getFetchMode());
	protected function runQueryCallback($query, $bindings, Closure $callback)
	{
		// To execute the statement, we'll simply call the callback, which will actually
		// run the SQL against the PDO connection. Then we can calculate the time it
		// took to execute and log the query SQL, bindings and time in our memory.
		try
		{
			$result = $callback($this, $query, $bindings);
		}

		$start = microtime(true);

		// Here we will run this query. If an exception occurs we'll determine if it was
		// caused by a connection that has been lost. If that is the cause, we'll try
		// to re-establish connection and re-run the query with a fresh connection.
		try
		{
			$result = $this->runQueryCallback($query, $bindings, $callback);
		}
		catch (QueryException $e)
			// of the database result set. Each element in the array will be a single
			// row from the database table, and will either be an array or objects.
			$statement = $this->getPdoForSelect($useReadPdo)->prepare($query);

			$statement->execute($me->prepareBindings($bindings));

			return $statement->fetchAll($me->getFetchMode());
		});
	}

	protected function runSelect()
	{
		if ($this->useWritePdo)
		{
			return $this->connection->select($this->toSql(), $this->getBindings(), false);
		}

		return $this->connection->select($this->toSql(), $this->getBindings());
	}

	 * @param  array  $columns
	 * @return array|static[]
	 */
	public function getFresh($columns = array('*'))
	{
		if (is_null($this->columns)) $this->columns = $columns;

		return $this->processor->processSelect($this, $this->runSelect());
	}

	 * @param  array  $columns
	 * @return array|static[]
	 */
	public function get($columns = array('*'))
	{
		if ( ! is_null($this->cacheMinutes)) return $this->getCached($columns);

		return $this->getFresh($columns);
	}

            ->whereNull('feature_categories_types.deleted_at')
            ->whereIn('product_categories_feature_categories.product_category_id', $arr);

        // order by
        $query->orderBy('product_categories_feature_categories.sort', 'asc');

        // execute
        $data = $query->get();

        // convert to array
        // get sort params
        $this->data['sort_params'] = $this->category->sanitizeAndFetchFilterQuerySort($filter_query, "+", true);
        // resolve filter queries
        $filter_query = $this->category->resolveFilterQuery($filter_query);
        // shift autoincrement key values with slug for easier control recognizion in template
        $this->data['filter_query'] = $this->category->prepareFilterQueryForView($filter_query);
        // get category features
        $this->data['category_features'] = $this->feature->byProductCategory($this->data['category']['parents_ids']);
        // get products
        $this->data['products'] = $this->category->getProducts(
<#unknown>
	 * @param  array   $parameters
	 * @return \Symfony\Component\HttpFoundation\Response
	 */
	public function callAction($method, $parameters)
	{
		$this->setupLayout();

		$response = call_user_func_array(array($this, $method), $parameters);

		// If no response is returned from the controller action and a layout is being
    {
        Controller::setFilterer($this->filterer);
        return $this->container->make($controller);
    }
    protected function call($instance, $route, $method)
    {
        $parameters = $route->parametersWithoutNulls();
        return $instance->callAction($method, $parameters);
    }
    protected function before($instance, $route, $request, $method)
    }
    public function dispatch(Route $route, Request $request, $controller, $method)
    {
        $instance = $this->makeController($controller);
        $this->assignAfter($instance, $route, $request, $method);
        $response = $this->before($instance, $route, $request, $method);
        if (is_null($response)) {
            $response = $this->call($instance, $route, $method);
        }
        return $response;
    protected function getClassClosure($controller)
    {
        $d = $this->getControllerDispatcher();
        return function () use($d, $controller) {
            $route = $this->current();
            $request = $this->getCurrentRequest();
            list($class, $method) = explode('@', $controller);
            return $d->dispatch($route, $request, $class, $method);
        };
    }
<#unknown>
        }
    }
    public function run()
    {
        $parameters = array_filter($this->parameters(), function ($p) {
            return isset($p);
        });
        return call_user_func_array($this->action['uses'], $parameters);
    }
    public function matches(Request $request, $includingMethod = true)
    }
    public function dispatchToRoute(Request $request)
    {
        $route = $this->findRoute($request);
        $this->events->fire('router.matched', array($route, $request));
        $response = $this->callRouteBefore($route, $request);
        if (is_null($response)) {
            $response = $route->run($request);
        }
        $response = $this->prepareResponse($request, $response);
        return isset($group['namespace']) ? $group['namespace'] . '\\' . $uses : $uses;
    }
    public function dispatch(Request $request)
    {
        $this->currentRequest = $request;
        $response = $this->callFilter('before', $request);
        if (is_null($response)) {
            $response = $this->dispatchToRoute($request);
        }
        $response = $this->prepareResponse($request, $response);
            if (!is_null($response)) {
                return $this->prepareResponse($response, $request);
            }
        }
        if ($this->runningUnitTests() && !$this['session']->isStarted()) {
            $this['session']->start();
        }
        return $this['router']->dispatch($this->prepareRequest($request));
    }
    public function terminate(SymfonyRequest $request, SymfonyResponse $response)
        });
    }
    public function handle(SymfonyRequest $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
    {
        try {
            $this->refreshRequest($request = Request::createFromBase($request));
            $this->boot();
            return $this->dispatch($request);
        } catch (\Exception $e) {
            if (!$catch || $this->runningUnitTests()) {
    public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
    {
        $this->checkRequestForArraySessions($request);
        if ($this->sessionConfigured()) {
            $session = $this->startSession($request);
            $request->setSession($session);
        }
        $response = $this->app->handle($request, $type, $catch);
        if ($this->sessionConfigured()) {
            $this->closeSession($session);
    public function __construct(HttpKernelInterface $app, CookieJar $cookies)
    {
        $this->app = $app;
        $this->cookies = $cookies;
    }
    public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
    {
        $response = $this->app->handle($request, $type, $catch);
        foreach ($this->cookies->getQueuedCookies() as $cookie) {
            $response->headers->setCookie($cookie);
    public function __construct(HttpKernelInterface $app, Encrypter $encrypter)
    {
        $this->app = $app;
        $this->encrypter = $encrypter;
    }
    public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
    {
        return $this->encrypt($this->app->handle($this->decrypt($request), $type, $catch));
    }
    protected function decrypt(Request $request)
    public function __construct(HttpKernelInterface $app, array $middlewares)
    {
        $this->app = $app;
        $this->middlewares = $middlewares;
    }
    public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
    {
        return $this->app->handle($request, $type, $catch);
    }
    public function terminate(Request $request, Response $response)
        if ($this->isBooted()) {
            $this->fireAppCallbacks(array($callback));
        }
    }
    public function run(SymfonyRequest $request = null)
    {
        $request = $request ?: $this['request'];
        $response = with($stack = $this->getStackedClient())->handle($request);
        $response->send();
        $stack->terminate($request, $response);
| Once we have the application, we can simply call the run method,
| which will execute the request and send the response back to
| the client's browser allowing them to enjoy the creative
| and wonderful application we have whipped up for them.
|
*/

$app->run();
 
Key Value
REDIRECT_REDIRECT_HTTPS on
REDIRECT_REDIRECT_SSL_TLS_SNI kupitehniku.ba
REDIRECT_REDIRECT_STATUS 200
REDIRECT_HTTPS on
REDIRECT_SSL_TLS_SNI kupitehniku.ba
REDIRECT_STATUS 200
HTTPS on
SSL_TLS_SNI kupitehniku.ba
HTTP_ACCEPT */*
HTTP_USER_AGENT claudebot
HTTP_HOST kupitehniku.ba
PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
SERVER_SIGNATURE <address>Apache/2.4.29 (Ubuntu) Server at kupitehniku.ba Port 443</address>
SERVER_SOFTWARE Apache/2.4.29 (Ubuntu)
SERVER_NAME kupitehniku.ba
SERVER_ADDR 159.69.223.146
SERVER_PORT 443
REMOTE_ADDR 3.230.128.106
DOCUMENT_ROOT /var/www/html
REQUEST_SCHEME https
CONTEXT_PREFIX
CONTEXT_DOCUMENT_ROOT /var/www/html
SERVER_ADMIN webmaster@localhost
SCRIPT_FILENAME /var/www/html/public/index.php
REMOTE_PORT 57838
REDIRECT_URL /public/kategorije/digitalne-kamere
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /kategorije/digitalne-kamere
SCRIPT_NAME /public/index.php
PATH_INFO /kategorije/digitalne-kamere
PATH_TRANSLATED redirect:/public/kategorije/digitalne-kamere/digitalne-kamere
PHP_SELF /public/index.php/kategorije/digitalne-kamere
REQUEST_TIME_FLOAT 1710826533.733
REQUEST_TIME 1710826533
empty
empty
empty
empty
empty
empty
0. Whoops\Handler\PrettyPageHandler