Prado\Exceptions\TDbException

Description

TDbCommand failed to execute the query SQL "SELECT * FROM `page` WHERE page_URL like '/themes/uploads/images/CP_Le PDC s'oppose fermement aux nouvelles mesures COVID annonc��es par le CE Mauro Poggia.pdf' LIMIT 1": SQLSTATE[42000]: Syntax error or access violation: 1064 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 'oppose fermement aux nouvelles mesures COVID annonc��es par le CE Maur' at line 1

Source File

/home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/Data/TDbCommand.php (253)

0242:         try {
0243:             // Prado::trace('Query Row: '.$this->getDebugStatementText(), 'Prado\Data');
0244:             if ($this->_statement instanceof PDOStatement) {
0245:                 $this->_statement->execute();
0246:             } else {
0247:                 $this->_statement = $this->getConnection()->getPdoInstance()->query($this->getText());
0248:             }
0249:             $result = $this->_statement->fetch($fetchAssociative ? PDO::FETCH_ASSOC : PDO::FETCH_NUM);
0250:             $this->_statement->closeCursor();
0251:             return $result;
0252:         } catch (Exception $e) {
0253: throw new TDbException('dbcommand_query_failed', $e->getMessage(), $this->getDebugStatementText());
0254: } 0255: } 0256: 0257: /** 0258: * Executes the SQL statement and returns the value of the first column in the first row of data. 0259: * This is a convenient method of {@link query} when only a single scalar 0260: * value is needed (e.g. obtaining the count of the records). 0261: * @throws TDbException execution failed 0262: * @return mixed the value of the first column in the first row of the query result. False is returned if there is no value. 0263: */ 0264: public function queryScalar() 0265: {

Stack Trace

#0 /home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/Data/DataGateway/TDataGatewayCommand.php(117): Prado\Data\TDbCommand->queryRow()
#1 /home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/Data/ActiveRecord/TActiveRecordGateway.php(261): Prado\Data\DataGateway\TDataGatewayCommand->find(Object(Prado\Data\ActiveRecord\TActiveRecordCriteria))
#2 /home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/Data/ActiveRecord/TActiveRecord.php(594): Prado\Data\ActiveRecord\TActiveRecordGateway->findRecordsByCriteria(Object(PageRecord), Object(Prado\Data\ActiveRecord\TActiveRecordCriteria))
#3 /home/pdcge/public_html/protected/Common/BasicPage.php(18): Prado\Data\ActiveRecord\TActiveRecord->find(Object(Prado\Data\ActiveRecord\TActiveRecordCriteria))
#4 /home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/Web/UI/TControl.php(1318): BasicPage->onInit(NULL)
#5 /home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/Web/UI/TCompositeControl.php(35): Prado\Web\UI\TControl->initRecursive(Object(Accueil))
#6 /home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/Web/UI/TTemplateControl.php(244): Prado\Web\UI\TCompositeControl->initRecursive(NULL)
#7 /home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/Web/UI/TPage.php(220): Prado\Web\UI\TTemplateControl->initRecursive()
#8 /home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/Web/UI/TPage.php(208): Prado\Web\UI\TPage->processNormalRequest(Object(Prado\Web\UI\THtmlWriter))
#9 /home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/Web/Services/TPageService.php(528): Prado\Web\UI\TPage->run(Object(Prado\Web\UI\THtmlWriter))
#10 /home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/Web/Services/TPageService.php(465): Prado\Web\Services\TPageService->runPage(Object(Accueil), Array)
#11 /home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/TApplication.php(1190): Prado\Web\Services\TPageService->run()
#12 /home/pdcge/public_html/protected/vendor/pradosoft/prado/framework/TApplication.php(382): Prado\TApplication->runService()
#13 /home/pdcge/public_html/index.php(216): Prado\TApplication->run()
#14 {main}
2021-09-27 23:06 Apache PRADO/4.0.1