/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

4 votes163 views2 answers
Loginrequiredmixin django
Python Django
7 votes143 views2 answers
Pandas read_csv ignore unnamed columns
Python
0 vote158 views1 answer
No module named 'flask_jwt_extended'
Python Flask
0 vote82 views1 answer
Pandas summary
Python
0 vote132 views1 answer
Countplot for different classes in a column
Python
0 vote178 views1 answer
Django connect to a db on heroku
Python Django
0 vote132 views1 answer
MovieWriter stderr: ffmpeg: error while loading shared libraries: libopenh264.so.5: cannot open shared object file: No such file or directory
Python
0 vote148 views1 answer
Django rest framework encrypt passwors
Python Django
1 vote129 views1 answer
Why do we use graphs?
Python
7 votes129 views1 answer
Pip pickle
Python