29. Illuminate\Database\QueryException
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php625
28. CategoryController indexAllProducts
<#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/­CategoryRepository.php453
17. TCApp\Repositories\CategoryRepository getProducts
…/­app/­controllers/­CategoryController.php95
16. CategoryController indexAllProducts
<#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 (42P18)

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[42P18]: Indeterminate datatype: 7 ERROR: could not determine data type of parameter $4 (SQL: select distinct "products".*, "brands"."name" as "brand", "brands"."slug" as "brand_slug", "brands"."image" as "brand_image", "product_categories"."name" as "category", "product_categories"."slug" as "category_slug", count(distinct product_features.feature_category_id) as features_count from "products" inner join "brands" on "products"."brand_id" = "brands"."id" inner join "product_categories" on "products"."category_id" = "product_categories"."id" left join "product_features" on "products"."id" = "product_features"."product_id" where "products"."deleted_at" is null and 0 = 1 and "products"."published" = and "brands"."published" = 1 and "product_categories"."published" = 1 and "product_categories"."deleted_at" is null group by "products"."id", "brands"."name", "brands"."slug", "brands"."image", "product_categories"."name", "product_categories"."slug" order by "price" asc limit 12 offset 0)" Stacktrace: #29 Illuminate\Database\QueryException in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625 #28 CategoryController:indexAllProducts 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/CategoryRepository.php:453 #17 TCApp\Repositories\CategoryRepository:getProducts in /var/www/html/app/controllers/CategoryController.php:95 #16 CategoryController:indexAllProducts 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[42P18]: Indeterminate datatype: 7 ERROR: could not determine data type of parameter $4 (SQL: select distinct "products".*, "brands"."name" as "brand", "brands"."slug" as "brand_slug", "brands"."image" as "brand_image", "product_categories"."name" as "category", "product_categories"."slug" as "category_slug", count(distinct product_features.feature_category_id) as features_count from "products" inner join "brands" on "products"."brand_id" = "brands"."id" inner join "product_categories" on "products"."category_id" = "product_categories"."id" left join "product_features" on "products"."id" = "product_features"."product_id" where "products"."deleted_at" is null and 0 = 1 and "products"."published" = and "brands"."published" = 1 and "product_categories"."published" = 1 and "product_categories"."deleted_at" is null group by "products"."id", "brands"."name", "brands"."slug", "brands"."image", "product_categories"."name", "product_categories"."slug" order by "price" asc limit 12 offset 0)

		}

		// 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[42P18]: Indeterminate datatype: 7 ERROR: could not determine data type of parameter $4
			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);
	}

            // append where filters
            if ($whereRequiredCount > 0) {
                $query->whereRaw($whereRaw['query'], $whereRaw['parameters']);
                $query->having(DB::raw('count(distinct product_features.feature_category_id)'), '=', $whereRequiredCount);
            }
        }
        // execute
        $data = $query->get();
        // convert to array
        $data = json_decode(json_encode($data), true);
    // all products from chosen category
    public function indexAllProducts($slug, $page = 1)
    {
        $this->data['special_promotions'] = 1;
        // get category data by url slug
        $this->data['category'] = $this->category->bySlug($slug, true);
        // get products
        $this->data['products'] = $this->category->getProducts($this->data['category']['childs'], $page);
        // pagination
        $url = URL::route('all-products', [$this->data['category']['slug']]);
<#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 www.kupitehniku.ba
REDIRECT_REDIRECT_STATUS 200
REDIRECT_HTTPS on
REDIRECT_SSL_TLS_SNI www.kupitehniku.ba
REDIRECT_STATUS 200
HTTPS on
SSL_TLS_SNI www.kupitehniku.ba
HTTP_ACCEPT */*
HTTP_USER_AGENT claudebot
HTTP_HOST www.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 www.kupitehniku.ba Port 443</address>
SERVER_SOFTWARE Apache/2.4.29 (Ubuntu)
SERVER_NAME www.kupitehniku.ba
SERVER_ADDR 159.69.223.146
SERVER_PORT 443
REMOTE_ADDR 3.236.111.234
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 48082
REDIRECT_URL /public/svi-aparati/digitalne-kamere
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /svi-aparati/digitalne-kamere
SCRIPT_NAME /public/index.php
PATH_INFO /svi-aparati/digitalne-kamere
PATH_TRANSLATED redirect:/public/svi-aparati/digitalne-kamere/digitalne-kamere
PHP_SELF /public/index.php/svi-aparati/digitalne-kamere
REQUEST_TIME_FLOAT 1710819001.714
REQUEST_TIME 1710819001
empty
empty
empty
empty
empty
empty
0. Whoops\Handler\PrettyPageHandler