幸福家园-提Bug

提Bug

所属产品

所属模块

影响版本

所有

当前指派

加载所有

截止日期

Bug标题

Bug类型

严重程度

优先级

重现步骤

[步骤]当前账户信息： 账号：SxVSkhcmadmin 用户姓名：德玛西亚账号 角色：小区管理员 小区ID：42 小区名称：测试德玛西亚社区当前页面地址：https://console.smartxfjy.cn/#/category/category-list异常操作：[登录账号] SxVSkhcmadmin[结果]错误类型: api错误信息: 接口业务错误: org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'custom_employee_names' in 'field list'
### The error may exist in net/lab1024/sa/admin/module/business/property/quality/dao/QualityCategoryMessageReminderDao.java (best guess)
### The error may involve net.lab1024.sa.admin.module.business.property.quality.dao.QualityCategoryMessageReminderDao.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO t_quality_category_message_reminder ( category_id, remind_time_value, remind_time_unit, notify_target, custom_employee_ids, custom_employee_names, notify_method, community_id, create_time ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'custom_employee_names' in 'field list'
; bad SQL grammar []页面地址: https://console.smartxfjy.cn/#/category/category-list接口地址: /quality/category/message/save请求头:<pre>{
 "Accept": "application/json, text/plain, */*",
 "Content-Type": "application/json",
 "Authorization": "Bearer 3a35a2ec2fdc46068ffbc1e49b5503f5"
}</pre>请求参数:<pre>"{\"categoryId\":11,\"stages\":[{\"stage\":1,\"enabled\":true,\"timeoutUnit\":\"hour\",\"notifyTarget\":\"rectifier\",\"customEmployeeIds\":\"\",\"customEmployeeNames\":\"\",\"notifyMethod\":\"wechat\"},{\"stage\":2,\"enabled\":true,\"timeoutValue\":5,\"timeoutUnit\":\"minute\",\"notifyTarget\":\"rectifier\",\"customEmployeeIds\":\"\",\"customEmployeeNames\":\"\",\"notifyMethod\":\"wechat\"},{\"stage\":4,\"enabled\":true,\"timeoutUnit\":\"hour\",\"notifyTarget\":\"verifier\",\"customEmployeeIds\":\"\",\"customEmployeeNames\":\"\",\"notifyMethod\":\"wechat\"},{\"stage\":5,\"enabled\":true,\"timeoutValue\":24,\"timeoutUnit\":\"hour\",\"notifyTarget\":\"verifier\",\"customEmployeeIds\":\"\",\"customEmployeeNames\":\"\",\"notifyMethod\":\"wechat\"},{\"stage\":6,\"enabled\":true,\"timeoutUnit\":\"hour\",\"notifyTarget\":\"rectifier,creator\",\"customEmployeeIds\":\"\",\"customEmployeeNames\":\"\",\"notifyMethod\":\"wechat\"}],\"remindersEnabled\":true,\"reminders\":[{\"remindTimeValue\":10,\"remindTimeUnit\":\"minute\",\"notifyTarget\":\"rectifier\",\"customEmployeeIds\":\"\",\"customEmployeeNames\":\"\",\"notifyMethod\":\"wechat\"}]}"</pre>响应头:<pre>{
 "access-control-allow-credentials": "true",
 "access-control-allow-origin": "https://console.smartxfjy.cn, *",
 "connection": "keep-alive",
 "content-type": "application/json",
 "date": "Thu, 26 Feb 2026 03:25:48 GMT",
 "server": "nginx/1.20.1",
 "transfer-encoding": "chunked",
 "vary": "Origin, Access-Control-Request-Method, Access-Control-Request-Headers"
}</pre>响应数据:<pre>{
 "code": 10001,
 "level": "system",
 "msg": "org.springframework.jdbc.BadSqlGrammarException: \n### Error updating database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'custom_employee_names' in 'field list'\n### The error may exist in net/lab1024/sa/admin/module/business/property/quality/dao/QualityCategoryMessageReminderDao.java (best guess)\n### The error may involve net.lab1024.sa.admin.module.business.property.quality.dao.QualityCategoryMessageReminderDao.insert-Inline\n### The error occurred while setting parameters\n### SQL: INSERT INTO t_quality_category_message_reminder ( category_id, remind_time_value, remind_time_unit, notify_target, custom_employee_ids, custom_employee_names, notify_method, community_id, create_time ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? )\n### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'custom_employee_names' in 'field list'\n; bad SQL grammar []",
 "ok": false,
 "dataType": 1
}</pre>[截图]<img src="https://hlxq.oss-cn-shenzhen.aliyuncs.com/public/common/d775a91dab8047519ad1e8c353702492_20260226112757.png" alt="d775a91dab8047519ad1e8c353702492_20260226112757.png" />[期望]点击列表操作栏下的【配置】进行配置后，保存成功

附件

所属项目

所属执行

所属计划

来源用例