Warning (2) : Undefined array key "HTTP_ACCEPT_LANGUAGE" [in /var/www/vhosts/webmotion.it/subdomains/giringiro/src/Controller/AppController.php, line 338]
Warning (512) : Unable to emit headers. Headers sent in file=/var/www/vhosts/webmotion.it/subdomains/giringiro/vendor/cakephp/cakephp/src/Error/Renderer/HtmlErrorRenderer.php line=37 [in /var/www/vhosts/webmotion.it/subdomains/giringiro/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 65]
Warning (2) : Cannot modify header information - headers already sent by (output started at /var/www/vhosts/webmotion.it/subdomains/giringiro/vendor/cakephp/cakephp/src/Error/Renderer/HtmlErrorRenderer.php:37) [in /var/www/vhosts/webmotion.it/subdomains/giringiro/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 159]
Warning (2) : Cannot modify header information - headers already sent by (output started at /var/www/vhosts/webmotion.it/subdomains/giringiro/vendor/cakephp/cakephp/src/Error/Renderer/HtmlErrorRenderer.php:37) [in /var/www/vhosts/webmotion.it/subdomains/giringiro/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 192]
Error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'title' in order clause is ambiguous Query: SELECT TourZones.id AS TourZones__id, TourZones.title AS TourZones__title, TourZonesTranslation.title AS TourZonesTranslation__title, TourZonesTranslation.locale AS TourZonesTranslation__locale FROM tour_zones TourZones LEFT JOIN tour_zones_translations TourZonesTranslation ON (TourZonesTranslation.locale = 'en' AND TourZones.id = TourZonesTranslation.id) ORDER BY title ASC

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'title' in order clause is ambiguous 📋

Query: SELECT TourZones.id AS TourZones__id, TourZones.title AS TourZones__title, TourZonesTranslation.title AS TourZonesTranslation__title, TourZonesTranslation.locale AS TourZonesTranslation__locale FROM tour_zones TourZones LEFT JOIN tour_zones_translations TourZonesTranslation ON (TourZonesTranslation.locale = 'en' AND TourZones.id = TourZonesTranslation.id) ORDER BY title ASC Cake\Database\Exception\QueryException

Could this be caused by using Auto-Tables?

Some of the Table objects in your application were created by instantiating "Cake\ORM\Table" instead of any other specific subclass.

This could be the cause for this exception. Auto-Tables are created for you under the following circumstances:


Please try correcting the issue for the following table aliases:


CORE/src/Database/Driver.php at line 384 (edit)
            'driver' => $this,
            'params' => $params ?? $statement->getBoundParams(),
        ]);
        return new QueryException($loggedQuery$exception);
    }
    /**
     Prepares a sql statement to be executed.
Caused by SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'title' in order clause is ambiguous 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/error500.php