Getting bad index key pattern error using MongoDB

Question

I am getting one error related to mongodb.Actually i have one collection whose datas are given below.

"_id" : ObjectId("55bd9b7adfa5d64c057de74f"),
 "username" : "admin",
 "emailid" : "*****************************",
 "password" : "adminuser",
 "image" : "images/Image0895.jpg",
 "firstname" : "subhrajyoti",
 "lastname" : "pradhan"

Here i want to keep the username document as unique.For that i wrote the commanddb.collectionname.createIndex( {"username":"admin"},{unique:true}).But it gave me the following error.

Error:

        "ok" : 0,
        "errmsg" : "bad index key pattern { username: \"admin\" }: Unknown index
 plugin 'admin'",
        "code" : 67

Please help me to resolve this error keep my one document as unique for this collection.

sheilak · Accepted Answer · 2015-08-02 14:18:45Z

5

For a unique index on username field you'd use this command:

db.collectionname.createIndex( {"username": 1},{unique:true})

The value of the username key must be 1 (indexed ascending) or -1 (indexed descending)

See MongoDB docs on db.collection.createIndex()

answered Aug 2, 2015 at 14:18

sheilak

5,8737 gold badges36 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

Getting bad index key pattern error using MongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related