Magento

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?

anyone help me in this?

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(),
));