/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 votes249 views1 answer
Np append row
Python
0 vote238 views1 answer
Origin in CORS_ORIGIN_WHITELIST is missing scheme or netloc
Python
39 votes242 views3 answers
Convert str to datetime
Python
0 vote239 views1 answer
Pip install google cloud secret manager
Python
3 votes273 views1 answer
Python split first space
Python
0 vote250 views1 answer
How to get the memory location of a varible in python
Python
0 vote220 views1 answer
Python pil to greyscale
Python
0 vote269 views1 answer
AttributeError: module 'django.db.models' has no attribute 'ArrayField'
Python Django
3 votes253 views2 answers
Secondary y axis matplotlib
Python
4 votes227 views1 answer
Pandas fill empty
Python