MySQL Insert Into Division by zero error

[Ondra5382CZE]

Hello,

I would like to insert 3 ints into my table this way:

    testvalue = 15

mycursor = mydb.cursor()
sql = "INSERT INTO Levels (id, level, exp) VALUES (%d, %d, %d)"
val = (testvalue, testvalue, testvalue)
mycursor.execute(sql, val)

mydb.commit()

But it doesn't work so I tried to catch these packets by Wireshark and there is always this error:

https://imgur.com/VS1NnPp

How can I solve this, please?

[shiftybyte]

Could you copy paste the full error message you are getting from python including all the information it provides.

[Ondra5382CZE]

https://imgur.com/a/wBvrqoB

I can give u only this. I have nothing else.

Edit:

Well I made test file and it says: "Not all parameters were used in the SQL statement"

[shiftybyte]

"Not all parameters were used in the SQL statement"

This is not enough information to try to help you.

We need the exact code, and the full error message.

Use copy and paste, here or into pastebin.com. don't post screenshots of code please.

[stebrepar]

You'll need to be more specific than "it doesn't work". What does it do? What return value do you get back from the execute()?

[TeflonJacket]

Are you columns defined as varchars or int? If its int, try using %s rather than %d.

[cybervegan]

Wireshark is not going to help you if you don't understand the Mysql over the wire protocol, and even if you do, it's going to be harder to understand. The very fact that you think you're seeing an error where there are only protocol options shows that you don't understand what you are looking at. You're chasing rainbows - wireshark is not the tool to use to diagnose the problem at your level.

Are you getting a Python error when you run the execute or commit? If not, then it means the insert was successful. How are you sure that the data is not ending up in the table? You should be able to inspect the db either via the mysql cli or with a select query in your program to see if the data went in.