koishi-plugin-cumyou无法正常使用

问题反馈
1

System:
OS: Linux 6.8 Ubuntu 24.04 LTS 24.04 LTS (Noble Numbat)
CPU: (4) x64 Intel(R) Xeon(R) CPU E5-2698 v4 @ 2.20GHz

Binaries:
Node: 20.14.0
Yarn: 4.1.1

Koishi:
Core: 4.17.9
Console: 5.29.2

只有社保指令没办法用awa，会发生未知错误，剩下两个都可以正常用：

2024-06-22 15:54:18 [I] cumyou 1718985600000 | undefined
2024-06-22 15:54:18 [W] mysql > INSERT INTO `CumYou` (`id`, `time`, `count`) VALUES ('2461654161', 1718985600000, 0) ON DUPLICATE KEY UPDATE `time` = VALUES(`time`), `count` = VALUES(`count`)
2024-06-22 15:54:18 [W] command cum 
                        ER_WARN_DATA_OUT_OF_RANGE: Out of range value for column 'time' at row 1
                            at MySQLDriver.query (/home/koishi/node_modules/@minatojs/driver-mysql/lib/index.cjs:505:19)
                            at MySQLDriver.upsert (/home/koishi/node_modules/@minatojs/driver-mysql/lib/index.cjs:677:31)
                            at Executable.execute (/home/koishi/node_modules/minato/lib/index.cjs:853:34)
                            at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
                            at async Command.<anonymous> (/home/koishi/node_modules/koishi-plugin-cumyou/lib/index.js:36:13)
                            at async Array.<anonymous> (/home/koishi/node_modules/@koishijs/core/lib/index.cjs:1114:14)
                            at async Command.execute (/home/koishi/node_modules/@koishijs/core/lib/index.cjs:1128:22)
                            at async /home/koishi/node_modules/@koishijs/core/lib/index.cjs:2162:22
                            at async Proxy.withScope (/home/koishi/node_modules/@koishijs/core/lib/index.cjs:2065:22)
                            at async next (/home/koishi/node_modules/@koishijs/core/lib/index.cjs:853:16)
2 个赞
2

@Twiyin0

unsigned默认长度为32位无符号整数，这里至少需要unsigned(6)或者使用专用于时间的类型才可安全存储。

1 个赞
4

请问我该如何解决这个问题？

1 个赞
5

需要插件作者来解决

1 个赞