MongoDB "The dollar ($) prefixed field is not valid for storage."

Question

While storing the key which have Dollar($) prefixed key is throwing error as "The dollar ($) prefixed field is not valid for storage." in MongoDB.

I am using MongoDB version 4.2 and NodeJS MongonDB Driver 3.5.9.

Example Snippet

db.collection.updateOne({_id: 'ObjectId("618bb1ccd7b16e4232dcb4e8")'}, {$set: {'$name': 'Alex'}}, {upsert: true, checkKeys: false})

Charlie · Accepted Answer · 2022-01-11 05:07:22Z

4

mongodb 4.0 doesn't support top level field with dollar sign. You can upgrade to mongodb 5.0

https://docs.mongodb.com/v4.0/core/document/#field-names

answered Jan 11, 2022 at 5:07

Charlie

2,2933 gold badges23 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tom Slabbaert · Accepted Answer · 2022-01-07 08:36:58Z

1

You just flat out have a syntax error, from the update docs, the update document

Contains only update operator expressions.

In your case you want to be using $set, like so:

db.collection.updateOne(
  {_id: 'ObjectId("618bb1ccd7b16e4232dcb4e8")'},
  { $set: { name: 'Alex'} },
  {upsert: true, checkKeys: false}
)

answered Jan 7, 2022 at 8:36

Tom Slabbaert

22.5k10 gold badges34 silver badges45 bronze badges

3 Comments

Ravi Shah Over a year ago

I am already using $set, it was just I didn't mentioned in the description. I have updated the description.

Tom Slabbaert Over a year ago

So instead of "$name" write "name"?

Ravi Shah Over a year ago

Those keys comes on the fly. I don't have control on that.

iustin · Accepted Answer · 2022-01-07 07:15:57Z

0

maybe check in the mongodb file explorer if the object has a $ anywhere?

answered Jan 7, 2022 at 7:15

iustin

1

2 Comments

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Ravi Shah Over a year ago

Didn't get that

Collectives™ on Stack Overflow

MongoDB "The dollar ($) prefixed field is not valid for storage."

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related