An error occured during the script execution. The error is :SQL error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'aerogare-de-bruxelles.html') AS f FROM DELIASEO_KEY ps0 WHERE (ps0.KEY_IDENTIFIE' at line 1 on query :
SELECT ps0.KEY_TYPE AS "this.type", ps0.KEY_VALUE AS "this.value", ps0.SITE AS "this.site", ps0.KEY_IDENTIFIER AS "this.identifier", ps0.TITLE AS "this.title", ps0.KEYWORDS AS "this.keywords", ps0.DESCRIPTION AS "this.description", FIELD(ps0.KEY_IDENTIFIER, 'delia-CMS', 'index', 'article_id-1908', 'topic_id-175', 'le-tunnel-%C3%82%C2%AB-diabolo-%C3%82%C2%BB-sous-l'aerogare-de-bruxelles.html') AS f FROM DELIASEO_KEY ps0 WHERE (ps0.KEY_IDENTIFIER IN('delia-CMS', 'index', 'article_id-1908', 'topic_id-175', 'le-tunnel-%C3%82%C2%AB-diabolo-%C3%82%C2%BB-sous-l\'aerogare-de-bruxelles.html')) AND (ps0.SITE = '0') ORDER BY f asc
at line
996 on file /home/sites/fntp/revue-travaux.fr2/web/pelias/package/core/orm/sql/collection.php
Here is the error source code :Ligne 989 :
Ligne 990 : // Debug
Ligne 991 : if ($showSql)
Ligne 992 : {
Ligne 993 : echo "<p>[[$select]]</p>";
Ligne 994 : }
Ligne 995 :
Ligne 996 : $this->results = PsContext::getConnection($this->_moduleName)->getAll((string) $select);
Ligne 997 : $this->totalResults = count($this->results);
Ligne 998 : $this->isExecuted = true;
Ligne 999 :
Ligne 1000 : return ($this);
Ligne 1001 : }
Ligne 1002 :
Ligne 1003 : /**
Debug backtrace :
Function : include()
File : /home/sites/fntp/revue-travaux.fr2/web/index.php
Line : 10
Function : findTemplate()
File : /home/sites/fntp/revue-travaux.fr2/web/pelias/root/index.php
Line : 119
Method : PsCollectionSql->rewind()
File : /home/sites/fntp/revue-travaux.fr2/web/pelias/root/index.php
Line : 196
Method : PsCollectionSql->getItems()
File : /home/sites/fntp/revue-travaux.fr2/web/pelias/package/core/orm/sql/collection.php
Line : 1129
Method : PsDatabase->getAll()
File : /home/sites/fntp/revue-travaux.fr2/web/pelias/package/core/orm/sql/collection.php
Line : 996
Method : PsDatabasePdo->query()
File : /home/sites/fntp/revue-travaux.fr2/web/pelias/package/database/database.php
Line : 178
Function : trigger_error()
File : /home/sites/fntp/revue-travaux.fr2/web/pelias/package/database/adapters/pdo.php
Line : 90