通过SQL导入CRM 模板无效

nocobase版本:1.8.7
PostgreSQL版本:17.5-alpine
已经提前清空数据库进行导入的,导入成功后打开系统提示App error
relation “roles_users_user_id” already exists

image

你好,执行一遍 upgrade 操作再试试呢

还是一样,无解,你能帮我远程处理一下吗?

我也遇到这个问题了,表现一模一样
怎样执行upgrade操作?我是用1panel的应用商店安装的

查看docker日志,有这一条报错
1Panel-nocobase-Lb4b | {“level”:“error”,“message”:“relation "roles_users_user_id" already exists”,“stack”:“Error\n at Query.run (/app/nocobase/node_modules/sequelize/lib/dialects/postgres/query.js:50:25)\n at /app/nocobase/node_modules/sequelize/lib/sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async PostgresQueryInterface.addIndex (/app/nocobase/node_modules/sequelize/lib/dialects/abstract/query-interface.js:250:12)\n at async rolesUsers.sync (/app/nocobase/node_modules/sequelize/lib/model.js:999:7)\n at async _SyncRunner.performSync (/app/nocobase/node_modules/@nocobase/database/lib/sync-runner.js:287:139)\n at async _SyncRunner.runSync (/app/nocobase/node_modules/@nocobase/database/lib/sync-runner.js:90:24)\n at async rolesUsers.sync (/app/nocobase/node_modules/@nocobase/database/lib/model.js:57:12)\n at async Sequelize.sync (/app/nocobase/node_modules/sequelize/lib/sequelize.js:377:9)\n at async _AsyncEmitter.sync (/app/nocobase/node_modules/@nocobase/database/lib/database.js:576:20)\n at async _PluginManager.install (/app/nocobase/node_modules/@nocobase/server/lib/plugin-manager/plugin-manager.js:475:5)\n at async _PresetNocoBase.install (/app/nocobase/node_modules/@nocobase/preset-nocobase/lib/server/index.js:198:5)\n at async _PluginManager.install (/app/nocobase/node_modules/@nocobase/server/lib/plugin-manager/plugin-manager.js:490:7)\n at async _AsyncEmitter.install (/app/nocobase/node_modules/@nocobase/server/lib/application.js:749:5)\n at async _AppCommand. (/app/nocobase/node_modules/@nocobase/server/lib/commands/start.js:66:9)\n at async _AppCommand.parseAsync (/app/nocobase/node_modules/commander/lib/command.js:935:5)\n at async _AsyncEmitter.runAsCLI (/app/nocobase/node_modules/@nocobase/server/lib/application.js:589:23)”,“meta”:{},“module”:“application”,“submodule”:“”,“method”:“”,“app”:“main”,“reqId”:“7f443fd6-4936-473a-a151-8ccc81329b8f”,“dataSourceKey”:“main”,“timestamp”:“2025-07-25 10:00:16”}

我也是,通过1panel面板安装的,就是一直无解,我感觉是SQL文件的问题

饿,我是数据库安装的Mysql,导不进去啊。。建议再出个mysql版的CRM

官方发的数据库是PGSQL的,MYSQL导不进去的

我也是觉得sql文件的问题

我用PostgreSQL,提前清空好数据库了,导入还是没办法使用

顶起来


已解决

(post deleted by author)

您好,请问您怎么解决的?