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
733 stars 102 forks source link

中午更新完就这样了,扔到虚拟环境里面重装依赖也没用😳 #537

Closed 2085673514 closed 1 year ago

2085673514 commented 1 year ago

05-09 19:51:59 [INFO] gsuid_core.sv | 载入keyword触发器【关键词测试】! 05-09 19:51:59 [INFO] gsuid_core.sv | 载入regex触发器【\d+】! 05-09 19:52:04 [INFO] uvicorn.server | Started server process [180992] 05-09 19:52:04 [INFO] uvicorn.lifespan.on | Waiting for application startup. 05-09 19:52:04 [INFO] plugins.GenshinUID.GenshinUID.genshinuid_resource | [资源文件下载] 正在检查与下载缺失的资源文件, 可能需要较长时间,请稍等 05-09 19:52:04 [INFO] plugins.GenshinUID.GenshinUID.genshinuid_resource | [资源文件下载] 正在检查与下载缺失的资源文件, 可能需要较长时间,请稍等 05-09 19:52:04 [INFO] gsuid_core.webconsole.init | 尝试挂载WebConsole 05-09 19:52:04 [ERROR] uvicorn.lifespan.on | Traceback (most recent call last): File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\engine\base.py", line 1900, in _execute_context self.dialect.do_execute( File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\engine\default.py", line 736, in do_execute cursor.execute(statement, parameters) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 100, in execute self._adapt_connection._handle_exception(error) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 228, in _handle_exception raise error File "C:\NoneBot2\gsuidcore\gs\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 82, in execute self.await(_cursor.execute(operation, parameters)) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 68, in await_only return current.driver.switch(awaitable) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 121, in greenlet_spawn value = await result File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\aiosqlite\cursor.py", line 48, in execute await self._execute(self._cursor.execute, sql, parameters) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\aiosqlite\cursor.py", line 40, in _execute return await self._conn._execute(fn, *args, **kwargs) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\aiosqlite\core.py", line 133, in _execute return await future File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\aiosqlite\core.py", line 106, in run result = function() sqlite3.OperationalError: no such column: auth_user.bot_id

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

Traceback (most recent call last): File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\starlette\routing.py", line 677, in lifespan async with self.lifespan_context(app) as maybe_state: File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\starlette\routing.py", line 566, in aenter await self._router.startup() File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\starlette\routing.py", line 654, in startup await handler() File "C:\NoneBot2\gsuid_core\gsuid_core\core.py", line 64, in startup_event await start_check() File "C:\NoneBot2\gsuid_core\gsuid_core\webconsole__init__.py", line 27, in start_check await site.auth.create_role_user('admin') File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\fastapi_user_auth\auth\auth.py", line 224, in create_role_user user = await self.db.async_run_sync(self._create_role_user_sync, role_key) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy_database\database.py", line 194, in run_sync return await self.session.run_sync(fn, *args, *kwargs) File "C:\NoneBot2\gsuid_core\gs\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:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 126, in greenlet_spawn result = context.throw(sys.exc_info()) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\fastapi_user_auth\auth\auth.py", line 207, in _create_role_user_sync user = session.scalar( File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\orm\session.py", line 1742, in scalar return self.execute( File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlmodel\orm\session.py", line 101, in execute return super().execute( # type: ignore File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\orm\session.py", line 1712, in execute result = conn._execute_20(statement, params or {}, execution_options) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\engine\base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\sql\elements.py", line 333, in _execute_on_connection return connection._execute_clauseelement( File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\engine\base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\engine\base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\engine\base.py", line 2124, in _handle_dbapiexception util.raise( File "C:\NoneBot2\gsuidcore\gs\lib\site-packages\sqlalchemy\util\compat.py", line 208, in raise raise exception File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\engine\base.py", line 1900, in _execute_context self.dialect.do_execute( File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\engine\default.py", line 736, in do_execute cursor.execute(statement, parameters) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 100, in execute self._adapt_connection._handle_exception(error) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 228, in _handle_exception raise error File "C:\NoneBot2\gsuidcore\gs\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 82, in execute self.await(_cursor.execute(operation, parameters)) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 68, in await_only return current.driver.switch(awaitable) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\sqlalchemy\util_concurrency_py3k.py", line 121, in greenlet_spawn value = await result File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\aiosqlite\cursor.py", line 48, in execute await self._execute(self._cursor.execute, sql, parameters) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\aiosqlite\cursor.py", line 40, in _execute return await self._conn._execute(fn, args, kwargs) File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\aiosqlite\core.py", line 133, in _execute return await future File "C:\NoneBot2\gsuid_core\gs\lib\site-packages\aiosqlite\core.py", line 106, in run result = function() sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: auth_user.bot_id [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.bot_id, auth_user.user_id, 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)

05-09 19:52:04 [ERROR] uvicorn.lifespan.on | Application startup failed. Exiting.

KimigaiiWuyi commented 1 year ago

可能是数据库原因,数据不多的话可以尝试删除数据库,重新生成,数据多的话可以尝试打开数据库,删除auth开头的所有表,然后重新加载

2085673514 commented 1 year ago

没问题了确实是数据库问题