Getting Error when trying to re-import sales data

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

Profile photo of Mall Staff 181800.00 $tone August 16, 2022
Public

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.

#1
Profile photo of Mall Staff 181800.00 $tone August 16, 2022
Public

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.

#3

Please login or Register to Submit Answer

Written By

Comments