报错:
### Error updating database. Cause: java.sql.SQLException: Field 'desc1' doesn't have a default value
### The error may exist in file [C:\Users\lenovo\Desktop\project\order-back-end\pipilin-system\target\classes\mapper\system\PGoodsMapper.xml]
### The error may involve com.pipilin.system.mapper.PGoodsMapper.insertPGoods-Inline
### The error occurred while setting parameters
### SQL: insert into p_goods ( name, images, price, create_time, category_id, content ) values ( ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLException: Field 'desc1' doesn't have a default value ; Field 'desc1' doesn't have a default value; nested exception is java.sql.SQLException: Field 'desc1' doesn't have a default value
原因分析:
检查数据表设计:在设计表的时候desc1设置成不为空
但是在管理端的添加商品页面没有写添加描述(decs1)这一项,添加商品时desc1项为空,与表中的desc1项设置冲突。
加入desc1
成功添加,没有再报错。