Error during insert_one in database

Working with Data
,
1

I made a discord bot in python , now I am trying save my data on database instead of local files. I am trying to use insert_one in database but it show error . Its very basic code but dont know why this problem apper while all you tube , tutorial said its ok. My code is:

@client.command()
async def data(ctx, member:discord.Member):
    mydb=cluster["record"]
    mycol = mydb["data"]
    await ctx.send(f"checkpoint 1")
    member_id=str(member.id)
    await ctx.send(f"checkpoint 2")
    mydict = {  "_id": member_id, "name": "John", "gender": "M", "area": "US", "age": 33}
    await ctx.send(f"checkpoint 3")
    mycol.insert_one(mydict)
    await ctx.send(f"checkpoint 4")

at checkpoint 3 it works ok and print also but nextline it create error . What may be the reason? Any help will be appriciated.

2

Hello @Shubh_Singh

It would be helpful for others to read and respond to your question if you could apply the proper code formatting to your post.

You can find in Formatting code and log snippets in posts a detailed description from @Stennie_X on formatting code.

• Add triple backticks (```) before and after a snippet of code. This syntax (aka code fencing in GItHub-flavoured Markdown) will automatically detect language formatting 1 and generally be an improvement over a straight copy & paste.

• Log lines can be formatted better by prefixing with > (aka quoting). This will wrap long lines and provide some visual distinction from code blocks. The editing toolbar has a shortcut for toggling line quoting on the currently selected text: ” . You can also use the (```) formatting for log snippets, but quoting generally works better.

• Add spacing to break up long blocks of text and improve readability

Regards,
Michael

3

Without the error message you are getting, it is very hard to tell. Please post the exact error you are getting.

4

Thanks for you reply. It creates CommandInvokeError.
Also when I use command “find_one” it works nice when data available but when data not available in collection ( I mean different data is available not not matched with find_one) then it creates CommandInvokeError.

5

Please post screenshot of both situations.

and

6

Thank you sir for your concern, at present I resolved my problem.

7

Could you please share what was the root cause of your problem?

This would help others apply the same solution if the have a similar issues.

8

Yes… My ip address was connected but when i connect it as 0.0.0.0 then it started working

9

image
image818×68 1.56 KB

at present when I use count() function to count document in any collection then it works fine but showing message to use count_documents function but when I use count_documents instead of couny() it raise error… perhaps I dont know exact syntax of count_documants

10

If you want us to help you with that you will have to share the code so that we see how you use it. It will also be very helpful to see the exact error that is raised.

11

image

12

This code still uses count() rather than count_document().

And please

I strongly recommend you take the MongoDB University course M220P for python.

13

ok… do you know syntax for count_document()
I used like
cursor=user.count_document()

14

No, but I would start by looking at the documentation:

15

thanks… seems compatibility issue

16

Please elaborate so that others in the same situation knows how to resolve a similar problem.

17

While I await for your feedback on the compatibility issue you found, I went and look at the documentation I posted. It seems that you simply need to pass the empty query {} as the parameter to count_document() since this API does not have a default parameter. So now I

18

Sorry for late reply, I could not come online. I resolved issue by ignoring warning as:

import warnings
warnings.filterwarnings(“ignore”, category=DeprecationWarning)

I found this problem was very general and found solution when google.
At present my bot is running perfectly with MongoDb Atlas but when I connect it to repl.it to make it online 24/7 it connect but does not read data from MongoDb . I google but everywhere same process is explained which i did. links cant be wrong as it connect and work when i run it without repl.it. I used free version of MongoDb , since my data are in kbs and I have allowed upto 512MB hence it should work. Any idea how to resolve this issue?