PHP MongoDB - Modifying a Primary Key in a record

Question

I'm somewhat new to MongoDB and I'm trying to change a primary key on a record via PHP. When I try to do so, I get the following error:

PHP Fatal error: Uncaught exception 'MongoWriteConcernException' with message '12.34.56.78:27017: After applying the update to the document {_id: ObjectId('5b077638aaf909b2528b51fd') , ...}, the (immutable) field '_id' was found to have been altered to _id: ObjectId('58b5882c4658a3de67ce2907')'

The new id (58b5882c4658a3de67ce2907) has been confirmed as unique.

This is the PHP code that I'm using to attempt this change:

$contactsQuery_for_update = array('center' => 12345,'_id' => new 
MongoId('5b077638aaf909b2528b51fd'));   
$collection_contacts->update(
$contactsQuery_for_update,
[ '$set' => [ '_id' => new MongoId('58b5882c4658a3de67ce2907') ]]
);

Has anyone else been able to do this successfully? Any direction is appreciated. Thanks!

Why do you *want* to change the ID? What's the point? – ceejayoz May 25 '18 at 14:27 — ceejayoz, May 25 '18 at 14:27

score 1 · Answer 1 · answered May 25 '18 at 14:23

1

I think the error message answers your question by telling you it's immutable. i.e. it can't be changed.

I guess if you have good reason to change the field, you'd have to delete the old record, and insert a new one with your preferred id.

answered May 25 '18 at 14:23

Tim

8,036
2
36
52

Hi Tim, Thanks for the response! Thats kind of what I figured. I was hoping that there was a workaround. Do you know of an easy way to replicate a record while just changing the primary key? Thanks again! – user1683443 May 25 '18 at 14:42
@user1683443 https://stackoverflow.com/questions/11763384/duplicate-a-document-in-mongodb-using-a-new-id – ceejayoz May 25 '18 at 14:52
@ceejayoz Thanks!! – user1683443 May 25 '18 at 15:05
@user1683443 You're welcome! Glad that helped. – ceejayoz May 25 '18 at 15:18
@ceejayoz It did. I'll need to adapt it for PHP but I understand the concept. – user1683443 May 25 '18 at 15:24

PHP MongoDB - Modifying a Primary Key in a record

1 Answers1