[步骤]

当前账户信息：

账号：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

请求头:

{
  "Accept": "application/json, text/plain, */*",
  "Content-Type": "application/json",
  "Authorization": "Bearer 3a35a2ec2fdc46068ffbc1e49b5503f5"
}

请求参数:

"{\"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\"}]}"

响应头:

{
  "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"
}

响应数据:

{
  "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
}

[截图]

[期望]

点击列表操作栏下的【配置】进行配置后，保存成功