Step 9 ERROR

Start your code here

CDbException
The table “{{catalog_product_entity_group_price}}” for active record class “Mage1CatalogProductEntityGroupPrice” cannot be found in the database.

/var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/db/ar/CActiveRecord.php(2385)

2373 
2374     /**
2375      * Constructor.
2376      * @param CActiveRecord $model the model instance
2377      * @throws CDbException if specified table for active record class cannot be found in the database
2378      */
2379     public function __construct($model)
2380     {
2381         $this->_modelClassName=get_class($model);
2382 
2383         $tableName=$model->tableName();
2384         if(($table=$model->getDbConnection()->getSchema()->getTable($tableName))===null)
2385             throw new CDbException(Yii::t('yii','The table "{table}" for active record class "{class}" cannot be found in the database.',
2386                 array('{class}'=>$this->_modelClassName,'{table}'=>$tableName)));
2387                 
2388         if(($modelPk=$model->primaryKey())!==null || $table->primaryKey===null)
2389         {
2390             $table->primaryKey=$modelPk;
2391             if(is_string($table->primaryKey) && isset($table->columns[$table->primaryKey]))
2392                 $table->columns[$table->primaryKey]->isPrimaryKey=true;
2393             elseif(is_array($table->primaryKey))
2394             {
2395                 foreach($table->primaryKey as $name)
2396                 {
2397                     if(isset($table->columns[$name]))

Stack Trace

#0

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/db/ar/CActiveRecord.php(411): CActiveRecordMetaData->__construct(Mage1CatalogProductEntityGroupPrice)
 

#1

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/db/ar/CActiveRecord.php(661): CActiveRecord->getMetaData()
 

#2

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/db/ar/CActiveRecord.php(1606): CActiveRecord->getTableSchema()
 

#3


 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/protected/views/migrate/step9.php(50): CActiveRecord->count(“entity_id IN (36,38,40,41,42,43,44,45,46,47,48,49,55,56,57,58,59…”)

45                                     } else if ($id == 'catalog_rule') {
46                                         $total = Mage1Catalogrule::model()->count();
47                                     } else if ($id == 'group_price') {
48                                         if ($str_customer_group_ids) {
49                                             $condition = "entity_id IN ({$str_product_ids}) AND customer_group_id IN ({$str_customer_group_ids}) AND website_id IN ($str_website_ids)";
50                                             $total = Mage1CatalogProductEntityGroupPrice::model()->count($condition);
51                                         } else {
52                                             $total = 0;
53                                         }
54                                         if ($total) {
55                                             $total .= ', All Product group prices will be convert to Product tier prices';

#4

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/web/CBaseController.php(126): require(“/var/www/virtual/magento2.pl/htdocs/pub/ub-tool/protected/views/…”)
 

#5

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/web/CBaseController.php(95): CBaseController->renderInternal(“/var/www/virtual/magento2.pl/htdocs/pub/ub-tool/protected/views/…”, array(“step” => MigrateStepsPeer, “objects” => array(“tax” => “Tax Rules, Tax Zones and Rates”, “catalog_rule” => “Catalog Rules”, “increment_ids” => “Update System Increment IDs (EAV Entity Store)”, “email_template_newsletter” => “Email Templates and Newsletter Data”, …)), true)
 

#6

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/web/CController.php(869): CBaseController->renderFile(“/var/www/virtual/magento2.pl/htdocs/pub/ub-tool/protected/views/…”, array(“step” => MigrateStepsPeer, “objects” => array(“tax” => “Tax Rules, Tax Zones and Rates”, “catalog_rule” => “Catalog Rules”, “increment_ids” => “Update System Increment IDs (EAV Entity Store)”, “email_template_newsletter” => “Email Templates and Newsletter Data”, …)), true)
 

#7

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/web/CController.php(782): CController->renderPartial(“step9”, array(“step” => MigrateStepsPeer, “objects” => array(“tax” => “Tax Rules, Tax Zones and Rates”, “catalog_rule” => “Catalog Rules”, “increment_ids” => “Update System Increment IDs (EAV Entity Store)”, “email_template_newsletter” => “Email Templates and Newsletter Data”, …)), true)
 

#8


 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/protected/controllers/MigrateController.php(4359): CController->render(“step9”, array(“step” => MigrateStepsPeer, “objects” => array(“tax” => “Tax Rules, Tax Zones and Rates”, “catalog_rule” => “Catalog Rules”, “increment_ids” => “Update System Increment IDs (EAV Entity Store)”, “email_template_newsletter” => “Email Templates and Newsletter Data”, …)))

4354                 if ($step->status == MigrateSteps::STATUS_DONE){
4355                     Yii::app()->user->setFlash('note', Yii::t('frontend', "This step was finished. If you want to update data of this step, the first you have to click to 'Reset' button."));
4356                 }
4357             }
4358 
4359             $this->render("step{$step->sorder}", array('step' => $step, 'objects' => $objects));
4360         }else{
4361             Yii::app()->user->setFlash('note', Yii::t('frontend', "The first you need to finish the %s.", array("%s" => ucfirst($result['back_step']))));
4362             $this->redirect(array($result['back_step']));
4363         }
4364     }

#9

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/web/actions/CInlineAction.php(49): MigrateController->actionStep9()
 

#10

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/web/CController.php(308): CInlineAction->runWithParams(array())
 

#11

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/web/CController.php(286): CController->runAction(CInlineAction)
 

#12

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/web/CController.php(265): CController->runActionWithFilters(CInlineAction, array())
 

#13

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/web/CWebApplication.php(282): CController->run(“step9”)
 

#14

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/web/CWebApplication.php(141): CWebApplication->runController(“migrate/step9”)
 

#15

+
 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/yii/base/CApplication.php(184): CWebApplication->processRequest()
 

#16


 /var/www/virtual/magento2.pl/htdocs/pub/ub-tool/index.php(13): CApplication->run()

08 // change the following paths if necessary
09 $yii=dirname(__FILE__).'/yii/yii.php';
10 $config=dirname(__FILE__).'/protected/config/main.php';
11 
12 require_once($yii);
13 Yii::createWebApplication($config)->run();

2 answers

Profile photo of Admin Staff -30640.00 $tone August 30, 2016
Public

Hi Joana, 
We need to have a closer look into your site. Please help to provide us admin and SSH credentials of your Magento 2 site (you can send via private message here or email info (at) ubertheme.com) 
Also kindly let us know the version of your Magento 1 site. 
Thanks,
An Nguyen

#1
Profile photo of Admin Staff -30640.00 $tone August 30, 2016
Public

Hi Joana,
As your M1 version 1.6 does not have group price, which led to the issue. Please try to Reset step 9, then uncheck the ‘Product Group Price’ option as indicated in this screenshot http://i.prntscr.com/562abaab6f464460bb6d2ecaf517733b.png and process migration as normal. 
Once done, please let us know how it goes then.
Sincerely,
An Nguyen

#2

Please login or Register to Submit Answer

Written By

Comments