SequelizeDatabaseError after deplying nodejs app to heroku

Question

我有一个用nodejs编写的电子商务应用程序。我最近将我的应用程序部署到 heroku..以下是配置：

开发模式：

database: mysql

生产模式

database: postgresql add-on

部署成功完成，我已经运行了 heroku 运行 bash 命令，然后是续集 -m commmand。之后，我完成了 db：migrate 并且所有迁移都成功完成了。但是当我尝试搜索路由时，我在许多路由上都出现错误。但是每个路由都有相似之处。

例如：这是我在创建用户路由时得到的响应。

"name": "SequelizeDatabaseError",
"parent": {
"name": "error",
"length": 105,
"severity": "ERROR",
"code": "42703",
"position": "47",
"file": "parse_relation.c",
"line": "3294",
"routine": "errorMissingColumn",
"sql": "SELECT "id", "username", "email", "password", "image", "createdAt", "updatedAt" FROM "Users" AS "User" WHERE "User"."email" = '[e-mail]' LIMIT 1;"
},
"original": {
"name": "error",
"length": 105,
"severity": "ERROR",
"code": "42703",
"position": "47",
"file": "parse_relation.c",
"line": "3294",
"routine": "errorMissingColumn",
"sql": "SELECT "id", "username", "email", "password", "image", "createdAt", "updatedAt" FROM "Users" AS "User" WHERE "User"."email" = '[e-mail]' LIMIT 1;"
},
"sql": "SELECT "id", "username", "email", "password", "image", "createdAt", "updatedAt" FROM "Users" AS "User" WHERE "User"."email" = '[e-mail]' LIMIT 1;"
}

Answer 1

您能否为两个环境使用相同的数据库，并更新它是否适用于您的本地。