/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

1 vote138 views4 answers
How to input in a list in python
Python
7 votes157 views3 answers
Python isset
Python
1 vote140 views1 answer
How to make a bot say hello <username> when a user says hello in discord with python
Python
0 vote118 views1 answer
Mean first passage time markov chain python
Python
0 vote135 views1 answer
Sublim text python indentation error
Python
3 votes144 views1 answer
From _curses import * ModuleNotFoundError: No module named '_curses'
Python
1 vote121 views1 answer
Python turtle shooting game
Python
32 votes136 views6 answers
Add to list python
Python
19 votes122 views1 answer
Python turn of userwarning
Python
3 votes122 views1 answer
Python copy a dictionary to a new variable
Python