/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

2 votes273 views1 answer
How to rewrite minute in datetime python
Python
1 vote263 views1 answer
How to right click in pyautogui
Python
0 vote286 views1 answer
Ordered set
Python
0 vote305 views2 answers
Pandas weighted average groupby
Python
0 vote283 views2 answers
Selenium check if driver is open python
Python
0 vote302 views1 answer
Basic get method in class based view django
Python Django
0 vote239 views2 answers
Javascript parse url
Python
0 vote274 views1 answer
Pyqt5 line edit password input
Python
0 vote283 views1 answer
Is power of python recursion
Python
2 votes312 views1 answer
Urlpatterns += static(r'^static/(?P<path>.*)$', 'django.views.static.serve', {'document_root': settings.STATIC_ROOT})
Python Django