/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

0 vote107 views1 answer
Django today date in template
Python
7 votes111 views1 answer
Pd dataframe get column names
Python
0 vote120 views1 answer
How to copy items in list n times in list python
Python
0 vote114 views1 answer
Build the union of a list of RDDs
Python
0 vote116 views2 answers
Return returns string with brackets python
Python
0 vote109 views1 answer
Use an async check function for discord.py wait_for?
Python
16 votes134 views3 answers
Python clear file before writing
Python
55 votes114 views4 answers
List len python
Python
0 vote180 views1 answer
AssertionError: Relational field must provide a `queryset` argument, override `get_queryset`, or set read_only=`True`
Python
0 vote114 views1 answer
The current Numpy installation fails to pass a sanity check due to a bug in the windows runtime.
Python