表单有模糊搜索字段时没有判断是否有值，导致生成的sql语句有无效的查询条件`name` like '%%'

Open

#122 opened on Sep 18, 2025 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty: 2/5
Estimated time: 1-3 hours
Newbie friendliness: 55/100

Issue type: Bug
Clarity: Clearly specified
Activity status: Stale
Tech stack: php, sql
Domain: backend, databases

Research direction

Read plugin/admin/app/controller/Crud.php and locate the doSelect function that handles fuzzy-search fields. Reproduce the example query with an empty name value, then verify that the generated SQL no longer includes an invalid name like '%%' condition when the field has no value.

Written by the indexing model from the issue text.

Description

这是生成的示例sql：select count(*) as aggregate from order where name like '%%'
plugin/admin/app/controller/Crud.php 的 doSelect函数中没有对模糊查询的字段进行非空判断，建议加上非空判断

Dominant language: JavaScript
Stars: 378
Forks: 48
Avg merge: 20h 9m
Merged PRs (30d): 2

Contributor guide

No contributing guide indexed for this repository

First steps

Read the whole issue, then the project's contributing guide.
Comment on the issue to say you are picking it up — it saves two people doing the same work.
Fork the repository and make your change on a branch.
Open a pull request that references the issue number.

Similar issues

issue: imported chats all show as unread in the sidebar Open

bug confirmed issue

Difficulty 2/5 1-3 hours Newbie friendliness 75/100

open-webui/open-webui#30750 · 1 comment · Opened Sep 24, 2026
Option to disable or recolor "New" on new videos Open

Difficulty 2/5 1-3 hours Newbie friendliness 75/100

insin/control-panel-for-youtube#335 · Opened Sep 24, 2026
tests/puppeteer/test_openai_api_key_ui.js targets controls that do not exist and is run by no workflow Open

Difficulty 2/5 1-3 hours Newbie friendliness 70/100

LearningCircuit/local-deep-research#6766 · Opened Sep 23, 2026
Fix exit code 2 when every error in a file is suppressed and anything else is reported Open

Difficulty 2/5 1-3 hours Newbie friendliness 75/100

stylelint/stylelint#9527 · Opened Sep 23, 2026
CVE-2026-93748 (High) detected in http-cache-semantics-4.1.1.tgz Open

Mend: dependency security vulnerability untriaged

Difficulty 2/5 1-3 hours Newbie friendliness 70/100

opensearch-project/OpenSearch-Dashboards#12806 · Opened Sep 23, 2026

More JavaScript issues