CCDB Error

CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-0' for key 'CATALOG_PRODUCT_OPTION_TITLE_OPTION_ID_STORE_ID'. The SQL statement executed was: INSERT INTO `catalog_product_option_title` (`option_id`, `store_id`) VALUES (:yp0, :yp1)

/var/www/vhosts/s18844961.onlinehome-server.info/httpdocs/pub/ub-tool/yii/db/CDbCommand.php(358)

346         {
347             if($this->_connection->enableProfiling)
348                 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute');
349
350             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
351             $message=$e->getMessage();
352             Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
353                 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
354
355             if(YII_DEBUG)
356                 $message.='. The SQL statement executed was: '.$this->getText().$par;
357
358             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
359                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
360         }
361     }
362
363     /**
364      * Executes the SQL statement and returns query result.
365      * This method is for executing an SQL query that returns result set.
366      * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative
367      * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
368      * them in this way can improve the performance. Note that if you pass parameters in this way,
369      * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
370      * Please also note that all values are treated as strings in this case, if you need them to be handled as
Stack Trace
#0
+  /var/www/vhosts/s18844961.onlinehome-server.info/httpdocs/pub/ub-tool/yii/db/ar/CActiveRecord.php(1080): CDbCommand->execute()
#1
+  /var/www/vhosts/s18844961.onlinehome-server.info/httpdocs/pub/ub-tool/yii/db/ar/CActiveRecord.php(809): CActiveRecord->insert(null)
#2
–  /var/www/vhosts/s18844961.onlinehome-server.info/httpdocs/pub/ub-tool/protected/controllers/MigrateController.php(1322): CActiveRecord->save()
1317                                                                     $option_title2->$key = $option_title->$key;
1318                                                                 }
1319                                                             }
1320                                                             $option_title2->store_id = $store_id;
1321
1322                                                             if (!$option_title2->save()) {
1323                                                                 $errors[] = get_class($option_title2).": ".MigrateSteps::getStringErrors($option_title2->getErrors());
1324                                                             }
1325                                                         }
1326                                                     }
1327                                                 }
#3
+  /var/www/vhosts/s18844961.onlinehome-server.info/httpdocs/pub/ub-tool/yii/web/actions/CInlineAction.php(49): MigrateController->actionStep5()
#4
+  /var/www/vhosts/s18844961.onlinehome-server.info/httpdocs/pub/ub-tool/yii/web/CController.php(308): CInlineAction->runWithParams(array())
#5
+  /var/www/vhosts/s18844961.onlinehome-server.info/httpdocs/pub/ub-tool/yii/web/CController.php(286): CController->runAction(CInlineAction)
#6
+  /var/www/vhosts/s18844961.onlinehome-server.info/httpdocs/pub/ub-tool/yii/web/CController.php(265): CController->runActionWithFilters(CInlineAction, array())
#7
+  /var/www/vhosts/s18844961.onlinehome-server.info/httpdocs/pub/ub-tool/yii/web/CWebApplication.php(282): CController->run("step5")
#8
+  /var/www/vhosts/s18844961.onlinehome-server.info/httpdocs/pub/ub-tool/yii/web/CWebApplication.php(141): CWebApplication->runController("migrate/step5")
#9
+  /var/www/vhosts/s18844961.onlinehome-server.info/httpdocs/pub/ub-tool/yii/base/CApplication.php(184): CWebApplication->processRequest()
#10
–  /var/www/vhosts/s18844961.onlinehome-server.info/httpdocs/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();