I'm getting an error when I navigate to the order grid section of the magento 2.3.4 under Sales -> Orders in the admin panel. It appears to be referencing the wrong table because table 'databasename.prefix_sales_order' does exist but below the error is calling table'databasename.sales_order'. How would I fix this?

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'databasename.sales_order' doesn't exist, query was: SELECT COUNT(*) FROM `prefix_sales_order_grid` AS `main_table`  LEFT JOIN `sales_order` ON main_table.entity_id = sales_order.entity_id [] []

Did you try this command? bin/magento indexer:reindex

  • Yes I tried that and the issue still is not fixed,
    – Mathen
    Nov 2 '20 at 17:09

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.