Ошибка у телеграмм боте на pyTelegramBotApi. Как исправить?

Question

[porky]

Код:
import telebot
import sqlite3

bot = telebot.TeleBot('token')

@bot.message_handler(commands=['start'])
def sqlite3_simple_example_create_db():
id_user = message.from_user.id
con = sqlite3.connect('db.db')
cur = con.cursor()

cur.execute('INSERT INTO subscriptions VALUES (id_user")')

con.commit()

cur.close()
con.close()

bot.polling(none_stop=True)

Ошибка:
TypeError: sqlite3_simple_example_create_db() takes 0 positional arguments but 1 was given
"
Traceback (most recent call last):
File "bot.py", line 117, in
bot.polling(none_stop=True)

TypeError: sqlite3_simple_example_create_db() takes 0 positional arguments but 1 was given

Answer 1

[soremix]

def sqlite3_simple_example_create_db(message):

Comments

[porky]

Спасибо помогло. Но выскочила новая ошибка:

File "bot.py", line 13, in sqlite3_simple_example_create_db
cur.execute('INSERT INTO subscriptions VALUES (id_user")')
sqlite3.OperationalError: unrecognized token: "")"
"
Traceback (most recent call last):
File "bot.py", line 117, in
bot.polling(none_stop=True)

File "bot.py", line 13, in sqlite3_simple_example_create_db
cur.execute('INSERT INTO subscriptions VALUES (id_user")')
sqlite3.OperationalError: unrecognized token: "")"

[porky]

Помоги пожалуйста.

[soremix]

Help_please, не работаю с sqlite
Возможно, так

cur.execute("insert into subscriptions (id_user) values (?)",
            (id_user))

вместо
cur.execute('INSERT INTO subscriptions VALUES (id_user")')