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 'integration-formation.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', 'FR', 'recrutement', 'topic_id-260,260', '03-parcours-d'integration-formation.html') AS f FROM DELIASEO_KEY ps0 WHERE (ps0.KEY_IDENTIFIER IN('delia-CMS', 'FR', 'recrutement', 'topic_id-260,260', '03-parcours-d\'integration-formation.html')) AND (ps0.SITE = '0') ORDER BY f asc
at line
991 on file /home/sites/sia-conseil/sia-conseil.com3/web/pelias/package/core/orm/sql/collection.php
Here is the error source code :Ligne 984 :
Ligne 985 : // Debug
Ligne 986 : if ($showSql)
Ligne 987 : {
Ligne 988 : echo "<p>[[$select]]</p>";
Ligne 989 : }
Ligne 990 :
Ligne 991 : $this->results = PsContext::getConnection($this->_moduleName)->getAll((string) $select);
Ligne 992 : $this->totalResults = count($this->results);
Ligne 993 : $this->isExecuted = true;
Ligne 994 :
Ligne 995 : return ($this);
Ligne 996 : }
Ligne 997 :
Ligne 998 : /**
Debug backtrace :
Function : include()
File : /home/sites/sia-conseil/sia-conseil.com3/web/index.php
Line : 10
Function : findTemplate()
File : /home/sites/sia-conseil/sia-conseil.com3/web/pelias/root/index.php
Line : 119
Method : PsCollectionSql->rewind()
File : /home/sites/sia-conseil/sia-conseil.com3/web/pelias/root/index.php
Line : 196
Method : PsCollectionSql->getItems()
File : /home/sites/sia-conseil/sia-conseil.com3/web/pelias/package/core/orm/sql/collection.php
Line : 1124
Method : PsDatabase->getAll()
File : /home/sites/sia-conseil/sia-conseil.com3/web/pelias/package/core/orm/sql/collection.php
Line : 991
Method : PsDatabasePdo->query()
File : /home/sites/sia-conseil/sia-conseil.com3/web/pelias/package/database/database.php
Line : 178
Function : trigger_error()
File : /home/sites/sia-conseil/sia-conseil.com3/web/pelias/package/database/adapters/pdo.php
Line : 90