【修仙世界调试 (MySQL)】开启脚本提示SQL的 action 表不存在

### 问题
---
    
   开启脚本会提示SQL的 action 表不存在。 想问下插件安装的时候没有提供一个 SQL 文件来自动初始化数据库么？ 没太用过MySQL这些数据库，不懂得怎么配置。能提供一个方法吗？

### 信息
---
yunzai框架版本
[TRSS-Yunzai](https://gitee.com/TimeRainStarSky/Yunzai)
<br>

MySQL版本
`mysql  Ver 8.0.39-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))`
<br>

database.yaml
```
    Database: #mysql数据库配置
      username: 'root' #数据库用户名,一般是root
      password: '123456' #数据库密码
```
<br>

在Yunzai-Bot/目录下执行 pnpm install mysql --workspace-root 显示
```
root@hcss-ecs-e3e8:~/Yunzai# pnpm install mysql --workspace-root
 WARN  `node_modules` is present. Lockfile only installation will make it out-of-date
plugins/miao-plugin                      |  WARN  deprecated request@2.88.2
 WARN  14 deprecated subdependencies found: @humanwhocodes/config-array@0.11.14, @humanwhocodes/object-schema@2.0.3, @npmcli/move-file@1.1.2, are-we-there-yet@2.0.0, are-we-there-yet@3.0.1, gauge@3.0.2, gauge@4.0.4, glob@7.2.3, har-validator@5.1.5, inflight@1.0.6, npmlog@5.0.1, npmlog@6.0.2, rimraf@3.0.2, uuid@3.4.0
Progress: resolved 677, reused 0, downloaded 0, added 0, done
Already up to date
Done in 4.4s
```

### log
---
```
[14:37:53.512][MARK][1***QQ号****7] OneBotv11(QQ) Lagrange.OneBot v0.0.3 已连接
[14:38:00.003][MARK][yijietask(0/30 * * * * ?)][开始处理]
[14:38:00.005][MARK][yijietask(0/30 * * * * ?)][完成0.002秒]
[14:38:00.006][MARK][yijieSecretPlaceTask(0/30 * * * * ?)][开始处理]
[14:38:00.007][MARK][yijieSecretPlaceTask(0/30 * * * * ?)][完成0.001秒]
[14:38:00.009][MARK][Xijietask(0/30 * * * * ?)][开始处理]
[14:38:00.011][MARK][PlayerControlTask(0/30 * * * * ?)][开始处理]
[14:38:00.020][MARK][PlayerControlTask(0/30 * * * * ?)][完成0.009秒]
[14:38:00.022][MARK][LevelTask(0/30 * * * * ?)][开始处理]
[14:38:00.027][MARK][Xijietask(0/30 * * * * ?)][完成0.019秒]
[14:38:00.028][MARK][SecretPlaceTask(0/30 * * * * ?)][开始处理]
[14:38:00.029][MARK][SecretPlaceTask(0/30 * * * * ?)][完成0.001秒]
[14:38:00.033][MARK][OccupationTask(0/30 * * * * ?)][开始处理]
[14:38:00.034][MARK][OccupationTask(0/30 * * * * ?)][完成0.001秒]
[14:38:00.034][MARK][LevelTask(0/30 * * * * ?)][完成0.012秒]
[14:38:00.037][MARK][AuctionofficialTask(0/30 * * * * ?)][开始处理]
Error: ER_NO_SUCH_TABLE: Table 'xiuxiandatabase.action' doesn't exist
    at Sequence._packetToError (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Query.ErrorPacket (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
    at Protocol._parsePacket (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (node:events:520:28)
    at addChunk (node:internal/streams/readable:559:12)
    --------------------
    at Pool.query (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/Pool.js:199:23)
    at PlayerControlTask.Playercontroltask (file:///root/Yunzai/plugins/xiuxian-emulator-plugin/apps/User/PlayerControlTask.js:43:13)
    at Object.fnc (file:///root/Yunzai/plugins/xiuxian-emulator-plugin/apps/User/PlayerControlTask.js:37:29)
    at Job.job (file:///root/Yunzai/lib/plugins/loader.js:554:17)
    at Job.invoke (/root/Yunzai/node_modules/.pnpm/node-schedule@2.1.1/node_modules/node-schedule/lib/Job.js:171:15)
    at /root/Yunzai/node_modules/.pnpm/node-schedule@2.1.1/node_modules/node-schedule/lib/Invocation.js:268:28
    at Timeout._onTimeout (/root/Yunzai/node_modules/.pnpm/node-schedule@2.1.1/node_modules/node-schedule/lib/Invocation.js:228:7)
    at listOnTimeout (node:internal/timers:581:17)
    at process.processTimers (node:internal/timers:519:7) {
  code: 'ER_NO_SUCH_TABLE',
  errno: 1146,
  sqlMessage: "Table 'xiuxiandatabase.action' doesn't exist",
  sqlState: '42S02',
  index: 0,
  sql: 'select * from action where action_zhiye=0;'
}
[14:38:00.040][MARK][AuctionTask(0/30 * * * * ?)][开始处理]
[14:38:00.041][MARK][AuctionofficialTask(0/30 * * * * ?)][完成0.005秒]
Error: ER_NO_SUCH_TABLE: Table 'xiuxiandatabase.action' doesn't exist
    at Sequence._packetToError (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Query.ErrorPacket (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
    at Protocol._parsePacket (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (node:events:520:28)
    at addChunk (node:internal/streams/readable:559:12)
    --------------------
    at Pool.query (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/Pool.js:199:23)
    at SecretPlaceTask.Secretplacetask (file:///root/Yunzai/plugins/xiuxian-emulator-plugin/apps/SecretPlace/SecretPlaceTask.js:57:8)
    at Object.fnc (file:///root/Yunzai/plugins/xiuxian-emulator-plugin/apps/SecretPlace/SecretPlaceTask.js:51:23)
    at Job.job (file:///root/Yunzai/lib/plugins/loader.js:554:17)
    at Job.invoke (/root/Yunzai/node_modules/.pnpm/node-schedule@2.1.1/node_modules/node-schedule/lib/Job.js:171:15)
    at /root/Yunzai/node_modules/.pnpm/node-schedule@2.1.1/node_modules/node-schedule/lib/Invocation.js:268:28
    at Timeout._onTimeout (/root/Yunzai/node_modules/.pnpm/node-schedule@2.1.1/node_modules/node-schedule/lib/Invocation.js:228:7)
    at listOnTimeout (node:internal/timers:581:17)
    at process.processTimers (node:internal/timers:519:7) {
  code: 'ER_NO_SUCH_TABLE',
  errno: 1146,
  sqlMessage: "Table 'xiuxiandatabase.action' doesn't exist",
  sqlState: '42S02',
  index: 0,
  sql: 'select * from action where action_mijing=1;'
}
[]
[14:38:00.045][MARK][AuctionTask(0/30 * * * * ?)][完成0.005秒]
Error: ER_NO_SUCH_TABLE: Table 'xiuxiandatabase.action' doesn't exist
    at Sequence._packetToError (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Query.ErrorPacket (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
    at Protocol._parsePacket (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (node:events:520:28)
    at addChunk (node:internal/streams/readable:559:12)
    --------------------
    at Pool.query (/root/Yunzai/node_modules/.pnpm/mysql@2.18.1/node_modules/mysql/lib/Pool.js:199:23)
    at OccupationTask (file:///root/Yunzai/plugins/xiuxian-emulator-plugin/apps/Occupation/OccupationTask.js:46:13)
    at Object.fnc (file:///root/Yunzai/plugins/xiuxian-emulator-plugin/apps/Occupation/OccupationTask.js:38:29)
    at Job.job (file:///root/Yunzai/lib/plugins/loader.js:554:17)
    at Job.invoke (/root/Yunzai/node_modules/.pnpm/node-schedule@2.1.1/node_modules/node-schedule/lib/Job.js:171:15)
    at /root/Yunzai/node_modules/.pnpm/node-schedule@2.1.1/node_modules/node-schedule/lib/Invocation.js:268:28
    at Timeout._onTimeout (/root/Yunzai/node_modules/.pnpm/node-schedule@2.1.1/node_modules/node-schedule/lib/Invocation.js:228:7)
    at listOnTimeout (node:internal/timers:581:17)
    at process.processTimers (node:internal/timers:519:7) {
  code: 'ER_NO_SUCH_TABLE',
  errno: 1146,
  sqlMessage: "Table 'xiuxiandatabase.action' doesn't exist",
  sqlState: '42S02',
  index: 0,
  sql: 'select * from action where action_zhiye=1;'
}

```

屑洛/修仙插件星瀚魔改

内容风险标识

评论 (1)

屑洛/修仙插件星瀚魔改 .gitee-modal { width: 500px !important; }

内容风险标识