值 "329739075321856" 超出类型 integer 的范围

中文讨论区
1

create-nocobase-app 安装方式
sql导入crm,启动后，进入界面，添加便签，出现错误 值 “329739075321856” 超出类型 integer 的范围
image

2025-11-04 19:26:08 [error] response /api/desktopRoutes:create           method=POST path=/api/desktopRoutes:create res=[{"message":"值 \"329738498605056\" 超出类型 integer 的范围"}] action={"actionName":"create","resourceName":"desktopRoutes","params":{"resourceName":"desktopRoutes","actionName":"create","values":{"type":"group","title":"ewr","schemaUid":"pu0jen5grl4"}}} userId=1 username=nocobase status=500 cost=21 app=main reqId=636d387f-b2e5-46cb-9bc8-dd03da62f77c bodySize=81
2

请详细说下操作步骤和执行的命令

3

z505b-bzuda
所有添加页面标签和菜单的地方都有这个错误

4

请详细说下安装的操作步骤和执行的命令 提供下： NocoBase版本 数据库 部署方式

5

crreate app安装方式
yarn create nocobase-app testnocobase -d postgres \ -e DB_HOST=localhost \ -e DB_PORT=5432 \ -e DB_DATABASE=testdb \ -e DB_USER=postgres \e APP_PORT=12800 \ -e DB_PASSWORD=test@88.99 \ -e TZ=Asia/Shanghai

cd testnocobase 
yarn install
yarn nocobase install
yarn start

============启动的时候，会有些错误，主要是一些插件找不到===========
Error: Cannot find plugin ‘@nocobase/plugin-auth-saml’
============以及asyncTasks不存在的错误==========================
original: error: 关系 “asyncTasks” 不存在
at Parser.parseErrorMessage (D:\apps\CRM\nocobase-crm-test\node_modules\pg-protocol\dist\parser.js:285:98)
at Parser.handlePacket (D:\apps\CRM\nocobase-crm-test\node_modules\pg-protocol\dist\parser.js:122:29)
at Parser.parse (D:\apps\CRM\nocobase-crm-test\node_modules\pg-protocol\dist\parser.js:35:38)
at Socket. (D:\apps\CRM\nocobase-crm-test\node_modules\pg-protocol\dist\index.js:11:42)
at Socket.emit (node:events:508:28)
at Socket.emit (node:domain:489:12)
at addChunk (node:internal/streams/readable:559:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
at Readable.push (node:internal/streams/readable:390:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
length: 103,
severity: ‘错误’,
code: ‘42P01’,
detail: undefined,
hint: undefined,
position: ‘18’,
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: ‘parse_relation.c’,
line: ‘1469’,
routine: ‘parserOpenTable’,
sql: SELECT "id" FROM "asyncTasks" AS "asyncTasks" WHERE (("asyncTasks"."status" IN (1, -1) AND "asyncTasks"."doneAt" < '2025-11-05 09:43:21.215 +08:00') OR "asyncTasks"."status" = -2) ORDER BY "asyncTasks"."id" ASC NULLS LAST;,
parameters: undefined
},
====================版本信息如下================
nocobase:v1.9.0-alpha.3
postgresql:18
CRM导入方式：SQL

6

看下官网文档，走升级流程，不走安装流程

1 Like
7

谢谢，升级版本后，数据类型问题已解决，正在尝试升级插件，点赞，感谢