在商户中添加商品时,出现报错提示,添加不成功。
### Error updating database. Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'ot_price' at row 1 ### The error may exist in com/zbkj/service/dao/ProductDao.java (best guess) ### The error may involve com.zbkj.service.dao.ProductDao.insert-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO eb_product ( mer_id, image, slider_image, name, intro, keyword, cate_id, brand_id, category_id, guarantee_ids, price, ot_price, unit_name, stock, cost, temp_id, sort, spec_type, is_sub, is_show, audit_status, is_audit ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ### Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'ot_price' at row 1 ; Data truncation: Out of range value for column 'ot_price' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'ot_price' at row 1
{{item.user_info.nickname ? item.user_info.nickname : item.user_name}}
作者 管理员 企业
{{itemf.name}}
{{itemc.user_info.nickname}}
{{itemc.user_name}}
回复 {{itemc.comment_user_info.nickname}}
{{itemf.name}}