Skip to content

Instantly share code, notes, and snippets.

@ivanoats
Created May 20, 2011 21:42
Show Gist options
  • Save ivanoats/983886 to your computer and use it in GitHub Desktop.
Save ivanoats/983886 to your computer and use it in GitHub Desktop.
refinery install error
ivan:~/Development/ruby/testcms [git:master?] → rails generate refinerycms_blog
create db/migrate/20110520213837_create_blog_structure.rb
create db/migrate/20110520213838_add_user_id_to_blog_posts.rb
create db/seeds/refinerycms_blog.rb
------------------------
Now run:
rake db:migrate
------------------------
ivan:~/Development/ruby/testcms [git:master?] → rake db:migrate
(in /Users/ivan/Development/ruby/testcms)
== CreateBlogStructure: migrating ============================================
-- create_table(:blog_posts, {:id=>true})
-> 0.0029s
-- add_index(:blog_posts, :id)
-> 0.0011s
-- create_table(:blog_comments, {:id=>true})
-> 0.0024s
-- add_index(:blog_comments, :id)
-> 0.0008s
-- create_table(:blog_categories, {:id=>true})
-> 0.0014s
-- add_index(:blog_categories, :id)
-> 0.0007s
-- create_table(:blog_categories_blog_posts, {:id=>false})
-> 0.0010s
-- add_index(:blog_categories_blog_posts, [:blog_category_id, :blog_post_id], {:name=>"index_blog_categories_blog_posts_on_bc_and_bp"})
-> 0.0014s
rake aborted!
An error has occurred, this and all later migrations canceled:
SQLite3::ConstraintException: columns user_id, name are not unique: INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinerycms_blog', 15)
(See full trace by running task with --trace)
ivan:~/Development/ruby/testcms [git:master?] → rake db:migrate --trace
(in /Users/ivan/Development/ruby/testcms)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
== CreateBlogStructure: migrating ============================================
-- create_table(:blog_posts, {:id=>true})
-> 0.0030s
-- add_index(:blog_posts, :id)
-> 0.0012s
-- create_table(:blog_comments, {:id=>true})
-> 0.0022s
-- add_index(:blog_comments, :id)
-> 0.0008s
-- create_table(:blog_categories, {:id=>true})
-> 0.0013s
-- add_index(:blog_categories, :id)
-> 0.0007s
-- create_table(:blog_categories_blog_posts, {:id=>false})
-> 0.0009s
-- add_index(:blog_categories_blog_posts, [:blog_category_id, :blog_post_id], {:name=>"index_blog_categories_blog_posts_on_bc_and_bp"})
-> 0.0009s
rake aborted!
An error has occurred, this and all later migrations canceled:
SQLite3::ConstraintException: columns user_id, name are not unique: INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinerycms_blog', 15)
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/connection_adapters/abstract_adapter.rb:207:in `rescue in log'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/connection_adapters/abstract_adapter.rb:199:in `log'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/connection_adapters/sqlite_adapter.rb:135:in `execute'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/connection_adapters/abstract/database_statements.rb:282:in `insert_sql'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/connection_adapters/sqlite_adapter.rb:149:in `insert_sql'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/connection_adapters/abstract/query_cache.rb:16:in `insert'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/arel-2.0.9/lib/arel/select_manager.rb:217:in `insert'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/relation.rb:14:in `insert'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/persistence.rb:270:in `create'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/timestamp.rb:47:in `create'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/callbacks.rb:277:in `block in create'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activesupport-3.0.7/lib/active_support/callbacks.rb:414:in `_run_create_callbacks'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/callbacks.rb:277:in `create'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/persistence.rb:246:in `create_or_update'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/callbacks.rb:273:in `block in create_or_update'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activesupport-3.0.7/lib/active_support/callbacks.rb:419:in `_run_save_callbacks'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/callbacks.rb:273:in `create_or_update'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/persistence.rb:39:in `save'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/validations.rb:43:in `save'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/attribute_methods/dirty.rb:21:in `save'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/transactions.rb:240:in `block (2 levels) in save'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/transactions.rb:292:in `block in with_transaction_returning_status'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/connection_adapters/abstract/database_statements.rb:139:in `transaction'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/transactions.rb:207:in `transaction'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/transactions.rb:290:in `with_transaction_returning_status'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/transactions.rb:240:in `block in save'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/transactions.rb:251:in `rollback_active_record_state!'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/transactions.rb:239:in `save'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/associations/association_collection.rb:273:in `block in create'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/associations/association_collection.rb:503:in `block in create_record'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/associations/association_collection.rb:480:in `add_record_to_target_with_callbacks'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/associations/association_collection.rb:503:in `create_record'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/associations/association_collection.rb:271:in `create'
/Users/ivan/Development/ruby/testcms/db/seeds/refinerycms_blog.rb:2:in `block in <top (required)>'
/Users/ivan/Development/ruby/testcms/db/seeds/refinerycms_blog.rb:1:in `each'
/Users/ivan/Development/ruby/testcms/db/seeds/refinerycms_blog.rb:1:in `<top (required)>'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activesupport-3.0.7/lib/active_support/dependencies.rb:235:in `load'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activesupport-3.0.7/lib/active_support/dependencies.rb:235:in `block in load'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activesupport-3.0.7/lib/active_support/dependencies.rb:225:in `block in load_dependency'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activesupport-3.0.7/lib/active_support/dependencies.rb:596:in `new_constants_in'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activesupport-3.0.7/lib/active_support/dependencies.rb:225:in `load_dependency'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activesupport-3.0.7/lib/active_support/dependencies.rb:235:in `load'
/Users/ivan/Development/ruby/testcms/db/migrate/20110520213837_create_blog_structure.rb:40:in `up'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/migration.rb:312:in `block in migrate'
/Users/ivan/.rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/benchmark.rb:294:in `measure'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/migration.rb:312:in `migrate'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/migration.rb:395:in `migrate'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/migration.rb:537:in `block (2 levels) in migrate'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/migration.rb:611:in `call'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/migration.rb:611:in `block in ddl_transaction'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/connection_adapters/abstract/database_statements.rb:139:in `transaction'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/transactions.rb:207:in `transaction'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/migration.rb:611:in `ddl_transaction'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/migration.rb:536:in `block in migrate'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/migration.rb:523:in `each'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/migration.rb:523:in `migrate'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/migration.rb:433:in `up'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/migration.rb:415:in `migrate'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.7/lib/active_record/railties/databases.rake:142:in `block (2 levels) in <top (required)>'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:636:in `call'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:636:in `block in execute'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:631:in `each'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:631:in `execute'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:597:in `block in invoke_with_call_chain'
/Users/ivan/.rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:583:in `invoke'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2029:in `block (2 levels) in top_level'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2029:in `each'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2029:in `block in top_level'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2001:in `block in run'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/bin/rake:31:in `<top (required)>'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/bin/rake:19:in `load'
/Users/ivan/.rvm/gems/ruby-1.9.2-p180/bin/rake:19:in `<main>'
ivan:~/Development/ruby/testcms [git:master?] →
ivan:~/Development/ruby/testcms [git:master?] → sqlite3 db/development.sqlite3
SQLite version 3.7.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .dump user_plugins
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE "user_plugins" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "name" varchar(255), "position" integer);
INSERT INTO "user_plugins" VALUES(18,1,'refinery_dashboard',0);
INSERT INTO "user_plugins" VALUES(19,1,'refinery_files',1);
INSERT INTO "user_plugins" VALUES(20,1,'refinery_images',2);
INSERT INTO "user_plugins" VALUES(21,1,'refinery_pages',3);
INSERT INTO "user_plugins" VALUES(22,1,'refinery_settings',4);
INSERT INTO "user_plugins" VALUES(23,1,'refinery_users',5);
INSERT INTO "user_plugins" VALUES(24,1,'refinerycms_base',6);
INSERT INTO "user_plugins" VALUES(25,1,'refinery_core',7);
INSERT INTO "user_plugins" VALUES(26,1,'refinery_dialogs',8);
INSERT INTO "user_plugins" VALUES(27,1,'refinery_i18n',9);
INSERT INTO "user_plugins" VALUES(28,1,'refinery_generators',10);
INSERT INTO "user_plugins" VALUES(29,1,'refinery_inquiries',11);
INSERT INTO "user_plugins" VALUES(30,1,'portfolio',12);
INSERT INTO "user_plugins" VALUES(31,1,'refinerycms_theming_plugin',13);
INSERT INTO "user_plugins" VALUES(32,1,'refinerycms_blog',14);
CREATE INDEX "index_user_plugins_on_title" ON "user_plugins" ("name");
CREATE UNIQUE INDEX "index_unique_user_plugins" ON "user_plugins" ("user_id", "name");
COMMIT;
sqlite>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment