PropelException

Description

[wrapped: Could not execute query [Native 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 'DESC LIMIT 10' at line 1] [User Info: SELECT opinion.OPINIONID, opinion.USERID, opinion.CREATEDATE, opinion.PAGE, opinion.SITEID, opinion.RATE, opinion.STATUS, opinion.CATEGORYID, opinion.OPINIONTEXT, opinion.CASEID FROM opinion WHERE !isnull(OpinionText) AND opinion.CASEID=122946 AND opinion.STATUS=1 ORDER BY DESC LIMIT 10]]

Source File

/home/alhedaya/public_html/pear/propel/util/BasePeer.php (458)

0447:             $stmt->setLimit($criteria->getLimit());
0448:             $stmt->setOffset($criteria->getOffset());
0449: 
0450:             self::populateStmtValues($stmt, $params, $dbMap);
0451: 
0452:             $rs = $stmt->executeQuery(ResultSet::FETCHMODE_NUM);
0453:             if ($criteria->isUseTransaction()) $con->commit();
0454:         } catch (Exception $e) {
0455:             if ($stmt) $stmt->close();
0456:             if ($criteria->isUseTransaction()) $con->rollback();
0457:             Propel::log($e->getMessage(), Propel::LOG_ERR);
0458: throw new PropelException($e);
0459: } 0460: 0461: return $rs; 0462: } 0463: 0464: /** 0465: * Applies any validators that were defined in the schema to the specified columns. 0466: * 0467: * @param string $dbName The name of the database 0468: * @param string $tableName The name of the table 0469: * @param array $columns Array of column names as key and column values as value. 0470: */

Stack Trace

#0 /home/alhedaya/public_html/protected/DataAccess/om/BaseOpinionPeer.php(317): BasePeer::doSelect(Object(Criteria), Object(MySQLConnection))
#1 /home/alhedaya/public_html/protected/DataAccess/om/BaseOpinionPeer.php(285): BaseOpinionPeer::doSelectRS(Object(Criteria), NULL)
#2 /home/alhedaya/public_html/protected/pages/ViewopinionList.php(52): BaseOpinionPeer::doSelect(Object(Criteria))
#3 /home/alhedaya/public_html/protected/pages/ViewopinionList.php(25): ViewopinionList->getDataGridRecord(0, 10)
#4 /home/alhedaya/public_html/protected/pages/ViewopinionList.php(18): ViewopinionList->LoadData()
#5 /home/alhedaya/public_html/framework/pradolite.php(4073): ViewopinionList->OnLoad(NULL)
#6 /home/alhedaya/public_html/framework/pradolite.php(6053): TControl->loadRecursive()
#7 /home/alhedaya/public_html/framework/pradolite.php(6045): TPage->processNormalRequest(Object(THtmlWriter))
#8 /home/alhedaya/public_html/framework/pradolite.php(8162): TPage->run(Object(THtmlWriter))
#9 /home/alhedaya/public_html/framework/pradolite.php(8128): TPageService->runPage(Object(ViewopinionList), Array)
#10 /home/alhedaya/public_html/framework/pradolite.php(9089): TPageService->run()
#11 /home/alhedaya/public_html/framework/pradolite.php(8704): TApplication->runService()
#12 /home/alhedaya/public_html/fa.php(132): TApplication->run()
#13 {main}
2017-12-12 11:51 Apache/2.2.31 (Unix) PHP/5.2.17 PRADO/3.1.2a