Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous

[shikharmagento]

Hello Experts,

Magento Version: 1.8.1

While I check my orders in admin panel at Sales>Orders, I filter orders by status as 'Pending'. Right after that I got error as per below screenshot:

The admin panel is working fine except Sales>Order

Please help and suggest.

[Sunil Patel]

Hello @shikharmagento 

Please share the image via an online tool, i can not able to see your screenshot.

[Vimal Kumar]

Hi @shikharmagento 

Are you using any custom code to show any additional grid column?

Status is the keyword of sql. 

Make sure that you have used status in quote 

`status` = 'pending'

or use with table name:

sales_flat_order.`status`

because there may be status column in many joined tables. 

instead of 

status='pending'

I hope it will help you!

[Sunil Patel]

Hello @shikharmagento 

as per the screenshot, you edit grid into a local folder

app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid.php file

rename that file check it. if you want then find status into that file and change to index of that column e.status or main_table.status, hope it will help you.