Hi i am getting this error after i filter the order by date on magento here is the screenshot: enter image description here

Actually, I recently added mailchimp extension & that is causing the problem with magento 1.9 is anyone aware of a solution?

  • Disable compilation in your site and clear cache and test. Apr 16, 2018 at 11:05
  • i did everything clear cache , disable compiler but still getting error when i click on sales order page. Apr 16, 2018 at 11:10
  • As per your screenshot it seems your compilation is on. Also can u disable raveinfosys delete order extention and test again? Apr 16, 2018 at 11:11
  • no i cant do that i need some other solutions Apr 16, 2018 at 11:24
  • Its for test. So you will get exact idea where the issue is. Apr 16, 2018 at 11:25

1 Answer 1


The query doesn't understand from which table the 'created_at' field in WHERE clause should be considered. Find out the area and add the corresponding table alias to it, like main_table.created_at.

Probably the mailchimp extension has overridden the orders grid block.

EDIT: Override your Sales order Grid Block 'Mage_Adminhtml_Block_Sales_Order_Grid' and modify the 'created_at' column to the following

$this->addColumn('created_at', array(
        'header' => Mage::helper('sales')->__('Purchased On'),
        'index' => 'created_at',
        'type' => 'datetime',
        'width' => '100px',
        'filter_index' => 'main_table.created_at'

Here we are adding a 'filter_index' to remove the ambiguous error.

  • yes its mailchimp extension but i dont know how to fix this query Apr 16, 2018 at 12:36
  • Please see the updated answer Apr 17, 2018 at 6:01
  • where is this file loacted? Apr 17, 2018 at 6:35
  • i have fixed the issue thanks for your help. Apr 17, 2018 at 6:42
  • @rehan ansari Great to know the issue is fixed :) Apr 17, 2018 at 6:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.