Magento Forum

   
Integrity constraint violation: 1052 Column ‘status’ in where clause is ambiguous”
 
epvicky
Member
 
Total Posts:  59
Joined:  2011-07-28
 

Hi,

I’m getting this error while doing multiple filter search in admin on sales order page.

Error : a:5:{i:0;s:98:"SQLSTATE[23000]: Integrity constraint violation: 1052 Column ‘status’ in where clause is ambiguous";i:1;s:6139:"#0

can anyone help me to fix this error?

 
Magento Community Magento Community
Magento Community
Magento Community
 
epvicky
Member
 
Total Posts:  59
Joined:  2011-07-28
 

anyone help me in this?

 
Magento Community Magento Community
Magento Community
Magento Community
 
epvicky
Member
 
Total Posts:  59
Joined:  2011-07-28
 

hey, I found a solution for this error,

add a ‘filter_index’=>’main_table.status’, in grid.php file under protected function _prepareColumns() of

$this->addColumn(’status’, array(
‘header’ => Mage::helper(’sales’)->__(’Status’),
‘index’ => ‘status’,
‘type’ => ‘options’,
‘width’ => ‘70px’,
‘filter_index’=>’main_table.status’,
‘options’ => Mage::getSingleton(’sales/order_config’)->getStatuses(),
));

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top