0

my error: sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 7 supplied.?

cursor.execute(f"SELECT player, invites FROM join WHERE server = {member.guild.id} AND spieler = {member.id}")
invites = cursor.fetchone() 

cursor.execute(f"SELECT leaves FROM invite_ge WHERE spieler = {invites[0]} AND invite = ?", (invites [1]))
  • `(invites [1])` should be `(invites [1],)` You need the comma to make it a tuple. – Barmar Dec 21 '22 at 21:05
  • Why are you using string formatting for any of the substitutions? You should use `cursor.execute` parameters for all substitutions. – Barmar Dec 21 '22 at 21:06

0 Answers0