/Python/Sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 7 supplied.

Sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 7 supplied.

#Whats happening is that instead of getting the 1 datatype its looking for, 
#SQLite thinks its getting multiple. To solve this pass the data through as a 
#tuple, not on its own
cursor.execute('INSERT INTO images VALUES(?)', (data)) #should be
cursor.execute('INSERT INTO images VALUES(?)', (data,))
#To demonstrate, print the lengths of both of the options:
len(data)
>>>7
len(data,)
>>>1

Similar codes

3 votes193 views2 answers
Catch error python
Python
39 votes176 views4 answers
Convert datetime to date python
Python
2 votes234 views2 answers
Sigmoid in python from scratch
Python
9 votes184 views4 answers
Python numpy array
Python
0 vote176 views1 answer
Python upgrade pip scipy
Python
1 vote184 views1 answer
Remove random character from a dictionary python
Python
1 vote202 views1 answer
How to create a save command in python
Python
3 votes199 views3 answers
Python thread with parameters
Python
1 vote182 views1 answer
Python make file path os
Python
2 votes171 views1 answer
How to strip quotation marks in python
Python