psycopg2 TypeError: not all arguments converted during string formatting

Question

I'm trying execute a simple query, but getting this error no matter how I pass the parameters.

Here is the query (I'm using Trac db object to connect to a DB):

cursor.execute("""SELECT name FROM "%s".customer WHERE firm_id='%s'""" % (schema, each['id'])) 

schema and each['id'] both are simple strings

print("""SELECT name FROM "%s".customer WHERE firm_id='%s'""" % (schema, each['id'])) 

Result: SELECT name FROM "Planing".customer WHERE firm_id='135'

There is on error is a remove quote after firm_id=, but that way parameter is treated a an integer and ::text leads to the very same error.

Answer 1

In my case I didn't realize that you had to pass a tuple to cursor.execute. I had this:

cursor.execute(query, (id)) 

But I needed to pass a tuple instead

cursor.execute(query, (id,)) 

Answer 2

I got this same error and couldn't for the life of me work out how to fix, in the end it was my mistake because I didn't have enough parameters matching the number of elements in the tuple:

con.execute("INSERT INTO table VALUES (%s,%s,%s,%s,%s)",(1,2,3,4,5,6)) 

Note that I have 5 elements in the values to be inserted into the table, but 6 in the tuple.