[Bug0026] Error updating database. Cause: java.sql.SQLException: Field 'parent_id' doesn't have a default value

1、问题

### Error updating database. Cause: java.sql.SQLException: Field 'parent_id' doesn't have a default value 
### The error may exist in com/ruoyi/xxx/mapper/xxxxMenuMapper.java (best guess) 
### The error may involve com.ruoyi.xxxx.mapper.xxxxMenuMapper.insert-Inline 
### The error occurred while setting parameters 
### SQL: INSERT INTO xxx_menu ( id, name, permid ) VALUES ( ?, ?, ? ) 
### Cause: java.sql.SQLException: Field 'parent_id' doesn't have a default value ; Field 'parent_id' doesn't have a default value; nested exception is java.sql.SQLException: Field 'parent_id' doesn't have a default value

2、场景

前端对接时发现报错，然后查看后端代码没有问题，发现该字段设计时设计为非空。

3、原因

数据库对应字段设置了要求非空，前端传来空字段

4、解决方案

修改数据库字段为可以为空

可视化工具 DBeaver 上找到对应字段下图设置非空不勾选即可。