sqlite InterfaceError: Error binding parameter 0 - probably unsupported type

Question

I am using sqlite3 python modules and th following code returns the error

InterfaceError: Error binding parameter 0 - probably unsupported type

Note I have already tried with normal (non unicode) strings and the result is the same

# get database cursor
cur = dbConnection.cursor()

# create table for prices
cur.execute( """
   create table if not exists
   prices( time text,                     
           mid integer, 
           exid text,
           selid integer,                     
           priceone real,
           sometext text,
           price2 real,
           primary key (time, mid, exid, selid, priceone)
           foreign key (time, mid, exid, selid) references selection(time, mid, exid,selid) )""" )

#insert price
tuple  = (u'20120228153239788135', 104982590, 1, 4764315, 1.99, u'B', 0.07)
cur.execute( "insert into prices values (?,?,?,?,?,?,?)", tuple)

Your posted code works fine for me. A side note: try to avoid using built-in names as variable names. — mechanical_meat
– mechanical_meat, Commented Feb 28, 2012 at 21:50

rjbez · Accepted Answer · 2012-03-02 14:57:10Z

2

This code works fine for me.

However, have you changed your table schema at all? Because you add the

 create if not exists

it is likely you changed something but the DB (file) wasn't updated since you have this.

Also, you are passing in an int for exid even though the type is text. It will automatically convert it but still shouldn't do it.

answered Mar 2, 2012 at 14:57

rjbez

8102 gold badges12 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

sqlite InterfaceError: Error binding parameter 0 - probably unsupported type

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