TDbCommand failed to execute the query SQL "SELECT count(id) FROM figure WHERE is_duplicate = 0 AND is_deleted = 0 AND slug != '' AND (category = 'Ichiban Kuji Natsume's Book of Friends Nyanko Sensei and Ayakashi Amusement Park' OR classification LIKE '%Ichiban Kuji Natsume's Book of Friends Nyanko Sensei and Ayakashi Amusement Park%')": SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's Book of Friends Nyanko Sensei and Ayakashi Amusement Park' OR classification L' at line 1
${PradoFramework}/Data/TDbCommand.php (279)
0268: } else {
0269: $this->_statement = $this->getConnection()->getPdoInstance()->query($this->getText());
0270: }
0271: $result = $this->_statement->fetchColumn();
0272: $this->_statement->closeCursor();
0273: if (is_resource($result) && get_resource_type($result) === 'stream') {
0274: return stream_get_contents($result);
0275: } else {
0276: return $result;
0277: }
0278: } catch (Exception $e) {
0279: throw new TDbException('dbcommand_query_failed', $e->getMessage(), $this->getDebugStatementText());
0280: }
0281: }
0282:
0283: /**
0284: * Executes the SQL statement and returns the first column of the result.
0285: * This is a convenient method of {@link query} when only the first column of data is needed.
0286: * Note, the column returned will contain the first element in each row of result.
0287: * @throws TDbException execution failed
0288: * @return array the first column of the query result. Empty array if no result.
0289: * @since 3.1.2
0290: */
0291: public function queryColumn()
#0 ${DocumentRoot}/protected/pages/product.php(436): Prado\Data\TDbCommand->queryScalar()
#1 ${DocumentRoot}/protected/pages/product.php(64): product->getListProduct()
#2 ${DocumentRoot}/protected/pages/product.php(23): product->loadData()
#3 ${PradoFramework}/Web/UI/TControl.php(1375): product->onLoad(NULL)
#4 ${PradoFramework}/Web/UI/TPage.php(241): Prado\Web\UI\TControl->loadRecursive()
#5 ${PradoFramework}/Web/UI/TPage.php(221): Prado\Web\UI\TPage->processNormalRequest(Object(Prado\Web\UI\THtmlWriter))
#6 ${PradoFramework}/Web/Services/TPageService.php(547): Prado\Web\UI\TPage->run(Object(Prado\Web\UI\THtmlWriter))
#7 ${PradoFramework}/Web/Services/TPageService.php(465): Prado\Web\Services\TPageService->runPage(Object(product), Array)
#8 ${PradoFramework}/TApplication.php(1245): Prado\Web\Services\TPageService->run()
#9 ${PradoFramework}/TApplication.php(386): Prado\TApplication->runService()
#10 ${DocumentRoot}/index.php(23): Prado\TApplication->run()
#11 {main}