我正在使用Rails 3.2.x,并且也在使用RailsAdmin。
我运行了许多迁移并多次更改了我的数据库结构。由此导致的问题是,我收到了PG:Error错误,该错误表示表不存在于关系中,但实际上该表确实不存在。
这是错误信息:
我运行了许多迁移并多次更改了我的数据库结构。由此导致的问题是,我收到了PG:Error错误,该错误表示表不存在于关系中,但实际上该表确实不存在。
这是错误信息:
ActiveRecord::StatementInvalid at /
PG::Error: ERROR: relation "addresses" does not exist
LINE 5: WHERE a.attrelid = '"addresses"'::regclass
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
简而言之,当我访问/admin
时,在我的development.log文件中显示的错误如下:
Started GET "/admin" for 127.0.0.1 at 2013-07-04 02:24:07 -0500
Processing by RailsAdmin::MainController#dashboard as HTML
Cart Load (0.5ms) SELECT "carts".* FROM "carts" WHERE "carts"."id" = $1 LIMIT 1 [["id", 5]]
User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
(0.6ms) SELECT COUNT(*) FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 1 AND (((roles.name = 'admin') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL)))
(0.6ms) SELECT COUNT(*) FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 1 AND (((roles.name = 'seller') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL)))
PG::Error: ERROR: relation "addresses" does not exist
LINE 5: WHERE a.attrelid = '"addresses"'::regclass
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"addresses"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Completed 500 Internal Server Error in 1269ms
ActiveRecord::StatementInvalid - PG::Error: ERROR: relation "addresses" does not exist
LINE 5: WHERE a.attrelid = '"addresses"'::regclass
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"addresses"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
我该怎么解决这个问题?
addresses
表缺失,但我无法确定原因是什么。就像你所说的,迁移出现了混乱。 - Mike Szyndel