/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 vote127 views2 answers
Python json write utf 8
Python
0 vote155 views1 answer
Convert torch.nn.Embedding layer to numpy array
Python
2 votes125 views1 answer
Python get ip from hostname
Python
1 vote128 views1 answer
Python to mac executable
Python
1 vote140 views1 answer
Sum along axis python
Python
1 vote138 views1 answer
How to openn file dialog in tkinter
Python
0 vote160 views1 answer
The requested resource was not found on this server. django
Python
2 votes123 views3 answers
Python seaborn color map
Python
0 vote133 views1 answer
Heapsort python
Python
0 vote135 views1 answer
Qcombobox remove all items
Python