SQL how to fix error?

Question

Python

for guild in bot.guilds:
    for member in guild.members:
      if cursor.execute(f"SELECT id FROM users WHERE id = {member.id} AND server_id = {guild.id}").fetchone() is None:
        cursor.execute(f"INSERT INTO users VALUES ('{member}', {member.id},0,0,{guild.id})")
        

      else:
        pass
  connection.commit()

Throws an error: line 59, in on_ready
cursor.execute(f"INSERT INTO users VALUES ('{member}', '{member.id}',0,0,'{guild.id}')")
sqlite3.OperationalError : near "t": syntax error. How to solve the problem? This has not happened before

Answer 1

1. Do not generate queries through string formatting. Use placeholders. Starting with "the DB-API's parameter substitution"
2. If you need to insert a record if it doesn't exist, or do nothing if it does, read about INSERT ON CONFLICT DO NOTHING. Well, or about INSERT ON CONFLICT DO UPDATE, if you need to "insert a new one or update an existing one."