/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

11 votes254 views3 answers
How to print all elements of a dictionary in python
Python
2 votes268 views2 answers
Change the color of the button on hovering tkinter
Python
0 vote281 views1 answer
Django file upload this field is required
Python Django
0 vote277 views1 answer
How to read file again in python
Python
1 vote262 views1 answer
Python zeros to nan
Python
0 vote258 views1 answer
How to get ********** on python
Python
1 vote256 views1 answer
Google colab power level
Python
1 vote335 views1 answer
Flask send client to another web page
Python Flask
0 vote273 views1 answer
Python opendatasets
Python
3 votes235 views1 answer
Datetime.timedelta months
Python