Propel/symfony：标准问题

发布于 2024-09-26 05:48:26 字数 1443 浏览 4 评论 0原文

我在一个方法中有这个查询：

public static function pincopalla(){

     $con = Propel::getConnection(SediI18nPeer::DATABASE_NAME);

     $sql = "select * from sedii18n where culture = :country
     UNION
     select * from sedii18n where culture <> :country";


     $stmt = $con->prepare($sql);

    $result = $stmt->execute(array(':country' => 'eu'));

    return $result;

}

当我调用该方法时，我得到下面的 symfony 错误，下面存在很困难的 cashgold_new.sedii18n..：

500 | Internal Server Error | PDOException
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cashgold_new.sedii18n'    doesn't exist
stack trace

* at ()
  in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfPropelPlugin/lib/vendor/propel/util/DebugPDOStatement.php line 99 ...
          96.     public function execute($input_parameters = null)
          97.     {
          98.         $debug    = $this->pdo->getDebugSnapshot();
          99.         $return    = parent::execute($input_parameters);
         100.         
         101.         $sql = $this->getExecutedQueryString();
         102.         $this->pdo->log($sql, null, __METHOD__, $debug);

为了调试它，我更改了 getConnection() 参数的类名，期望出现相同的错误，但是...错误不一样！...：

致命错误：类找不到“SediBlaBlaI18nPeer” /home/javier/Aptana_Studio_Workspace/cashgold/lib/model/SediI18nPeer.php 第 25 行

知道问题出在哪里吗？

哈维

原文

I have this query inside a method:

public static function pincopalla(){

     $con = Propel::getConnection(SediI18nPeer::DATABASE_NAME);

     $sql = "select * from sedii18n where culture = :country
     UNION
     select * from sedii18n where culture <> :country";


     $stmt = $con->prepare($sql);

    $result = $stmt->execute(array(':country' => 'eu'));

    return $result;

}

When i call the method i get the symfony error below tough cashgold_new.sedii18n exists..:

500 | Internal Server Error | PDOException
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cashgold_new.sedii18n'    doesn't exist
stack trace

* at ()
  in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfPropelPlugin/lib/vendor/propel/util/DebugPDOStatement.php line 99 ...
          96.     public function execute($input_parameters = null)
          97.     {
          98.         $debug    = $this->pdo->getDebugSnapshot();
          99.         $return    = parent::execute($input_parameters);
         100.         
         101.         $sql = $this->getExecutedQueryString();
         102.         $this->pdo->log($sql, null, __METHOD__, $debug);

To debug it i have changed the class name of the argument of getConnection(), expecting the same error, but...the error is not the same!..: