CDbException

CDbCommand не удалось исполнить SQL-запрос: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "all"
LINE 1: SELECT * FROM "news" "t" WHERE news_id='all' AND news_t_id='...
^. The SQL statement executed was: SELECT * FROM "news" "t" WHERE news_id='all' AND news_t_id='1' LIMIT 1

/home/zakonbase/zakonbase.ru/yii/yiilite.php(8683)

8671             return $result;
8672         }
8673         catch(Exception $e)
8674         {
8675             if($this->_connection->enableProfiling)
8676                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
8677             $errorInfo = $e instanceof PDOException ? $e->errorInfo : null;
8678             $message = $e->getMessage();
8679             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
8680                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
8681             if(YII_DEBUG)
8682                 $message .= '. The SQL statement executed was: '.$this->getText().$par;
8683             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
8684                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
8685         }
8686     }
8687     public function buildQuery($query)
8688     {
8689         $sql=isset($query['distinct']) && $query['distinct'] ? 'SELECT DISTINCT' : 'SELECT';
8690         $sql.=' '.(isset($query['select']) ? $query['select'] : '*');
8691         if(isset($query['from']))
8692             $sql.="\nFROM ".$query['from'];
8693         else
8694             throw new CDbException(Yii::t('yii','The DB query must contain the "from" portion.'));
8695         if(isset($query['join']))

Stack Trace

#3
+
 /home/zakonbase/zakonbase.ru/protected/controllers/NewsController.php(13): CActiveRecord->find("news_id='all' AND news_t_id='1'")
08         $sNewsUrl = Yii::app()->getRequest()->getQuery('var2');
09 
10         $oNewsType = NewsType::model()->find('news_t_url=\'' . $sNewsTypeUrl . '\'');
11         $oNews = News::model()->find('news_url=\'' . $sNewsUrl . '\' AND news_t_id=\'' . $oNewsType->news_t_id . '\'');
12         if (!$oNews) {
13             $oNews = News::model()->find('news_id=\'' . $sNewsUrl . '\' AND news_t_id=\'' . $oNewsType->news_t_id . '\'');
14         }
15         $this->pageTitle = $oNews->news_title;
16         $oNews->news_count+=1;
17         $oNews->save();
18         $oNewsNext = News::model()->find('news_id > \'' . $oNews->news_id . '\' AND news_t_id=' . $oNewsType->news_t_id . ' ORDER BY news_id');
#11
+
 /home/zakonbase/zakonbase.ru/www/index.php(19): CApplication->run()
14 //}
15 
16 defined('YII_TRACE_LEVEL') or define('YII_TRACE_LEVEL', 3);
17 
18 require_once($yii);
19 Yii::createWebApplication($config)->run();
2024-03-19 10:14:51 nginx/1.14.0 Yii Framework/1.1.10