dongsheng4126335 2015-06-19 00:50
浏览 233

php mongo未捕获的异常'MongoDuplicateKeyException'E11000

I am trying to migrate data from mysql to mongo. It adds one record fine to mongo but then on the second record I am getting

Fatal error: Uncaught exception 'MongoDuplicateKeyException' with message 'localhost:27017: E11000 duplicate key error index: app.hospitals.$_id_ dup key: { : ObjectId('558365d7423467484bd63af3') }' 

Not sure what I am doing wrong

here is my code

<?php
//echo phpinfo();
$host = "localhost";
$user = "root";
$password = "root";
$database = "database";


// Create connection
$conn = new mysqli($host, $user, $password, $database);


$connection = new MongoClient();
$db = $connection->database;
$collection = $db->hospitals;



// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM hospitals";

if($result = $conn->query($sql)){

    $i=0;
    while($row = $result->fetch_assoc()) {
        foreach($row as $key=>$value){

            $collection->insert($row);
            unset($collection->_id);
        }
        if($i > 3) die;
        $i++;
    }

}

$conn->close();

?>
  • 写回答

2条回答 默认 最新

  • douyue9704 2015-06-19 18:21
    关注

    using

    $collection->save($row);
    

    instead of insert solved the issue. Not sure why though.

    评论

报告相同问题?

悬赏问题

  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗
  • ¥15 钢筋实图交点识别,机器视觉代码
  • ¥15 如何在Linux系统中,但是在window系统上idea里面可以正常运行?(相关搜索:jar包)
  • ¥50 400g qsfp 光模块iphy方案
  • ¥15 两块ADC0804用proteus仿真时,出现异常
  • ¥15 关于风控系统,如何去选择
  • ¥15 这款软件是什么?需要能满足我的需求
  • ¥15 SpringSecurityOauth2登陆前后request不一致