Ошибка can't concat list to bytes?

Question

[liss48]

async def check_in_database_add(user):
    try:
        connection = pymysql.connect(
            host=host,
            user=user,
            password=password,
            database=db_name,
        )

        with connection.cursor() as cursor:
            cursor.execute("SELECT id FROM main WHERE id = (%s)", (user[0].id))

        if cursor.fetchone() is None:
            with connection.cursor() as cursor:
                cursor.execute("INSERT INTO main (id, score, nickname, lvl) VALUES (%s, %s, %s, %s)", (user[0].id,
                                                                                                       0,
                                                                                                       user[0].first_name,
                                                                                                       1))
                connection.commit()

    except Exception as ex:
        print('Connection to database is refused...')
        print(ex)

user = await bot.api.users.get(message.from_id)

user имеет вид:
[UsersUserFull(элемент, элемент, элемент...)]

Вывод:

Connection to database is refused...
can't concat list to bytes

Смотрел некоторые ответы, говорят поменять %s на \"%s\" но не помогает.

Comments

[liss48]

Попробовал вставить свои значения там же где и создаю таблицу, все работает. А если я вставляю значения в другой функции с другим коннектом выходит та же ошибка, почему?

def create_main():
    try:
        connection = pymysql.connect(
            host=host,
            user=user,
            password=password,
            database=db_name,
        )

        with connection.cursor() as cursor:
            cursor.execute("""CREATE TABLE IF NOT EXISTS main (
                num INT AUTO_INCREMENT, 
                id INT, 
                score INT, 
                nickname VARCHAR(30), 
                lvl INT, 
                PRIMARY KEY (num))""")
            connection.commit()

        with connection.cursor() as cursor:
            cursor.execute("INSERT INTO main (id, score, nickname, lvl) VALUES (123456789, 0, 'Максим', 1)")
            connection.commit()

        print('Connection to database is successfully...')

    except Exception as ex:
        print('Connection to database is refused...')
        print(ex)

Answer 1

[liss48]

Нашел ошибку. Я зачем то коннектился к бд в начале каждой функции. А нужно только один раз в начале кода

Answer 2

[Vindicar]

Проверяй, что творится в user[0]. Какие значения, какие типы данных, и т.п.

Comments

[liss48]

user[0]:

can_access_closed=True deactivated=None first_name='Максим' hidden=None id=308159543 is_closed=False last_name='Лиссников' friend_status=None mutual=None online=None online_app=None online_info=None online_mobile=None photo_100=None photo_50=None screen_name=None sex=None trending=None verified=None about=None access_key=None activities=None activity=None bdate=None blacklisted=None blacklisted_by_me=None books=None can_be_invited_group=None can_call=None can_call_from_group=None can_post=None can_see_all_posts=None can_see_audio=None can_see_gifts=None can_see_wishes=None can_send_friend_request=None can_subscribe_podcasts=None can_subscribe_posts=None can_upload_doc=None can_write_private_message=None career=None city=None clips_count=None common_count=None contact_id=None contact_name=None counters=None country=None crop_photo=None descriptions=None domain=None education_form=None education_status=None email=None exports=None facebook=None facebook_name=None faculty=None faculty_name=None first_name_abl=None first_name_acc=None first_name_dat=None first_name_gen=None first_name_ins=None first_name_nom=None followers_count=None games=None graduation=None has_mobile=None has_photo=None has_unseen_stories=None hash=None home_phone=None home_town=None instagram=None interests=None is_favorite=None is_friend=None is_hidden_from_feed=None is_message_request=None is_no_index=None is_service=None is_subscribed_podcasts=None is_video_live_notifications_blocked=None language=None last_name_abl=None last_name_acc=None last_name_dat=None last_name_gen=None last_name_ins=None last_name_nom=None last_seen=None lists=None livejournal=None maiden_name=None military=None mobile_phone=None movies=None music=None nickname=None occupation=None owner_state=None personal=None photo=None photo_200=None photo_200_orig=None photo_400=None photo_400_orig=None photo_big=None photo_id=None photo_max=None photo_max_orig=None photo_max_size=None photo_medium=None photo_medium_rec=None photo_rec=None quotes=None relation=None relation_partner=None relatives=None schools=None service_description=None site=None skype=None status=None status_audio=None stories_archive_count=None test=None timezone=None tv=None twitter=None type=None universities=None university=None university_group_id=None university_name=None video_live=None video_live_count=None video_live_level=None wall_comments=None wall_default=None

[Vindicar]

liss48, так. хорошо. Тогда нужны подробности.
Добавь код в блок except, посмотрим, на какой строки появляется исключение.

import traceback
traceback.print_exc()