/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

17 votes330 views6 answers
Remove list from list python
Python
9 votes321 views2 answers
Pygame render text
Python
17 votes368 views3 answers
No module named 'rest_framework'
Python
8 votes337 views5 answers
Find common elements in two lists python
Python
1 vote350 views1 answer
Python sympy solve equation equal to 0
Python
4 votes367 views1 answer
How to delete every row in excel using openpyxl
Python
1 vote373 views1 answer
Write a table to CSV file python
Python
0 vote330 views1 answer
Make sns heatmap colorbar larger
Python
3 votes390 views2 answers
For loop python start at 1
Python
5 votes346 views2 answers
Forgot django admin password
Python