Deprecated (16384) : Since 5.0.0: Calling Table::get() with options array is deprecated. Use named arguments instead. /var/www/html/src/Controller/ItemsController.php, line: 847 You can disable all deprecation warnings by setting `Error.errorLevel` to `E_ALL & ~E_USER_DEPRECATED`. Adding `src/Controller/ItemsController.php` to `Error.ignoredDeprecationPaths` in your `config/app.php` config will mute deprecations from that file only. [in /var/www/html/vendor/cakephp/cakephp/src/Core/functions.php, line 377]
Deprecated (16384) : Since 5.0.0: SelectQuery::group() is deprecated. Use SelectQuery::groupBy() instead. /var/www/html/src/Model/Table/ItemsTable.php, line: 283 You can disable all deprecation warnings by setting `Error.errorLevel` to `E_ALL & ~E_USER_DEPRECATED`. Adding `src/Model/Table/ItemsTable.php` to `Error.ignoredDeprecationPaths` in your `config/app.php` config will mute deprecations from that file only. [in /var/www/html/vendor/cakephp/cakephp/src/Core/functions.php, line 377]
Deprecated (16384) : Since 5.0.0: Query::order() is deprecated. Use Query::orderBy() instead. /var/www/html/src/Model/Table/ItemsTable.php, line: 284 You can disable all deprecation warnings by setting `Error.errorLevel` to `E_ALL & ~E_USER_DEPRECATED`. Adding `src/Model/Table/ItemsTable.php` to `Error.ignoredDeprecationPaths` in your `config/app.php` config will mute deprecations from that file only. [in /var/www/html/vendor/cakephp/cakephp/src/Core/functions.php, line 377]
Warning (512) : Unable to emit headers. Headers sent in file=/var/www/html/vendor/cakephp/cakephp/src/Error/Renderer/HtmlErrorRenderer.php line=37 [in /var/www/html/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 65]
Warning (2) : Cannot modify header information - headers already sent by (output started at /var/www/html/vendor/cakephp/cakephp/src/Error/Renderer/HtmlErrorRenderer.php:37) [in /var/www/html/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 158]
Warning (2) : Cannot modify header information - headers already sent by (output started at /var/www/html/vendor/cakephp/cakephp/src/Error/Renderer/HtmlErrorRenderer.php:37) [in /var/www/html/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 191]
Error: Database Error

Database Error 📋

Cake\Database\Exception\QueryException

Error [default] SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #17 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bikebazar.Images.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Query: SELECT Items.id AS Items__id, Items.user_id AS Items__user_id, Items.brand_id AS Items__brand_id, Items.model_id AS Items__model_id, Items.district_id AS Items__district_id, Items.thana_id AS Items__thana_id, Items.is_new AS Items__is_new, Items.promo_image AS Items__promo_image, Items.alternate_phones AS Items__alternate_phones, Items.total_view AS Items__total_view, Items.status AS Items__status, Items.created AS Items__created, Items.published_at AS Items__published_at, Items.payment_status AS Items__payment_status, Items.is_featured AS Items__is_featured, Items.is_members_ad AS Items__is_members_ad, Images.id AS Images__id, Images.item_id AS Images__item_id, Images.path AS Images__path, Users.id AS Users__id, Users.district_id AS Users__district_id, Users.thana_id AS Users__thana_id, Users.phone AS Users__phone, Brands.id AS Brands__id, Brands.name AS Brands__name, Models.id AS Models__id, Models.brand_id AS Models__brand_id, Models.name AS Models__name, Models.name_en AS Models__name_en, Districts.id AS Districts__id, Districts.name AS Districts__name FROM items Items INNER JOIN images Images ON Items.id = Images.item_id INNER JOIN users Users ON Users.id = Items.user_id INNER JOIN brands Brands ON Brands.id = Items.brand_id INNER JOIN models Models ON Models.id = Items.model_id INNER JOIN districts Districts ON Districts.id = Items.district_id WHERE (Items.status = 1 AND Items.price <= 70000 AND Items.price >= 50000 AND Items.id != 19375) GROUP BY Items.id ORDER BY Items.published_at DESC, Items.created DESC LIMIT 4 OFFSET 0

If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in config/app.php.

SQL Query:

SELECT Items.id AS Items__id, Items.user_id AS Items__user_id, Items.brand_id AS Items__brand_id, Items.model_id AS Items__model_id, Items.district_id AS Items__district_id, Items.thana_id AS Items__thana_id, Items.is_new AS Items__is_new, Items.promo_image AS Items__promo_image, Items.alternate_phones AS Items__alternate_phones, Items.total_view AS Items__total_view, Items.status AS Items__status, Items.created AS Items__created, Items.published_at AS Items__published_at, Items.payment_status AS Items__payment_status, Items.is_featured AS Items__is_featured, Items.is_members_ad AS Items__is_members_ad, Images.id AS Images__id, Images.item_id AS Images__item_id, Images.path AS Images__path, Users.id AS Users__id, Users.district_id AS Users__district_id, Users.thana_id AS Users__thana_id, Users.phone AS Users__phone, Brands.id AS Brands__id, Brands.name AS Brands__name, Models.id AS Models__id, Models.brand_id AS Models__brand_id, Models.name AS Models__name, Models.name_en AS Models__name_en, Districts.id AS Districts__id, Districts.name AS Districts__name FROM items Items INNER JOIN images Images ON Items.id = Images.item_id INNER JOIN users Users ON Users.id = Items.user_id INNER JOIN brands Brands ON Brands.id = Items.brand_id INNER JOIN models Models ON Models.id = Items.model_id INNER JOIN districts Districts ON Districts.id = Items.district_id WHERE (Items.status = 1 AND Items.price <= 70000 AND Items.price >= 50000 AND Items.id != 19375) GROUP BY Items.id ORDER BY Items.published_at DESC, Items.created DESC LIMIT 4 OFFSET 0
CORE/src/Database/Driver.php at line 390 (edit)
            'driver' => $this,
            'params' => $params ?? $statement->getBoundParams(),
        ]);
        return new QueryException($loggedQuery, $exception);
    }
    /**
     * Prepares a sql statement to be executed.
Caused by SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #17 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bikebazar.Images.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by PDOException
CORE/src/Database/Statement/Statement.php at line 144 (edit)
     * @inheritDoc
     */
    public function execute(?array $params = null): bool
    {
        return $this->statement->execute($params);
    }
    /**
     * @inheritDoc

If you want to customize this error message, create templates/Error/pdo_error.php