Hi,
I am getting this error while migration
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘m1.sales_order_aggregated_updated’ doesn’t exist. The SQL statement executed was: SELECT COUNT(*) FROM `sales_order_aggregated_updated` e WHERE (e.store_id IN (1,2,0) OR e.store_id IS NULL)
-
not able open step #7, this step throws this error
4 answers
Hi there,
Table ‘m1.sales_order_aggregated_updated’ doesn’t exist.
That is strange. The table named ‘sales_order_aggregated_updated’ is a default table in database structure of Magento core.
What is the version of your M1 database?
If your database hasn’t that data table, you could uncheck that data section in settings in step #7 of our migration tool.
Regards,
Mall.
If your database hasn’t that data table, you could uncheck that data section in settings in step #7 of our migration tool.
not able open step #7, this step throws this error
case ‘tax_order_aggregated_updated’:
$sql = “SELECT COUNT(*) FROM `{$tablePrefix}$tableName`”;
$total = Yii::app()->db1->createCommand($sql)->queryScalar();
break;
had to uncomment these in pub/ub-tool/protected/models/UBMigrate.php
case ‘sales_order_aggregated_updated’:
$sql = “SELECT COUNT(*) FROM `{$tablePrefix}sales_order_aggregated_updated` e WHERE (e.store_id IN ({$strStoreIds}) OR e.store_id IS NULL)”;
$total = Yii::app()->db1->createCommand($sql)->queryScalar();
break;
Since Magento 1.6.0.0 does not have these two tables
Hi there,
Since Magento 1.6.0.0 does not have these two tables
Please note that our module is compatible with M1.6.0.2 and later only. If possible, please consider to upgrade your M1 to a higher version to avoid unexpected pitfalls that might occur due to the old M1 version.
Also, to solve the issue you mentioned, you can do steps below to exclude the ‘sales_order_aggregated_updated’ data section:
+ Reset the data migration in step #7 by running the command:
php -f bin/ubdatamigration reset --step=7
+ Then open the PHP file at: pub/ub-tool/protected/controllers/Step7Controller.php
and find the code line:
'sales_order_aggregated_updated' => Yii::t('frontend', 'Sales Order Aggregated Updated'),
and replace it with:
//'sales_order_aggregated_updated' => Yii::t('frontend', 'Sales Order Aggregated Updated'),
+ Once done, back to the settings in Step #7 of our migration tool.
Regards,
Mall.