[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=106449 AND opinion.STATUS=1 ORDER BY DESC LIMIT 10]]
/home/alhedaya/public_html/protected/DataAccess/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: */
#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}