部署环境:debian12
部署方式:docker
系统版本:latest v1.2.28-alpha + PostgreSQL16
问题:在表格导入数据失败后,在表单提交数据报“Invalid value {}”,数据项全部写满也会出现这个报错,测试其他表单正常,自由导入数据的表单不正常,删除表全部数据,问题依旧;
日志附在评论区
{“level”:“error”,“message”:“failed to import row 2, "2023ftxm_xmnf_2023" is not a valid option in ftxm_xmnf field., rowData: {"id":"1","ftxm_ymjl_wj":null,"ftxm_ymsw_wj":null,"ftxm_xmbh":"DZ151.043","ftxm_xmmc":"上思县法院融合法庭项目"}”,“meta”:{“err”:“Error: failed to import row 2, "2023ftxm_xmnf_2023" is not a valid option in ftxm_xmnf field., rowData: {"id":"1","ftxm_ymjl_wj":null,"ftxm_ymsw_wj":null,"ftxm_xmbh":"DZ151.043","ftxm_xmmc":"上思县法院融合法庭项目"}\n at XlsxImporter.performImport (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/services/xlsx-importer.js:158:17)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async XlsxImporter.run (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/services/xlsx-importer.js:59:24)\n at async importXlsxAction (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/actions/import-xlsx.js:71:25)\n at async importXlsx (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/actions/import-xlsx.js:87:5)\n at async middleware (/app/nocobase/node_modules/@nocobase/plugin-workflow-action-trigger/dist/server/ActionTrigger.js:59:5)\n at async dataTemplate (/app/nocobase/node_modules/@nocobase/server/lib/middlewares/data-template.js:36:3)\n at async app.acl.use.after (/app/nocobase/node_modules/@nocobase/plugin-acl/dist/server/server.js:502:9)\n at async middlewares.add.tag (/app/nocobase/node_modules/@nocobase/acl/lib/acl.js:383:9)\n at async /app/nocobase/node_modules/@nocobase/acl/lib/allow-manager.js:108:7”,“cause”:{}},“module”:“ftxmgl”,“submodule”:“importXlsx”,“method”:“error-handler”,“app”:“main”,“reqId”:“f60f7b52-5289-44ba-ab4b-38174f746b24”,“dataSourceKey”:“main”,“timestamp”:“2024-08-06 01:19:01”}
{“level”:“error”,“message”:“"2023ftxm_xmnf_2023" is not a valid option in ftxm_xmnf field.”,“stack”:"Error: "2023ftxm_xmnf_2023" is not a valid option in ftxm_xmnf field.\n at _SelectInterface.toValue
{“level”:“error”,“message”:“failed to import row 2, Invalid value {}, rowData: {"ftxm_xmbh":"DZ151.043","ftxm_xmmc":null,"ftxm_xmnf":null,"ftxm_xmje":null,"ftxm_cjms":null,"ftxm_xmdj":null,"ftxm_fymc":null,"ftxm_xmqy":null,"ftxm_lxsj":null,"ftxm_ftlx":null,"ftxm_ftsl":null,"ftxm_jfjd":null,"ftxm_ysjd":null,"ftxm_jhys":null,"ftxm_yssj":null,"ftxm_ysys":null,"ftxm_ymbz":null,"ftxm_htjd":null,"ftxm_jfsj":null,"ftxm_ymjl":null,"ftxm_ymsw":null,"ftxm_xmwz":null,"ftxm_fwsmc":null}”,“meta”:{“err”:“Error: failed to import row 2, Invalid value {}, rowData: {"ftxm_xmbh":"DZ151.043","ftxm_xmmc":null,"ftxm_xmnf":null,"ftxm_xmje":null,"ftxm_cjms":null,"ftxm_xmdj":null,"ftxm_fymc":null,"ftxm_xmqy":null,"ftxm_lxsj":null,"ftxm_ftlx":null,"ftxm_ftsl":null,"ftxm_jfjd":null,"ftxm_ysjd":null,"ftxm_jhys":null,"ftxm_yssj":null,"ftxm_ysys":null,"ftxm_ymbz":null,"ftxm_htjd":null,"ftxm_jfsj":null,"ftxm_ymjl":null,"ftxm_ymsw":null,"ftxm_xmwz":null,"ftxm_fwsmc":null}\n at XlsxImporter.performImport (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/services/xlsx-importer.js:158:17)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async XlsxImporter.run (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/services/xlsx-importer.js:59:24)\n at async importXlsxAction (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/actions/import-xlsx.js:71:25)\n at async importXlsx (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/actions/import-xlsx.js:87:5)\n at async middleware (/app/nocobase/node_modules/@nocobase/plugin-workflow-action-trigger/dist/server/ActionTrigger.js:59:5)\n at async dataTemplate (/app/nocobase/node_modules/@nocobase/server/lib/middlewares/data-template.js:36:3)\n at async app.acl.use.after (/app/nocobase/node_modules/@nocobase/plugin-acl/dist/server/server.js:502:9)\n at async middlewares.add.tag (/app/nocobase/node_modules/@nocobase/acl/lib/acl.js:383:9)\n at async /app/nocobase/node_modules/@nocobase/acl/lib/allow-manager.js:108:7”,“cause”:{}},“module”:“ftxmgl”,“submodule”:“importXlsx”,“method”:“error-handler”,“app”:“main”,“reqId”:“71405e77-87d5-47ca-97ff-07267c3390f8”,“dataSourceKey”:“main”,“timestamp”:“2024-08-06 01:30:26”}
{“level”:“error”,“message”:“Invalid value {}”,“stack”:"Error: Invalid value {}\n at Object.escape (/app/nocobase/node_modules/sequelize/lib/sql-string.js:53:11)\n at
你看一下,你输入的数据内容是不是和你设置的数据表的字段的要求不符合啊。
那应该不会出错啊。
很抱歉,我没办法了。
好的,感谢,我也没有想明白,我新建一张表复现之前的操作,发现也没有办法复现了;