/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 vote338 views1 answer
Hex to binary python3
Python
1 vote315 views1 answer
Python source code
Python
0 vote295 views1 answer
Number of unique pairs in columns pandas
Python
0 vote292 views1 answer
Get information about dataframe
Python
0 vote279 views1 answer
Multiplication of matrix in python
Python
7 votes320 views3 answers
Python selenium click element
Python
5 votes340 views4 answers
Discord.py find channel by id
Python
0 vote292 views1 answer
Huggingface default cache dir
Python
0 vote321 views2 answers
Django model remove duplicates
Python Django
1 vote269 views1 answer
Get the system boot time in python
Python