Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature request: sqlite REGEXP #12

Closed
MirrorCY opened this issue Dec 30, 2022 · 3 comments
Closed

Feature request: sqlite REGEXP #12

MirrorCY opened this issue Dec 30, 2022 · 3 comments

Comments

@MirrorCY
Copy link

dialogue 读取带图片问答时报错,报错内容为 Error: no such function: REGEXP

复现流程:

  1. 安装 koishi desktop 0.9.1
  2. 安装配置 assets-local dialogue onebot 插件
  3. onebot 群聊中添加对话 foo,回答为一张图片
  4. 群聊中输入 foo,没有回复
  5. 查看 log

相关日志:

�[38;5;8m2022-12-30 17:19:13�[0m [W] �[38;5;209;1msqlite�[0m > SELECT * FROM `dialogue` bcrghqyv WHERE (`flag` & 2 = 2 AND 'foo' REGEXP `original` OR `flag` & 2 = 0 AND `question` = 'foo')
�[38;5;8m2022-12-30 17:19:13�[0m [W] �[38;5;129;1msession�[0m foo
                        Error: no such function: REGEXP
                            at f.handleError (C:\Users\42\AppData\Roaming\Koishi\Desktop\data\instances\default\node_modules\@minatojs\sql.js\dist\sql-wasm.js:91:290)
                            at f.prepare (C:\Users\42\AppData\Roaming\Koishi\Desktop\data\instances\default\node_modules\@minatojs\sql.js\dist\sql-wasm.js:90:46)
                            at SQLiteDriver.#exec (C:\Users\42\AppData\Roaming\Koishi\Desktop\data\instances\default\node_modules\@minatojs\driver-sqlite\lib\index.js:307:26)
                            at SQLiteDriver.#all (C:\Users\42\AppData\Roaming\Koishi\Desktop\data\instances\default\node_modules\@minatojs\driver-sqlite\lib\index.js:319:48)
                            at SQLiteDriver.get (C:\Users\42\AppData\Roaming\Koishi\Desktop\data\instances\default\node_modules\@minatojs\driver-sqlite\lib\index.js:241:54)
                            at Selection.execute (C:\Users\42\AppData\Roaming\Koishi\Desktop\data\instances\default\node_modules\@minatojs\core\lib\index.cjs:349:34)
                            at Selection.execute (C:\Users\42\AppData\Roaming\Koishi\Desktop\data\instances\default\node_modules\@minatojs\core\lib\index.cjs:414:20)
                            at DatabaseService.get (C:\Users\42\AppData\Roaming\Koishi\Desktop\data\instances\default\node_modules\@minatojs\core\lib\index.cjs:496:22)
                            at processTicksAndRejections (node:internal/process/task_queues:96:5)
                            at async DialogueService.get (C:\Users\42\AppData\Roaming\Koishi\Desktop\data\instances\default\node_modules\koishi-plugin-dialogue\lib\index.js:126:25)
@Anillc
Copy link
Contributor

Anillc commented Jan 2, 2023

请问你那边能稳定复现吗,我这边测试多次并没有遇到这样的问题,能否详细描述一下你的环境

@MirrorCY
Copy link
Author

MirrorCY commented Jan 2, 2023

稍晚我尝试复现,按道理应该是百分之百复现的

@Anillc
Copy link
Contributor

Anillc commented Jan 3, 2023

尝试一下这里说的禁用 dataview 呢

koishijs/koishi#894 (comment)

@shigma shigma closed this as completed in b97163c Jan 3, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants