评论消失, 管理后台也无法正常查看数据

[wsndshx]

我部署在railway平台上，最近登录上去发现无法查看历史评论，进入后台也无法查看历史用户、评论等数据，直接访问数据库可以看见数据还在。进入后端查看日志发现如下错误输出

SQL: SELECT "id","email","url","display_name","type","github","twitter","facebook","google","weibo","qq","avatar","2fa","label","id" FROM "wl_users" WHERE ( "email" = E'[email protected]' ), Time: 9ms
error: column "2fa" does not exist
at Parser.parseErrorMessage (/app/node_modules/pg-protocol/src/parser.ts:369:69)
at Parser.handlePacket (/app/node_modules/pg-protocol/src/parser.ts:188:21)
at Parser.parse (/app/node_modules/pg-protocol/src/parser.ts:103:30)
at Socket.<anonymous> (/app/node_modules/pg-protocol/src/index.ts:7:48)
at Socket.emit (node:events:513:28)
at Socket.emit (node:domain:489:12)
at addChunk (node:internal/streams/readable:315:12)
at readableAddChunk (node:internal/streams/readable:289:9)
at Socket.Readable.push (node:internal/streams/readable:228:10)
at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
length: 104,
severity: 'ERROR',
code: '42703',
detail: undefined,
hint: undefined,
position: '110',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'parse_relation.c',
line: '3504',
routine: 'errorMissingColumn'
}

曾经进行过如下操作：

• 服务由于超出限制被暂停
• 今天通过绑定支付手段将其恢复运行
• 将GitHub仓库与上游仓库合并，版本变更为1.5.0 -> 1.19.2
• 访问后台管理界面，发现无法正常读取数据库数据

怀疑会不会是版本更新的问题，毕竟版本号差了挺远。如果是本版更新导致的，有没有将数据库从旧版本1.5.0升级至新版本1.19.2的方法。

[wsndshx]

看了下好像是程序认为我开启了2fa？但数据库中不存在2fa相关的字段。

[wsndshx]

在数据库中执行以下查询

ALTER TABLE wl_users ADD "2fa" varchar(32);
ALTER TABLE wl_users ADD label varchar(255);

后恢复正常