base table not found

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)

  1. Profile photo of vkulkarnivkulkarni 610.00 $tone July 30, 2019
    not able open step #7, this step throws this error

4 answers

Profile photo of Mall Staff 184060.00 $tone July 29, 2019
Public

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.
 

#1
Profile photo of vkulkarni 610.00 $tone July 30, 2019
Public

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

#2
Profile photo of vkulkarni 610.00 $tone July 30, 2019
Public

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

#3
Profile photo of Mall Staff 184060.00 $tone July 30, 2019
Public

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.

#4

Please login or Register to Submit Answer

Written By

Comments