CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db.sales_flat_order’ doesn’t exist
We are trying to reimport sales but we are getting the error noted above without ability to proceed with Step 7 -- can you please advise. We checked and we do not have flat table enabled in the M1 database -- so not sure why its looking for it
3 answers
Hi there,
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db.sales_flat_order’ doesn’t exist
Please recheck as it seems that the core sales order table named ‘sales_flat_order’ does not exist in your M1 database yet.
Regards,
Mall.
Correct it doesn’t -- and would not -- hence the confusion
Hi there,
We checked and we do not have flat table enabled in the M1 database — so not sure why its looking for it
…
Correct it doesn’t — and would not — hence the confusio
That is a core table in the M1 database. To migrate the sales data section in M1, please consider reverting that table.
If you are working on a backup of your M1 database, please consider re-exporting the latest version of your M1 database.
Once done, you can continue with data migration in step #7 of our module.
Regards,
Mall.
