search

KimigaiiWuyi / GenshinUID

支持OneBot(QQ)、OneBotV12、QQ频道、微信、KOOK（开黑啦）、Telegram（电报）、FeiShu（飞书）、DoDo、Villa（米游社大别野）、Discord的全功能HoshinoBot/NoneBot2/Koishi/yunzai/ZeroBot原神机器人插件
https://docs.sayu-bot.com
GNU General Public License v3.0
731 stars 102 forks source link

hoshino无法使用网页控制台 #369

Closed DYS763 closed 1 year ago

DYS763 commented 1 year ago

~`@RT}2I~(R 1JNP%Y7H3C

KimigaiiWuyi commented 1 year ago

image 咦，但这个模块确实存在，检查一下你对应目录下是否存在

DYS763 commented 1 year ago

经过排查确实是因为没有nb2.py文件，不清楚为什么拉取更新的时候没有下载。不过手动下载好nb2.py文件后启动没问题但网页依旧无法打开：

DYS763 commented 1 year ago

`VZQR3 BF%S{N})2 MX~J)4 IF@(PI`O2 886X@OAL~O%DJ

DYS763 commented 1 year ago

`VZQR3 BF%S{N})2 MX~J)4

KimigaiiWuyi commented 1 year ago

`VZQR3 BF%S{N})2 MX~J)4

你自己的服务器地址:9222/genshinuid进不去么

DYS763 commented 1 year ago

是的 W}}FO2 GEQB4YP7UN FFE{S P6R)~U}ZLQH 1ALFTZ31DDG

DYS763 commented 1 year ago

在前端无反应的同时后端会报错： 1BJ@C V G9UENW5GA9WS}TO

KimigaiiWuyi commented 1 year ago

提供一下python版本和使用pip list命令之后找到的fastapi-amis-admin版本 这两天看看能不能复现 周末一直在弄别的 周末一直在弄别的

DYS763 commented 1 year ago

python版本：3.8.6

DYS763 commented 1 year ago

Package Version

aiocache 0.11.1 aiocqhttp 1.2.5 aiodns 3.0.0 aiofiles 22.1.0 aiohttp 3.8.1 aiosignal 1.2.0 aiosqlite 0.17.0 aliyun-python-sdk-core 2.13.25 aliyun-python-sdk-core-v3 2.13.11 aliyun-python-sdk-kms 2.11.0 altgraph 0.17 anyio 3.5.0 appdirs 1.4.4 APScheduler 3.6.3 arrow 0.17.0 asgiref 3.5.2 asn1crypto 1.4.0 astroid 2.4.2 async-timeout 4.0.2 asyncio-dgram 2.1.2 attrs 20.3.0 backports.zoneinfo 0.2.1 bbcode 1.1.0 bcrypt 4.0.0 beautifulsoup4 4.11.1 blinker 1.4 cachelib 0.1.1 cachetools 4.1.1 cchardet 2.1.7 certifi 2020.6.20 cffi 1.14.1 cfgv 3.2.0 chardet 3.0.4 charset-normalizer 2.0.12 click 7.1.2 colorama 0.4.3 cos-python-sdk-v5 1.7.7 crcmod 1.7 cryptography 3.0 cycler 0.10.0 Cython 0.29.21 dicttoxml 1.7.4 distlib 0.3.1 Django 4.0.5 dnspython 2.2.1 email-validator 1.3.0 emoji 1.7.0 et-xmlfile 1.1.0 expiringdict 1.2.1 fastapi 0.85.0 fastapi_amis_admin 0.2.4 fastapi_user_auth 0.2.4 feedparser 6.0.2 ffmpeg 1.4 filelock 3.0.12 filetype 1.0.7 Flask 1.1.2 Flask-Session 0.3.2 Flask-SocketIO 4.3.1 Flask-SQLAlchemy 2.4.4 fonttools 4.33.3 frozenlist 1.3.0 future 0.18.2 fuzzywuzzy 0.18.0 gevent 20.6.2 gevent-websocket 0.10.1 gitdb 4.0.9 GitPython 3.1.27 google-api-core 1.22.0 google-auth 1.20.0 google-cloud-core 1.4.0 googleapis-common-protos 1.52.0 greenlet 0.4.16 h11 0.12.0 h2 4.0.0 hpack 4.0.0 httpcore 0.15.0 httpx 0.23.0 Hypercorn 0.11.2 hyperframe 6.0.0 identify 1.4.25 idna 2.10 image 1.5.33 imageio 2.12.0 importlib-metadata 1.7.0 importlib-resources 3.0.0 IPy 1.0 isort 5.7.0 itsdangerous 1.1.0 jieba 0.42.1 Jinja2 2.11.2 jmespath 0.10.0 joblib 1.1.0 kiwisolver 1.3.1 langid 1.1.6 lazy-object-proxy 1.4.3 loguru 0.5.3 logzero 1.6.3 lxml 4.9.1 Markdown 3.3.4 MarkupSafe 1.1.1 matplotlib 3.3.3 mccabe 0.6.1 mcstatus 9.0.4 msgpack 1.0.2 multidict 5.1.0 mysqlclient 2.0.1 Naked 0.1.31 ndg-httpsclient 0.5.1 nodeenv 1.4.0 nonebot 1.6.0 numpy 1.23.2 oauthlib 3.1.0 opencc-python-reimplemented 0.1.6 opencv-contrib-python 4.5.1.48 opencv-python 4.5.1.48 opencv-python-headless 4.1.2.30 openpyxl 3.0.10 oss2 2.5.0 packaging 20.4 pandas 1.2.0 paramiko 2.7.1 passlib 1.7.4 pathtools 0.1.2 peewee 3.14.0 pefile 2019.4.18 peony-twitter 2.1.2 Pillow 9.2.0 pip 22.3 pluggy 0.13.1 pre-commit 2.6.0 priority 1.3.0 protobuf 3.12.4 psutil 5.7.2 py 1.9.0 py7zr 0.9.1 pyasn1 0.4.8 pyasn1-modules 0.2.8 pycares 4.1.2 pycparser 2.20 pycryptodome 3.9.8 pydantic 1.10.2 pygtrie 2.4.2 PyInstaller 3.6 pylint 2.6.0 pymemcache 3.2.0 pymongo 3.11.0 pymssql 2.1.4 PyMySQL 0.10.0 PyNaCl 1.4.0 pyOpenSSL 19.1.0 pyotp 2.4.0 pyparsing 2.4.7 python-dateutil 2.8.1 python-dotenv 0.15.0 python-engineio 3.13.1 python-magic 0.4.25 python-magic-bin 0.4.14 python-memcached 1.59 python-multipart 0.0.5 python-socketio 4.6.0 python3-memcached 1.51 pytoml 0.1.21 pytz 2020.1 pywin32 228 pywin32-ctypes 0.2.0 PyYAML 5.3.1 qiniu 7.2.8 Quart 0.11.5 redis 3.5.3 requests 2.28.1 requests-cache 0.5.2 requests-oauthlib 1.3.0 rfc3986 1.4.0 rsa 4.6 scikit-learn 1.1.2 scipy 1.9.1 setuptools 49.2.1 sgmllib3k 1.0.0 Shapely 1.8.4 shellescape 3.8.1 six 1.15.0 smmap 5.0.0 sniffio 1.2.0 sogou-tr-free 0.0.11 some-package 0.1 sortedcontainers 2.3.0 soupsieve 2.1 SQLAlchemy 1.4.40 sqlalchemy_database 0.0.10 sqlalchemy2-stubs 0.0.2a27 sqlitedict 1.6.0 sqlmodel 0.0.8 sqlmodelx 0.0.3 sqlparse 0.4.2 starlette 0.20.4 texttable 1.6.2 threadpoolctl 3.1.0 tinydb 4.3.0 toml 0.10.1 tomlkit 0.7.0 tox 3.18.1 translate 3.5.0 TwitterAPI 2.6.3 typing_extensions 4.3.0 tzdata 2022.1 tzlocal 2.1 ujson 4.0.1 unrar 0.4 upyun 2.5.5 urllib3 1.25.10 uvicorn 0.13.4 virtualenv 20.0.29 watchdog 0.10.3 watchgod 0.7 websockets 8.1 Werkzeug 1.0.1 win32-setctime 1.0.3 winshell 0.6 WMI 1.5.1 wordcloud 1.8.2.2 wrapt 1.12.1 wsproto 1.0.0 XlsxWriter 3.0.2 xmltodict 0.12.0 yarl 1.6.3 zhconv 1.4.1 zipp 3.1.0 zope.event 4.4 zope.interface 5.1.0

DYS763 commented 1 year ago

fastapi-amis-admin 版本：0.2.4

KimigaiiWuyi commented 1 year ago

fastapi-amis-admin 版本：0.2.4

升级fastapi-amis-admin和fastapi_user_auth版本看看 pip install fastapi-amis-admin -U pip install fastapi_user_auth -U

DYS763 commented 1 year ago

2022-11-07 15:24:24,629 nonebot] INFO: Running on 0.0.0.0:9222 Running on http://0.0.0.0:9222 (CTRL + C to quit) [2022-11-07 15:24:24,629 nonebot] INFO: Scheduler started [2022-11-07 15:24:24,629 genshinuid] INFO: 检查遗留信息... [2022-11-07 15:24:28,406 nonebot] INFO: 尝试挂载WebConsole Traceback (most recent call last): File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\base.py", line 1900, in _execute_context self.dialect.do_execute( File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\default.py", line 732, in do_execute cursor.execute(statement, parameters) File "C:\Program Files\python\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 100, in execute self._adapt_connection._handle_exception(error) File "C:\Program Files\python\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 228, in _handleexception raise error File "C:\Program Files\python\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 82, in execute self.await(_cursor.execute(operation, parameters)) File "C:\Program Files\python\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 68, in await_only return current.driver.switch(awaitable) File "C:\Program Files\python\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 121, in greenlet_spawn value = await result File "C:\Program Files\python\lib\site-packages\aiosqlite\cursor.py", line 37, in execute await self._execute(self._cursor.execute, sql, parameters) File "C:\Program Files\python\lib\site-packages\aiosqlite\cursor.py", line 31, in _execute return await self._conn._execute(fn, *args, **kwargs) File "C:\Program Files\python\lib\site-packages\aiosqlite\core.py", line 129, in _execute return await future File "C:\Program Files\python\lib\site-packages\aiosqlite\core.py", line 102, in run result = function() sqlite3.OperationalError: no such column: auth_user.point

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

Traceback (most recent call last): File "C:\Program Files\python\lib\site-packages\quart\asgi.py", line 205, in call await self.app.startup() File "C:\Program Files\python\lib\site-packages\quart\app.py", line 2089, in startup await func() File "C:\HoshinoBot\hoshino\modules\GenshinUID\GenshinUID\genshinuid_webconsole__init__.py", line 37, in start_check await run_webconsole() File "C:\HoshinoBot\hoshino\modules\GenshinUID\GenshinUID\genshinuid_webconsole__init__.py", line 27, in run_webconsole await auth.create_role_user() File "C:\Program Files\python\lib\site-packages\fastapi_user_auth\auth\auth.py", line 228, in create_role_user user = await self.db.async_run_sync(self._create_role_user_sync, role_key) File "C:\Program Files\python\lib\site-packages\sqlalchemy_database\database.py", line 194, in run_sync return await self.session.run_sync(fn, *args, *kwargs) File "C:\Program Files\python\lib\site-packages\sqlalchemy\ext\asyncio\session.py", line 189, in run_sync return await greenlet_spawn(fn, self.sync_session, arg, kw) File "C:\Program Files\python\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 126, in greenlet_spawn result = context.throw(sys.exc_info()) File "C:\Program Files\python\lib\site-packages\fastapi_user_auth\auth\auth.py", line 211, in _create_role_user_sync user = session.scalar( File "C:\Program Files\python\lib\site-packages\sqlalchemy\orm\session.py", line 1742, in scalar return self.execute( File "C:\Program Files\python\lib\site-packages\sqlmodel\orm\session.py", line 101, in execute return super().execute( # type: ignore File "C:\Program Files\python\lib\site-packages\sqlalchemy\orm\session.py", line 1712, in execute result = conn._execute_20(statement, params or {}, execution_options) File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "C:\Program Files\python\lib\site-packages\sqlalchemy\sql\elements.py", line 333, in _execute_on_connection return connection._execute_clauseelement( File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\base.py", line 2124, in _handle_dbapiexception util.raise( File "C:\Program Files\python\lib\site-packages\sqlalchemy\util\compat.py", line 208, in raise_ raise exception File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\base.py", line 1900, in _execute_context self.dialect.do_execute( File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\default.py", line 732, in do_execute cursor.execute(statement, parameters) File "C:\Program Files\python\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 100, in execute self._adapt_connection._handle_exception(error) File "C:\Program Files\python\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 228, in _handleexception raise error File "C:\Program Files\python\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 82, in execute self.await(_cursor.execute(operation, parameters)) File "C:\Program Files\python\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 68, in await_only return current.driver.switch(awaitable) File "C:\Program Files\python\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 121, in greenlet_spawn value = await result File "C:\Program Files\python\lib\site-packages\aiosqlite\cursor.py", line 37, in execute await self._execute(self._cursor.execute, sql, parameters) File "C:\Program Files\python\lib\site-packages\aiosqlite\cursor.py", line 31, in _execute return await self._conn._execute(fn, args, kwargs) File "C:\Program Files\python\lib\site-packages\aiosqlite\core.py", line 129, in _execute return await future File "C:\Program Files\python\lib\site-packages\aiosqlite\core.py", line 102, in run result = function() sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: auth_user.point [SQL: SELECT auth_user.create_time, auth_user.email, auth_user.password, auth_user.username, auth_user.id, auth_user.is_active, auth_user.nickname, auth_user.avatar, auth_user.point, auth_user.phone, auth_user.parent_id FROM auth_user JOIN auth_user_roles ON auth_user_roles.user_id = auth_user.id WHERE auth_user_roles.role_id = ?] [parameters: (1,)] (Background on this error at: https://sqlalche.me/e/14/e3q8)

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "C:\HoshinoBot\run.py", line 8, in bot.run(use_reloader=False, loop=asyncio.get_event_loop()) File "C:\Program Files\python\lib\site-packages\nonebot__init.py", line 61, in run super().run(host=host, port=port, *args, *kwargs) File "C:\Program Files\python\lib\site-packages\aiocqhttp__init__.py", line 206, in run self._server_app.run(host=host, port=port, args, **kwargs) File "C:\Program Files\python\lib\site-packages\quart\app.py", line 1621, in run loop.run_until_complete(task) File "C:\Program Files\python\lib\asyncio\base_events.py", line 616, in run_until_complete return future.result() File "C:\Program Files\python\lib\site-packages\hypercorn\asyncio__init__.py", line 39, in serve await worker_serve(app, config, shutdown_trigger=shutdown_trigger) File "C:\Program Files\python\lib\site-packages\hypercorn\asyncio\run.py", line 66, in worker_serve raise exception File "C:\Program Files\python\lib\site-packages\hypercorn\asyncio\lifespan.py", line 30, in handle_lifespan await invoke_asgi(self.app, scope, self.asgi_receive, self.asgi_send) File "C:\Program Files\python\lib\site-packages\hypercorn\utils.py", line 239, in invoke_asgi await app(scope, receive, send) File "C:\Program Files\python\lib\site-packages\quart\app.py", line 2059, in call__ await self.asgi_app(scope, receive, send) File "C:\Program Files\python\lib\site-packages\quart\app.py", line 2082, in asgi_app await asgi_handler(receive, send) File "C:\Program Files\python\lib\site-packages\quart\asgi.py", line 207, in call await send({"type": "lifespan.startup.failed", "message": str(error)}) File "C:\Program Files\python\lib\site-packages\hypercorn\asyncio\lifespan.py", line 80, in asgi_send raise LifespanFailure("startup", message["message"]) hypercorn.utils.LifespanFailure: Lifespan failure in startup. '(sqlite3.OperationalError) no such column: auth_user.point [SQL: SELECT auth_user.create_time, auth_user.email, auth_user.password, auth_user.username, auth_user.id, auth_user.is_active, auth_user.nickname, auth_user.avatar, auth_user.point, auth_user.phone, auth_user.parent_id FROM auth_user JOIN auth_user_roles ON auth_user_roles.user_id = auth_user.id WHERE auth_user_roles.role_id = ?] [parameters: (1,)] (Background on this error at: https://sqlalche.me/e/14/e3q8)'

C:\HoshinoBot>pause 请按任意键继续. . .

KimigaiiWuyi commented 1 year ago

2022-11-07 15:24:24,629 nonebot] INFO: Running on 0.0.0.0:9222 Running on http://0.0.0.0:9222 (CTRL + C to quit) [2022-11-07 15:24:24,629 nonebot] INFO: Scheduler started [2022-11-07 15:24:24,629 genshinuid] INFO: 检查遗留信息... [2022-11-07 15:24:28,406 nonebot] INFO: 尝试挂载WebConsole Traceback (most recent call last): File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\base.py", line 1900, in _execute_context self.dialect.do_execute( File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\default.py", line 732, in do_execute cursor.execute(statement, parameters) File "C:\Program Files\python\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 100, in execute self._adapt_connection._handle_exception(error) File "C:\Program Files\python\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 228, in _handleexception raise error File "C:\Program Files\python\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 82, in execute self.await(_cursor.execute(operation, parameters)) File "C:\Program Files\python\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 68, in await_only return current.driver.switch(awaitable) File "C:\Program Files\python\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 121, in greenlet_spawn value = await result File "C:\Program Files\python\lib\site-packages\aiosqlite\cursor.py", line 37, in execute await self._execute(self._cursor.execute, sql, parameters) File "C:\Program Files\python\lib\site-packages\aiosqlite\cursor.py", line 31, in _execute return await self._conn._execute(fn, *args, **kwargs) File "C:\Program Files\python\lib\site-packages\aiosqlite\core.py", line 129, in _execute return await future File "C:\Program Files\python\lib\site-packages\aiosqlite\core.py", line 102, in run result = function() sqlite3.OperationalError: no such column: auth_user.point

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

Traceback (most recent call last): File "C:\Program Files\python\lib\site-packages\quart\asgi.py", line 205, in call await self.app.startup() File "C:\Program Files\python\lib\site-packages\quart\app.py", line 2089, in startup await func() File "C:\HoshinoBot\hoshino\modules\GenshinUID\GenshinUID\genshinuid_webconsoleinit.py", line 37, in start_check await run_webconsole() File "C:\HoshinoBot\hoshino\modules\GenshinUID\GenshinUID\genshinuid_webconsoleinit.py", line 27, in run_webconsole await auth.create_role_user() File "C:\Program Files\python\lib\site-packages\fastapi_user_auth\auth\auth.py", line 228, in create_role_user user = await self.db.async_run_sync(self._create_role_user_sync, role_key) File "C:\Program Files\python\lib\site-packages\sqlalchemy_database\database.py", line 194, in run_sync return await self.session.run_sync(fn, *args, *kwargs) File "C:\Program Files\python\lib\site-packages\sqlalchemy\ext\asyncio\session.py", line 189, in run_sync return await greenlet_spawn(fn, self.sync_session, arg, kw) File "C:\Program Files\python\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 126, in greenlet_spawn result = context.throw(sys.exc_info()) File "C:\Program Files\python\lib\site-packages\fastapi_user_auth\auth\auth.py", line 211, in _create_role_user_sync user = session.scalar( File "C:\Program Files\python\lib\site-packages\sqlalchemy\orm\session.py", line 1742, in scalar return self.execute( File "C:\Program Files\python\lib\site-packages\sqlmodel\orm\session.py", line 101, in execute return super().execute( # type: ignore File "C:\Program Files\python\lib\site-packages\sqlalchemy\orm\session.py", line 1712, in execute result = conn._execute_20(statement, params or {}, execution_options) File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "C:\Program Files\python\lib\site-packages\sqlalchemy\sql\elements.py", line 333, in _execute_on_connection return connection._execute_clauseelement( File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\base.py", line 2124, in _handle_dbapiexception util.raise( File "C:\Program Files\python\lib\site-packages\sqlalchemy\util\compat.py", line 208, in raise_ raise exception File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\base.py", line 1900, in _execute_context self.dialect.do_execute( File "C:\Program Files\python\lib\site-packages\sqlalchemy\engine\default.py", line 732, in do_execute cursor.execute(statement, parameters) File "C:\Program Files\python\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 100, in execute self._adapt_connection._handle_exception(error) File "C:\Program Files\python\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 228, in _handleexception raise error File "C:\Program Files\python\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 82, in execute self.await(_cursor.execute(operation, parameters)) File "C:\Program Files\python\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 68, in await_only return current.driver.switch(awaitable) File "C:\Program Files\python\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 121, in greenlet_spawn value = await result File "C:\Program Files\python\lib\site-packages\aiosqlite\cursor.py", line 37, in execute await self._execute(self._cursor.execute, sql, parameters) File "C:\Program Files\python\lib\site-packages\aiosqlite\cursor.py", line 31, in _execute return await self._conn._execute(fn, args, kwargs) File "C:\Program Files\python\lib\site-packages\aiosqlite\core.py", line 129, in _execute return await future File "C:\Program Files\python\lib\site-packages\aiosqlite\core.py", line 102, in run result = function() sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: auth_user.point [SQL: SELECT auth_user.create_time, auth_user.email, auth_user.password, auth_user.username, auth_user.id, auth_user.is_active, auth_user.nickname, auth_user.avatar, auth_user.point, auth_user.phone, auth_user.parent_id FROM auth_user JOIN auth_user_roles ON auth_user_roles.user_id = auth_user.id WHERE auth_user_roles.role_id = ?] [parameters: (1,)] (Background on this error at: https://sqlalche.me/e/14/e3q8)

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "C:\HoshinoBot\run.py", line 8, in bot.run(use_reloader=False, loop=asyncio.get_event_loop()) File "C:\Program Files\python\lib\site-packages\nonebotinit.py", line 61, in run super().run(host=host, port=port, *args, *kwargs) File "C:\Program Files\python\lib\site-packages\aiocqhttpinit.py", line 206, in run self._server_app.run(host=host, port=port, args, kwargs) File "C:\Program Files\python\lib\site-packages\quart\app.py", line 1621, in run loop.run_until_complete(task) File "C:\Program Files\python\lib\asyncio\base_events.py", line 616, in run_until_complete return future.result() File "C:\Program Files\python\lib\site-packages\hypercorn\asyncioinit.py", line 39, in serve await worker_serve(app, config, shutdown_trigger=shutdown_trigger) File "C:\Program Files\python\lib\site-packages\hypercorn\asyncio\run.py", line 66, in worker_serve raise exception File "C:\Program Files\python\lib\site-packages\hypercorn\asyncio\lifespan.py", line 30, in handle_lifespan await invoke_asgi(self.app, scope, self.asgi_receive, self.asgi_send) File "C:\Program Files\python\lib\site-packages\hypercorn\utils.py", line 239, in invoke_asgi await app(scope, receive, send) File "C:\Program Files\python\lib\site-packages\quart\app.py", line 2059, in call await self.asgi_app(scope, receive, send) File "C:\Program Files\python\lib\site-packages\quart\app.py", line 2082, in asgi_app await asgi_handler(receive, send) File "C:\Program Files\python\lib\site-packages\quart\asgi.py", line 207, in call** await send({"type": "lifespan.startup.failed", "message": str(error)}) File "C:\Program Files\python\lib\site-packages\hypercorn\asyncio\lifespan.py", line 80, in asgi_send raise LifespanFailure("startup", message["message"]) hypercorn.utils.LifespanFailure: Lifespan failure in startup. '(sqlite3.OperationalError) no such column: auth_user.point [SQL: SELECT auth_user.create_time, auth_user.email, auth_user.password, auth_user.username, auth_user.id, auth_user.is_active, auth_user.nickname, auth_user.avatar, auth_user.point, auth_user.phone, auth_user.parent_id FROM auth_user JOIN auth_user_roles ON auth_user_roles.user_id = auth_user.id WHERE auth_user_roles.role_id = ?] [parameters: (1,)] (Background on this error at: https://sqlalche.me/e/14/e3q8)'

C:\HoshinoBot>pause 请按任意键继续. . .

我大概知道怎么回事了... 你可能需要手动删除数据库里的这几个表，注意删除前停止BOT，并进行数据库的备份 image

KimigaiiWuyi commented 1 year ago

image 这几个索引也应该删除掉

DYS763 commented 1 year ago

删除后又恢复到了之前的报错 [2022-11-07 15:55:11,760 genshinuid] INFO: 检查遗留信息... Exception ignored in: <function _ProactorBasePipeTransport.del at 0x00000295BD0568B0> Traceback (most recent call last): File "C:\Program Files\python\lib\asyncio\proactor_events.py", line 116, in del self.close() File "C:\Program Files\python\lib\asyncio\proactor_events.py", line 108, in close self._loop.call_soon(self._call_connection_lost, None) File "C:\Program Files\python\lib\asyncio\base_events.py", line 719, in call_soon self._check_closed() File "C:\Program Files\python\lib\asyncio\base_events.py", line 508, in _check_closed raise RuntimeError('Event loop is closed') RuntimeError: Event loop is closed [2022-11-07 15:55:15,558 nonebot] INFO: 尝试挂载WebConsole [2022-11-07 15:55:16,110 nonebot] INFO: WebConsole挂载成功：http://0.0.0.0:9222/genshinuid [2022-11-07 15:55:16,110] Running on http://0.0.0.0:9222 (CTRL + C to quit)

.............

[2022-11-07 15:56:02,175] 221.206.71.5:9077 GET /auth/form/login 1.1 500 0 3032219 [2022-11-07 15:56:02,175] 221.206.71.5:9082 GET /genshinuid 1.1 307 0 0 [2022-11-07 15:56:02,241] 221.206.71.5:9082 GET / 1.1 307 66 0 Error: 'default' is an invalid keyword argument for this function Traceback: Traceback (most recent call last): File "C:\Program Files\python\lib\site-packages\starlette\middleware\errors.py", line 162, in call await self.app(scope, receive, _send) File "C:\Program Files\python\lib\site-packages\starlette\middleware\exceptions.py", line 75, in call raise exc File "C:\Program Files\python\lib\site-packages\starlette\middleware\exceptions.py", line 64, in call await self.app(scope, receive, sender) File "C:\Program Files\python\lib\site-packages\fastapi\middleware\asyncexitstack.py", line 21, in call raise e File "C:\Program Files\python\lib\site-packages\fastapi\middleware\asyncexitstack.py", line 18, in call await self.app(scope, receive, send) File "C:\Program Files\python\lib\site-packages\starlette\routing.py", line 680, in call await route.handle(scope, receive, send) File "C:\Program Files\python\lib\site-packages\starlette\routing.py", line 275, in handle await self.app(scope, receive, send) File "C:\Program Files\python\lib\site-packages\starlette\routing.py", line 65, in app response = await func(request) File "C:\Program Files\python\lib\site-packages\fastapi\routing.py", line 221, in app solved_result = await solve_dependencies( File "C:\Program Files\python\lib\site-packages\fastapi\dependencies\utils.py", line 533, in solve_dependencies solved = await call(**sub_values) File "C:\Program Files\python\lib\site-packages\fastapi_amis_admin\admin\admin.py", line 911, in route return await self.page_parser(request, page) File "C:\Program Files\python\lib\site-packages\fastapi_amis_admin\admin\admin.py", line 869, in page_parser result = page.amis_html( File "C:\Program Files\python\lib\site-packages\fastapi_amis_admin\amis\components.py", line 129, in amis_html "AmisSchemaJson": self.amis_json(), File "C:\Program Files\python\lib\site-packages\fastapi_amis_admin\amis\types.py", line 23, in amis_json return self.json(exclude_none=True, by_alias=True) File "pydantic\main.py", line 505, in pydantic.main.BaseModel.json TypeError: 'default' is an invalid keyword argument for this function

[2022-11-07 15:56:02,401] 221.206.71.5:9082 GET /auth/form/login 1.1 500 0 0

KimigaiiWuyi commented 1 year ago

删除后又恢复到了之前的报错 [2022-11-07 15:55:11,760 genshinuid] INFO: 检查遗留信息... Exception ignored in: <function _ProactorBasePipeTransport.del at 0x00000295BD0568B0> Traceback (most recent call last): File "C:\Program Files\python\lib\asyncio\proactor_events.py", line 116, in del self.close() File "C:\Program Files\python\lib\asyncio\proactor_events.py", line 108, in close self._loop.call_soon(self._call_connection_lost, None) File "C:\Program Files\python\lib\asyncio\base_events.py", line 719, in call_soon self._check_closed() File "C:\Program Files\python\lib\asyncio\base_events.py", line 508, in _check_closed raise RuntimeError('Event loop is closed') RuntimeError: Event loop is closed [2022-11-07 15:55:15,558 nonebot] INFO: 尝试挂载WebConsole [2022-11-07 15:55:16,110 nonebot] INFO: WebConsole挂载成功：http://0.0.0.0:9222/genshinuid [2022-11-07 15:55:16,110] Running on http://0.0.0.0:9222 (CTRL + C to quit)

.............

[2022-11-07 15:56:02,175] 221.206.71.5:9077 GET /auth/form/login 1.1 500 0 3032219 [2022-11-07 15:56:02,175] 221.206.71.5:9082 GET /genshinuid 1.1 307 0 0 [2022-11-07 15:56:02,241] 221.206.71.5:9082 GET / 1.1 307 66 0 Error: 'default' is an invalid keyword argument for this function Traceback: Traceback (most recent call last): File "C:\Program Files\python\lib\site-packages\starlette\middleware\errors.py", line 162, in call await self.app(scope, receive, _send) File "C:\Program Files\python\lib\site-packages\starlette\middleware\exceptions.py", line 75, in call raise exc File "C:\Program Files\python\lib\site-packages\starlette\middleware\exceptions.py", line 64, in call await self.app(scope, receive, sender) File "C:\Program Files\python\lib\site-packages\fastapi\middleware\asyncexitstack.py", line 21, in call raise e File "C:\Program Files\python\lib\site-packages\fastapi\middleware\asyncexitstack.py", line 18, in call await self.app(scope, receive, send) File "C:\Program Files\python\lib\site-packages\starlette\routing.py", line 680, in call await route.handle(scope, receive, send) File "C:\Program Files\python\lib\site-packages\starlette\routing.py", line 275, in handle await self.app(scope, receive, send) File "C:\Program Files\python\lib\site-packages\starlette\routing.py", line 65, in app response = await func(request) File "C:\Program Files\python\lib\site-packages\fastapi\routing.py", line 221, in app solved_result = await solve_dependencies( File "C:\Program Files\python\lib\site-packages\fastapi\dependencies\utils.py", line 533, in solve_dependencies solved = await call(**sub_values) File "C:\Program Files\python\lib\site-packages\fastapi_amis_admin\admin\admin.py", line 911, in route return await self.page_parser(request, page) File "C:\Program Files\python\lib\site-packages\fastapi_amis_admin\admin\admin.py", line 869, in page_parser result = page.amis_html( File "C:\Program Files\python\lib\site-packages\fastapi_amis_admin\amis\components.py", line 129, in amis_html "AmisSchemaJson": self.amis_json(), File "C:\Program Files\python\lib\site-packages\fastapi_amis_admin\amis\types.py", line 23, in amis_json return self.json(exclude_none=True, by_alias=True) File "pydantic\main.py", line 505, in pydantic.main.BaseModel.json TypeError: 'default' is an invalid keyword argument for this function

[2022-11-07 15:56:02,401] 221.206.71.5:9082 GET /auth/form/login 1.1 500 0 0

我重新启动hoshino也无法复现此问题,包括重新clone,删除数据库重新开启控制台, 换用0.2.4和0.4.0都能正常进入网页控制台 无法定位具体问题 不知道你插件是否更新成功了,因为前面nb2.py不知道怎么丢失了,有点怪怪的 方便的话可以提供一份数据库文件以供复现么 Q444835641