Integrity constraint violation: 1052 Column "order_id" in where clause is ambiguous
来源:互联网 发布:海岩剧 知乎 编辑:程序博客网 时间:2024/05/20 00:50
当我们在编写自定义插件,在管理后台的Grid中需要加入order_id做为过滤条件时,会出现以下错误。
Integrity constraint violation: 1052 Column "order_id" in where clause is ambiguous
为解决这个问题,只需要添加一句话
$this->addColumn('order_id', array('header' => Mage::helper('couponcode')->__('Order Id'),'align' =>'left','index' => 'order_id','filter_index'=>'main_table.order_id', // 这个参数将会解决上述问题));
- Integrity constraint violation: 1052 Column "order_id" in where clause is ambiguous
- Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous
- Yii报错:SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in order clause is ambiguous
- Integrity constraint violation: 1052 Column 'id' in order clause is ambiguou
- Column 'id' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'Email' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column 'is_valid' in where clause is ambiguous
- Column 'id' in where clause is ambiguous
- Column ' ' in where clause is ambiguous
- column 'typeid' in where clause is ambiguous
- mysql Error:1052 Column 'xxx' in where clause is ambiguous
- 错误代码: 1052 Column 'sys_date' in where clause is ambiguous
- column in where clause is ambiguous MySQL异常
- 数据库异常:“Column 'CODE' in where clause is ambiguous”
- mysql Column 'dbvalue' in where clause is ambiguous解决方案
- Android SurfaceFlinger中的SharedClient -- 客户端(Surface)和服务端(Layer)之间的显示缓冲区管理
- Android SurfaceFlinger中的工作线程:threadLoop()
- Android SurfaceFlinger学习文档
- java基础面试总结1
- struts2文件下载完整版
- Integrity constraint violation: 1052 Column "order_id" in where clause is ambiguous
- u-boot 移植步骤详解
- 腾讯面试之软件测试
- Java ArrayList 操作一点需要注意的地方
- sns社会化分享,同步
- 蚀刻加工流程可管理性的设计
- 223.I can't be your friend and your flatterer too. 朋友不能阿谀奉承
- 读《阿里巴巴离职DBA 35岁总结的职业生涯》有感
- html框架集 js刷新页面方法大全