FranzKafkaYu / x-ui

Lightweight Xray panel with multi-protocol and multi-user on the same port,supports English language and Telegram bot. Easy to use and easy to manage.
GNU General Public License v3.0
7.85k stars 1.57k forks source link

获取失败: too many SQL variables #396

Open shmilyshirley opened 1 year ago

shmilyshirley commented 1 year ago

Welcome

Description of the problem,screencshot would be good

问题描述:刷新面板提示“获取失败: too many SQL variables”,查阅资料后得知,是超出了sqlite上限999。那请问这个我该如何去解决呢。我尝试修改上限,但是无从下手。

Version of x-ui

```console $ x-ui version # Paste output here 面板版本[version]: 0.3.4.2:20230409 ```

x-ui log or xray log

```console # paste log here May 22 00:49:01 ccc-aaa-cloud x-ui[528]: 2023/05/22 00:49:01 WARNING - StatsNotifyJob run failed: too many SQL variables May 22 00:49:06 ccc-aaa-cloud x-ui[528]: 2023/05/22 00:49:06 WARNING - StatsNotifyJob run failed: too many SQL variables May 22 00:49:11 ccc-aaa-cloud x-ui[528]: 2023/05/22 00:49:11 WARNING - StatsNotifyJob run failed: too many SQL variables May 22 00:49:16 ccc-aaa-cloud x-ui[528]: 2023/05/22 00:49:16 WARNING - StatsNotifyJob run failed: too many SQL variables May 22 00:49:21 ccc-aaa-cloud x-ui[528]: 2023/05/22 00:49:21 WARNING - StatsNotifyJob run failed: too many SQL variables May 22 00:49:26 ccc-aaa-cloud x-ui[528]: 2023/05/22 00:49:26 WARNING - StatsNotifyJob run failed: too many SQL variables May 22 00:49:31 ccc-aaa-cloud x-ui[528]: 2023/05/22 00:49:31 WARNING - StatsNotifyJob run failed: too many SQL variables May 22 00:49:36 ccc-aaa-cloud x-ui[528]: 2023/05/22 00:49:36 WARNING - StatsNotifyJob run failed: too many SQL variables May 22 00:49:41 ccc-aaa-cloud x-ui[528]: 2023/05/22 00:49:41 WARNING - StatsNotifyJob run failed: too many SQL variables ```
shmilyshirley commented 1 year ago

作者,你好!我查阅了相关资料,了解到sqlite3.32.0版本之前默认是999,之后的版本默认是32766.我怀疑是这个x-ui依赖的sqlite版本降低导致出现“too many SQL variables”的报错。

请问下个版本能否更新呢?这个问题是我在测试的时候遇到的,我刷入了1000多条数据,则报错“too many SQL variables”,并且不会展示列表。小于等于999则不报错,可以正常展示。