[Bug] 登录成功却报错

powersee commented 1 year ago

Verify steps

[X] Tracker 我已经在 Issue Tracker 中找过我要提出的问题
[X] Latest 我已经使用最新源码测试过，问题依旧存在
[X] Core 这是 QianDao 框架存在的问题，并非我所使用的 QianDao早期版本（如 20210628及之前版号等）或模板的特定问题
[X] Meaningful 我提交的不是无意义的催促更新或修复请求

QianDao Version

20230228

Bug on OS

Linux

Bug on Platform

Docker/Linux 64位

To Reproduce

我是在 docker 中运行的，在登录页面，输入账号密码登录后，会跳转到 xxxxxxxxx.com/login，然后页面上只显示

500: Internal Server Error

此时我只要把url 中的 login 去掉，就可以正常访问，会自动跳转到 xxxxxxxx.com/my/

Describe the Bug

登录成功却报错

QianDao config

No response

QianDao log

[E 230321 13:58:32 tornado.application web:1798] Uncaught exception POST /login (ipipipip)
    HTTPServerRequest(protocol='https', host='xxxxxxxxxxxxxxx.com', method='POST', uri='/login', version='HTTP/1.1', remote_ip='ipipipip')
    Traceback (most recent call last):
      File "/usr/lib/python3.11/site-packages/tornado/web.py", line 1713, in _execute
        result = await result
                 ^^^^^^^^^^^^
      File "/usr/src/app/web/handlers/login.py", line 76, in post
        user = await self.db.user.get(email=email, fields=('id', 'password', 'password_md5'), sql_session=sql_session)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
      File "/usr/src/app/db/user.py", line 187, in get
        result = await self._get(smtm, one_or_none=one_or_none, first=first, sql_session=sql_session)
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
      File "/usr/src/app/db/basedb.py", line 97, in _get
        result: Result = await sql_session.execute(stmt)
                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
      File "/usr/lib/python3.11/site-packages/sqlalchemy/ext/asyncio/session.py", line 214, in execute
        result = await greenlet_spawn(
                 ^^^^^^^^^^^^^^^^^^^^^
      File "/usr/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 128, in greenlet_spawn
        result = context.switch(value)
                 ^^^^^^^^^^^^^^^^^^^^^
      File "/usr/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1717, in execute
        result = compile_state_cls.orm_setup_cursor_result(
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
      File "/usr/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 349, in orm_setup_cursor_result
        return loading.instances(result, querycontext)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
      File "/usr/lib/python3.11/site-packages/sqlalchemy/orm/loading.py", line 169, in instances
        _prebuffered = list(chunks(None))
                       ^^^^^^^^^^^^^^^^^^
      File "/usr/lib/python3.11/site-packages/sqlalchemy/orm/loading.py", line 147, in chunks
        fetch = cursor._raw_all_rows()
                ^^^^^^^^^^^^^^^^^^^^^^
      File "/usr/lib/python3.11/site-packages/sqlalchemy/engine/result.py", line 393, in _raw_all_rows
        return [make_row(row) for row in rows]
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
      File "/usr/lib/python3.11/site-packages/sqlalchemy/engine/result.py", line 393, in <listcomp>
        return [make_row(row) for row in rows]
                ^^^^^^^^^^^^^
      File "/usr/lib/python3.11/site-packages/sqlalchemy/sql/sqltypes.py", line 993, in process
        value = bytes(value)
                ^^^^^^^^^^^^
    TypeError: string argument without an encoding
[E 230321 13:58:32 tornado.access web:2271] 500 POST /login (ipipipip) 54.65ms
[I 230321 13:59:14 tornado.access web:2271] 200 GET / (154.89.5.107) 16.33ms
[I 230321 14:02:14 tornado.access web:2271] 302 GET / (ipipipip) 8.49ms
[I 230321 14:02:14 tornado.access web:2271] 200 GET /my/

Expected behavior

希望登录后可以自动跳转到 /my/

Screenshots

No response

a76yyyy commented 1 year ago

重置一下密码试试