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. – Chirag Rajput Apr 16 '18 at 11:05
  • i did everything clear cache , disable compiler but still getting error when i click on sales order page. – rehan ansari Apr 16 '18 at 11:10
  • As per your screenshot it seems your compilation is on. Also can u disable raveinfosys delete order extention and test again? – Chirag Rajput Apr 16 '18 at 11:11
  • no i cant do that i need some other solutions – rehan ansari Apr 16 '18 at 11:24
  • Its for test. So you will get exact idea where the issue is. – Chirag Rajput Apr 16 '18 at 11:25

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 – rehan ansari Apr 16 '18 at 12:36
  • Please see the updated answer – Geethika Antony Apr 17 '18 at 6:01
  • where is this file loacted? – rehan ansari Apr 17 '18 at 6:35
  • i have fixed the issue thanks for your help. – rehan ansari Apr 17 '18 at 6:42
  • @rehan ansari Great to know the issue is fixed :) – Geethika Antony Apr 17 '18 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.