PDOException

Description

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 ') order by c.id_contenu DESC LIMIT 0, 30' at line 1

Source File

/var/www/reg_libs/fo/protected/Common/Zend/Db/Adapter/Abstract.php (156)

0145:         // connect to the database if needed
0146:         $this->_connect();
0147: 
0148:         // is the $sql a Zend_Db_Select object?
0149:         if ($sql instanceof Zend_Db_Select) {
0150:             $sql = $sql->__toString();
0151:         }
0152: 
0153:         // prepare and execute the statement with profiling
0154:         $stmt = $this->prepare($sql);
0155:         $q = $this->_profiler->queryStart($sql);
0156: $stmt->execute((array) $bind);
0157: $this->_profiler->queryEnd($q); 0158: //echo $sql; 0159: // return the results embedded in the prepared statement object 0160: $stmt->setFetchMode($this->_fetchMode); 0161: 0162: return $stmt; 0163: } 0164: 0165: 0166: /** 0167: * Leave autocommit mode and begin a transaction. 0168: *

Stack Trace

#0 /var/www/reg_libs/fo/protected/Common/Zend/Db/Adapter/Abstract.php(156): PDOStatement->execute(Array)
#1 /var/www/reg_libs/fo/protected/Common/Zend/Db/Adapter/Abstract.php(310): Zend_Db_Adapter_Abstract->query('SELECT   c.id_r...', NULL)
#2 /var/www/reg_libs/fo/protected/Common/Am_Form/contents.php(85): Zend_Db_Adapter_Abstract->fetchAll('SELECT   c.id_r...')
#3 /var/www/reg_libs/fo/protected/Portlets/story_home/StoryBlogHome.php(30): contents->listSummryContents(NULL, NULL)
#4 /var/www/reg_libs/framework/pradolite.php(3988): StoryBlogHome->onLoad(NULL)
#5 /var/www/reg_libs/framework/pradolite.php(3995): TControl->loadRecursive()
#6 /var/www/reg_libs/framework/pradolite.php(3995): TControl->loadRecursive()
#7 /var/www/reg_libs/framework/pradolite.php(3995): TControl->loadRecursive()
#8 /var/www/reg_libs/framework/pradolite.php(3995): TControl->loadRecursive()
#9 /var/www/reg_libs/framework/pradolite.php(3995): TControl->loadRecursive()
#10 /var/www/reg_libs/framework/pradolite.php(5962): TControl->loadRecursive()
#11 /var/www/reg_libs/framework/pradolite.php(5954): TPage->processNormalRequest(Object(THtmlWriter))
#12 /var/www/reg_libs/framework/pradolite.php(8042): TPage->run(Object(THtmlWriter))
#13 /var/www/reg_libs/framework/pradolite.php(8008): TPageService->runPage(Object(manager), Array)
#14 /var/www/reg_libs/framework/pradolite.php(8943): TPageService->run()
#15 /var/www/reg_libs/framework/pradolite.php(8558): TApplication->runService()
#16 /var/www/vhosts/joue-sur-erdre.44.regioland.com/httpdocs/index.php(41): TApplication->run()
#17 {main}
2010-03-13 18:55 Apache/2.0.52 (CentOS) PRADO/3.1.0