错误 #19268
库存盘点:新建盘点单,提示“盘点单新增失败!”
0%
描述
测试步骤:
1、测试账号lxc/123qwe123,项目“归零测试目”,库存系统,库存盘点;
2、新建盘点单,盘点仓库选择“0712新仓库”,其他项正常有效设置;
3、点击确定,观察响应
实际结果:
新增盘点单失败,
addInventoryStockTakingDto报错,{"Reason":"\n### Error updating database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'create_time' in 'field list'\n### The error may exist in com/persagy/mapper/CommonMapper.java (best guess)\n### The error may involve com.persagy.mapper.CommonMapper.insert-Inline\n### The error occurred while setting parameters\n### SQL: insert into test_inventory
.inventory_stock_taking
(order_no
,create_time
,group_code
,operate_id
,is_delete
,order_name
,valid
,start_time
,operate_name
,update_time
,stock_taking_head
,project_id
,stock_taking_person
,inventory_stock_taking_id
,warehouse_id
,status
) values ('PD2022071200010','20220712160244','YL','RY1438045894120951810','0','0712盘点单',true,'20220712160244','刘技术员','20220712160244','RY1438045894120951810','Pj1101101101','RY1438045894120951810','PD1101101101e64e0e7eb90c43aa9188544a4bcaaf10','CK1101101101c2f40a13a896454dae1a054be5a90bd1','2');\n### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'create_time' in 'field list'\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'create_time' in 'field list'","Result":"failure"}
期望结果:
成功新增盘点单
详情见附件截图
文件