sqlite3. Ошибка sqlite3.ProgrammingError: Error binding parameter 1: type 'set' is not supported
Код:
@bot.event
async def on_ready():
print(f"{bot.user} готов к работе!")
for guild in bot.guilds:
for member in guild.members:
global db, sql, all_messages
db = sqlite3.connect('server.db')
sql = db.cursor()
if db:
print("База данных подключена!")
name = f"{guild.name}"
db.execute('CREATE TABLE IF NOT EXISTS {}(userid INT, messages INT)'.format(name))
db.commit()
all_messages = sql.execute('SELECT messages FROM {} WHERE userid == ?'.format(name),({member.id},)).fetchone()
print(all_messages)
Ошибка:
all_messages = sql.execute('SELECT messages FROM {} WHERE userid == ?'.format(name),
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.ProgrammingError: Error binding parameter 1: type 'set' is not supported