ruby-on-rails – PG:错误关系不存在
发布时间:2020-12-17 02:04:54 所属栏目:百科 来源:网络整理
导读:我正在使用Rails 3.2.x并使用RailsAdmin. 我运行了很多次迁移并多次更改了我的数据库结构.因此,我得到一个PG:错误,表示对于真正不存在的表,不存在关系. 这是错误: ActiveRecord::StatementInvalid at /PG::Error: ERROR: relation "addresses" does not ex
我正在使用Rails 3.2.x并使用RailsAdmin.
我运行了很多次迁移并多次更改了我的数据库结构.因此,我得到一个PG:错误,表示对于真正不存在的表,不存在关系. 这是错误: 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,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,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 我该如何解决? 解决方法
我建议删除并重新创建整个数据库.在执行此操作时,您可能会在迁移过程中遇到一些问题 – 将它们全部修复,以便可以彻底安装应用程序.
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |