接受群消息时发生报错

[nightmare-yudachi]

日志如下 python3.8 mysql8.0.23
2021-04-21 18:59:26.316 | ERROR | SAGIRIBOT.Handler.MessageHandler:handle:59 - Traceback (most recent call last):
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\sqlalchemy\engine\base.py", line 1705, in _execute_context
self.dialect.do_execute(
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\sqlalchemy\engine\default.py", line 681, in do_execute
cursor.execute(statement, parameters)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\MySQLdb\cursors.py", line 206, in execute
res = self._query(query)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\MySQLdb\cursors.py", line 319, in _query
db.query(q)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\MySQLdb\connections.py", line 259, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1054, "Unknown column 'setting.group_id' in 'where clause'")

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

Traceback (most recent call last):
File "D:\学习资料1\sagiri-bot-2.0.2\SAGIRIBOT\Handler\MessageHandler.py", line 54, in handle
if result := await self.__head_handler.handle(app, message, group, member):
File "D:\学习资料1\sagiri-bot-2.0.2\SAGIRIBOT\Handler\Handler.py", line 62, in handle
if not await get_setting(group.id, Setting.switch) and member.id not in await get_admins(group):
File "D:\学习资料1\sagiri-bot-2.0.2\SAGIRIBOT\utils.py", line 177, in get_setting
if result := list(orm.fetchone(select(setting).where(Setting.group_id == group_id))):
File "D:\学习资料1\sagiri-bot-2.0.2\SAGIRIBOT\ORM\ORM.py", line 49, in fetchone
result = self.execute(sql)
File "D:\学习资料1\sagiri-bot-2.0.2\SAGIRIBOT\ORM\ORM.py", line 42, in execute
return self.engine.execute(sql, **kwargs)
File "", line 2, in execute
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\sqlalchemy\util\deprecations.py", line 390, in warned
return fn(*args, **kwargs)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\sqlalchemy\engine\base.py", line 3009, in execute
return connection.execute(statement, *multiparams, **params)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\sqlalchemy\engine\base.py", line 1200, in execute
return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\sqlalchemy\sql\elements.py", line 313, in _execute_on_connection
return connection._execute_clauseelement(
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\sqlalchemy\engine\base.py", line 1389, in _execute_clauseelement
ret = self._execute_context(
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\sqlalchemy\engine\base.py", line 1748, in _execute_context
self.handle_dbapi_exception(
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\sqlalchemy\engine\base.py", line 1929, in handle_dbapi_exception
util.raise(
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\sqlalchemy\util\compat.py", line 198, in raise
raise exception
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\sqlalchemy\engine\base.py", line 1705, in _execute_context
self.dialect.do_execute(
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\sqlalchemy\engine\default.py", line 681, in do_execute
cursor.execute(statement, parameters)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\MySQLdb\cursors.py", line 206, in execute
res = self._query(query)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\MySQLdb\cursors.py", line 319, in _query
db.query(q)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python38\lib\site-packages\MySQLdb\connections.py", line 259, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1054, "Unknown column 'setting.group_id' in 'where clause'")
[SQL: SELECT setting.switch
FROM setting
WHERE setting.group_id = %s]

[SAGIRI-kawaii]

请问使用的是最新版吗

[nightmare-yudachi]

使用的是2.0.3 确认过了 2.0.3和2.0.3都一样

[SAGIRI-kawaii]

请尝试删除data.db后重新启动，若还不行请尝试最新版本（从首页直接下载）

[nightmare-yudachi]

使用从首页直接下载的程序不会报错了 感谢