Ошибка InterfaceError
Не понимаю, из-за чего обнаружена ошибка, помогите, пожалуйста! Я пытаюсь добавить каждого юзера, который пишет /start в базу sql, у которого есть 4 столбца user_id, user_name, user_surname, username, но вылазит такая ошибка, подскажите пожалуйста, что делать?
Моя ошибка
Output exceeds the size limit. Open the full output data in a text editor
---------------------------------------------------------------------------
InterfaceError Traceback (most recent call last)
e:\BOTS\Bot with db\bot.ipynb Cell 6' in <cell line: 1>()
----> 1 bot.polling(none_stop=True, interval=0)
File c:\Users\Максим\AppData\Local\Programs\Python\Python38\lib\site-packages\telebot\__init__.py:621, in TeleBot.polling(self, non_stop, skip_pending, interval, timeout, long_polling_timeout, logger_level, allowed_updates, none_stop)
618 self.__skip_updates()
620 if self.threaded:
--> 621 self.__threaded_polling(non_stop=non_stop, interval=interval, timeout=timeout, long_polling_timeout=long_polling_timeout,
622 logger_level=logger_level, allowed_updates=allowed_updates)
623 else:
624 self.__non_threaded_polling(non_stop=non_stop, interval=interval, timeout=timeout, long_polling_timeout=long_polling_timeout,
625 logger_level=logger_level, allowed_updates=allowed_updates)
File c:\Users\Максим\AppData\Local\Programs\Python\Python38\lib\site-packages\telebot\__init__.py:695, in TeleBot.__threaded_polling(self, non_stop, interval, timeout, long_polling_timeout, logger_level, allowed_updates)
693 polling_thread.clear_exceptions() #*
694 self.worker_pool.clear_exceptions() #*
--> 695 raise e
696 else:
697 polling_thread.clear_exceptions()
File c:\Users\Максим\AppData\Local\Programs\Python\Python38\lib\site-packages\telebot\__init__.py:651, in TeleBot.__threaded_polling(self, non_stop, interval, timeout, long_polling_timeout, logger_level, allowed_updates)
649 or_event.wait() # wait for polling thread finish, polling thread error or thread pool error
650 polling_thread.raise_exceptions()
--> 651 self.worker_pool.raise_exceptions()
...
---> 17 cursor.execute('INSERT INTO userofbot (user_id, user_name, user_surname, username) VALUES (?, ?, ?, ?)', (user_id, user_name, user_surname, username))
18 conn.commit()
19 bot.send_message(message.chat.id, 'Привет' +'!\n' + 'Ты добавлен в базу')
InterfaceError: Error binding parameter 0 - probably unsupported type.
Мой код:
@bot.message_handler(commands=['start'])
def start_message(message):
people_id = message.chat.id
us_id = message.from_user.id
us_name = message.from_user.first_name
us_sname = message.from_user.last_name
username = message.from_user.username
#db_table_val(user_id = us_id, user_name=us_name, user_surname=us_sname, username=username)
cursor.execute(f'SELECT user_id FROM userofbot WHERE user_id = {people_id}')
data = cursor.fetchone()
if data is None:
user_id = [message.chat.id]
user_name = message.from_user.first_name
user_surname = message.from_user.last_name
cursor.execute('INSERT INTO userofbot (user_id, user_name, user_surname, username) VALUES (?, ?, ?, ?)', (user_id, user_name, user_surname, username))
conn.commit()
bot.send_message(message.chat.id, 'Привет' +'!\n' + 'Ты добавлен в базу')
else:
pass