Как решить ошибку в sqlite3. Operation error: near ( syntax error?

Question

[Forraz]

Код:

cur.execute(f"""CREATE TABLE IF NOT EXISTS {ds_name, }(
   user_num INTEGER PRIMARY KEY AUTOINCREMENT,
   user TEXT,
   wcount INTEGER,
   w1_id TEXT,
   w1_reason TEXT,
   w2_id TEXT,
   w2_reason TEXT,
   w3_id TEXT,
   w3_reason TEXT);
   """, (ds_name, ))
   conn.commit()

Полная ошибка:

Ignoring exception in command warn:
Traceback (most recent call last):
  File "/data/user/0/ru.iiec.pydroid3/files/arm-linux-androideabi/lib/python3.9/site-packages/disnake/ext/commands/core.py", line 172, in wrapped
    ret = await coro(*args, **kwargs)
  File "<string>", line 33, in warn
sqlite3.OperationalError: near "(": syntax error

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/data/user/0/ru.iiec.pydroid3/files/arm-linux-androideabi/lib/python3.9/site-packages/disnake/ext/commands/bot_base.py", line 578, in invoke
    await ctx.command.invoke(ctx)
  File "/data/user/0/ru.iiec.pydroid3/files/arm-linux-androideabi/lib/python3.9/site-packages/disnake/ext/commands/core.py", line 914, in invoke
    await injected(*ctx.args, **ctx.kwargs)
  File "/data/user/0/ru.iiec.pydroid3/files/arm-linux-androideabi/lib/python3.9/site-packages/disnake/ext/commands/core.py", line 181, in wrapped
    raise CommandInvokeError(exc) from exc
disnake.ext.commands.errors.CommandInvokeError: Command raised an exception: OperationalError: near "(": syntax error

Comments

[Османов Осман]

ты сначала покажи, какая строчка 33-я
upd: понял уже какая

Answer 1

[Османов Осман]

Уберите запятую здесь и второй аргумент execute:
...{ds_name, }...
Чтобы получилось вот так:

cur.execute(f"""CREATE TABLE IF NOT EXISTS {ds_name}(
   user_num INTEGER PRIMARY KEY AUTOINCREMENT,
   user TEXT,
   wcount INTEGER,
   w1_id TEXT,
   w1_reason TEXT,
   w2_id TEXT,
   w2_reason TEXT,
   w3_id TEXT,
   w3_reason TEXT);
   """)

Comments

[Forraz]

Возникает другая ошибка:

Ignoring exception in command warn:
Traceback (most recent call last):
  File "/data/user/0/ru.iiec.pydroid3/files/arm-linux-androideabi/lib/python3.9/site-packages/disnake/ext/commands/core.py", line 172, in wrapped
    ret = await coro(*args, **kwargs)
  File "<string>", line 45, in warn
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 2 supplied.
The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/data/user/0/ru.iiec.pydroid3/files/arm-linux-androideabi/lib/python3.9/site-packages/disnake/ext/commands/bot_base.py", line 578, in invoke
    await ctx.command.invoke(ctx)
  File "/data/user/0/ru.iiec.pydroid3/files/arm-linux-androideabi/lib/python3.9/site-packages/disnake/ext/commands/core.py", line 914, in invoke
    await injected(*ctx.args, **ctx.kwargs)
  File "/data/user/0/ru.iiec.pydroid3/files/arm-linux-androideabi/lib/python3.9/site-packages/disnake/ext/commands/core.py", line 181, in wrapped
    raise CommandInvokeError(exc) from exc
disnake.ext.commands.errors.CommandInvokeError: Command raised an exception: ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 2 supplied.

[Slava Rozhnev]

Forraz, Ask new question

[Forraz]

Slava Rozhnev, Oy, vi iz anglii? Nu ladno

[Османов Осман]

Forraz, это действительно другая ошибка. Создайте новый вопрос