字段列表中的列“id"在 YII 中不明确 [英] Column 'id' in field list is ambiguous in YII

问题描述

我是 YII 的新手.尝试在控制器中实现查询，以下是我从控制器中获取的代码.

I am new in YII. Trying to implement the query in controller, Below is my code which has taken from controller.

public function getCommentListByUser($user_id)
{
        $criteria = new CDbCriteria;
        $criteria->select = "username";
        $criteria->alias = "u";
            $criteria->condition = 'cmt.commented_userd_id  = '.$user_id;
            $criteria->join = 'JOIN tbl_taskcomment cmt ON  (cmt.commented_userd_id = u.id)';
            $criteria->order = 'cmt.id ASC';  
            $model = User::model()->findAll($criteria);  
            return $model;
}

当我运行页面时，出现以下错误，

when i ran the page, I got the following error,

CDbCommand 无法执行 SQL 语句:SQLSTATE[23000]:完整性约束违规:1052 字段列表中的列 'id' 不明确.执行的SQL语句是:SELECT id, username, email, createtime, lastvisit, superuser, status FROM tbl_users u JOIN tbl_taskcomment cmt ON (cmt.commented_userd_id = u.id)WHERE cmt.commented_userd_id = 1 ORDER BY cmt.id ASC

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in field list is ambiguous. The SQL statement executed was: SELECT id, username, email, createtime, lastvisit, superuser, status FROM tbl_users u JOIN tbl_taskcomment cmt ON (cmt.commented_userd_id = u.id) WHERE cmt.commented_userd_id = 1 ORDER BY cmt.id ASC

取而代之的是从 USER 表中获取用户名，它带有所有没有别名的列.我知道这个问题与别名有关.我在这个语法和代码上做错了什么.

Instead fetching username from USER table,it comes with all column with out alias name. I knew this issue related with alias name. What i done wrong on this syntax as well as code.

请多多指教

推荐答案

要么

更改:$criteria->select = "username" 改为 ==>$criteria->select = "u.username"

或

删除:$criteria->alias = "u" 并将 $criteria->select = "username" 改为 ==>$criteria->select = "t.username" 并将所有左连接别名 'u.field_name' 更改为 ==>'t.field_name'

这篇关于字段列表中的列“id"在 YII 中不明确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！