9
I'm using Magento 1.9.1.0. 

There are three recent orders that do not appear in the Sales > Orders panel. Here is a screenshot of the most recent orders, please see the order numbers:

enter image description here

However, the 3 missing orders are present in the database:

enter image description here

The strange thing to me is that the orders also appear in the "last 5 orders" widget on the dashboard, and I can open them by clicking on them there. So Magento seems to be loading the data correctly, just not loading it into the orders grid.

Any help or suggestions is much appreciated.

  • 4
    That would mean the sales_flat_order_grid is not updated with the correct data. But without any errors or direct indications on what it could be it's impossible to help you – Sander Mangel Sep 8 '15 at 11:37
  • You are right. The orders are present in sales_flat_order but missing in sales_flat_order_grid. It's plenty of help, at least I know where to start looking. Thank you. – cedjud Sep 8 '15 at 12:55
  • Good luck! If you find any more details do post them if you need help – Sander Mangel Sep 8 '15 at 12:55
  • 1
    Hi i have the same problem, some orders are missing in the grid table because of an error "SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded;" did you find a way to recreate the grid table? – wutzebaer Oct 7 '15 at 11:21
  • 1
    Increase "innodb_lock_wait_timeout" may help fix issue "General error: 1205 Lock wait timeout exceeded". But in fact, there is a sql that is slow in your code, maybe because of an extension. My suggestion is to enable mysql log and find out what is slow and fix it. – Magebuzz Nov 3 '16 at 7:14
2

That would mean the sales_flat_order_grid is not updated with the correct data. But without any errors or direct indications on what it could be it's impossible to help you

| improve this answer | |

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.