[步骤]
当前账户信息:
账号:ZLYHXQcommAdmin
用户姓名:赵晓晓
角色:小区管理员
小区ID:203
小区名称:芝澜月华小区
当前页面地址:https://console.smartxfjy.cn/#/car-park
异常操作:
[登录账号] ZLYHXQcommAdmin
[结果]
错误类型: api
错误信息: 接口业务错误: org.springframework.dao.DataIntegrityViolationException: ### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'remark' at row 1 ### The error may exist in net/lab1024/sa/admin/module/business/user/car/dao/CarParkDao.java (best guess) ### The error may involve net.lab1024.sa.admin.module.business.user.car.dao.CarParkDao.insert-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO b_car_park ( name, shortname, remark, community_id ) VALUES ( ?, ?, ?, ? ) ### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'remark' at row 1 ; Data truncation: Data too long for column 'remark' at row 1
页面地址: https://console.smartxfjy.cn/#/car-park
接口地址: /carPark/add
请求头:
{
"Accept": "application/json, text/plain, */*",
"Content-Type": "application/json",
"Authorization": "Bearer 2ef37752a1e1478f9f772eb1fced68c7"
}
请求参数:
"{\"name\":\"东南朝阳广场停车场\",\"shortname\":\"朝阳停车场\",\"remark\":\"刘邦大军进入咸阳,看到那豪华的宫殿、美貌的宫女和珍宝异藏,使许多人忘乎所以,以为可以尽享天下。连刘邦也情不自禁,想留居宫中。武将樊哙冒死犯颜强谏,直斥刘邦“要做富家翁”。刘邦根本不予理睬。 [23]在这关键时刻,张良向刘邦分析利害,劝道:“秦王多做不义的事,所以,您才能推翻他而进入咸阳。既然您已经为天下人铲除了祸害,就应该布衣素食,以示节俭。大军刚入秦地,您就沉溺在享乐中,这就是所谓助桀为虐了。况且良药苦口利于病,忠言逆耳利于行,愿沛公听从樊哙等人的话。 [24]”张良语气平和,但软中有硬,尤其是话中对古今成败的揭示以及“无道秦”、“助桀为虐”等苛刻字眼,隐隐地刺疼了刘邦近乎沉醉的心。这种紧打慢唱的手法,果然奏效。刘邦接受了这卓有远见的规劝,下令封存秦朝宫宝、府库、财物,还军于霸上 [25],以待项羽等路起义军。在此期间,刘邦还采纳张良建议,召集诸县父老豪杰,与之约法三章:“杀人者死,伤人及盗抵罪。 [26]”并通告四方:“余悉除去秦法。诸吏人皆安诸如故。凡吾所以来,非有所侵暴,勿恐。”另外,还派人与秦吏一起巡行各地,晓谕此意。结果,博得了秦民的一致拥戴,争先恐后用牛羊酒食慰劳军士。刘\",\"communityId\":203,\"isTrusted\":true,\"_vts\":1765519734474}"
响应头:
{
"access-control-allow-credentials": "true",
"access-control-allow-origin": "https://console.smartxfjy.cn, *",
"connection": "keep-alive",
"content-type": "application/json",
"date": "Fri, 12 Dec 2025 06:09:27 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.dao.DataIntegrityViolationException: \n### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'remark' at row 1\n### The error may exist in net/lab1024/sa/admin/module/business/user/car/dao/CarParkDao.java (best guess)\n### The error may involve net.lab1024.sa.admin.module.business.user.car.dao.CarParkDao.insert-Inline\n### The error occurred while setting parameters\n### SQL: INSERT INTO b_car_park ( name, shortname, remark, community_id ) VALUES ( ?, ?, ?, ? )\n### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'remark' at row 1\n; Data truncation: Data too long for column 'remark' at row 1",
"ok": false,
"dataType": 1
}
[截图]

[期望]
正常执行,无异常