mysql.connector.errors.ProgrammingError: Wrong number of arguments during string formatting

Question

I'm opening a text file and trying to write it to an SQL database.

import mysql.connector
import sys
import mysql

f = open('norepeats.txt', 'r')

def sniffertodatabase(f):
for line in f:
    linestrip = line.strip()
    IP = linestrip
    cnx = mysql.connector.connect(user='', password='', host='localhost', database='snifferdb')
    cur = cnx.cursor()
    #print IP
    insert_stmt = (
    "INSERT INTO SNIFFERDBIPs (IP)"
    "VALUES (%s)"
    )
    data = ('IP')
    cur.execute(insert_stmt, data)

    #cur.execute("INSERT INTO SNIFFERDBIPs (IP)" "VALUES (%s), (IP)")
    #cur.execute("INSERT INTO test (num, data) VALUES (%s, %s)", (42, 'bar'))
    cnx.commit()
    cnx.close()
sniffertodatabase(f)

and the error I'm getting is:

Traceback (most recent call last):
File "snifferdatabase.py", line 26, in <module>
  sniffertodatabase(f)
File "snifferdatabase.py", line 19, in sniffertodatabase
  cur.execute(insert_stmt, data)
File "build/bdist.linux-x86_64/egg/mysql/connector/cursor.py", line 480, in execute
mysql.connector.errors.ProgrammingError: Wrong number of arguments during string formatting

How do I solve this error?

your data should be ('IP',); it's str now, but you need tuple — dazedconfused
– dazedconfused, Commented Nov 21, 2014 at 1:08
I didn't post as an answer, so that's ok; by the way, you're creating and closing a connection for every line in your file, you should do it only once, which would be better — dazedconfused
– dazedconfused, Commented Nov 21, 2014 at 1:42

user3885927 · Accepted Answer · 2014-11-21 01:38:14Z

6

You have data=('IP'). Even though you put it in brackets it is not treated as a tuple. See this:

>>> type(('IP'))
<type 'str'>
>>> type(('IP',))
<type 'tuple'>
>>>

So you need to change your data=('IP') to data=('IP',)

answered Nov 21, 2014 at 1:38

user3885927

3,5832 gold badges29 silver badges44 bronze badges

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

Comments

Cosmtar · Accepted Answer · 2017-03-12 02:30:55Z

0

You can also use a list instead of a tuple that way you can do

data = ['IP']

answered Mar 12, 2017 at 2:30

Cosmtar

5255 silver badges14 bronze badges

Collectives™ on Stack Overflow

mysql.connector.errors.ProgrammingError: Wrong number of arguments during string formatting

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related