Rails 4.2 engine reference column migration fails PG::UndefinedTable: ERROR: in postgresql -


in engine have built, have 3 classes: books, categories , authors. migrations each of classes below. there 1 many relationship between authors , books , between categories , books. engine namespaces each of classes book_store. when using same migrations on postgresql (instead of sqlite) error 1 of classes not exist pg::undefinedtable: error: relation "authors" not exist

i'm not sure why error occurring. should namespace in reference well? e.g, this:

  t.references :author, index: true, foreign_key: true   t.references :category, index: true, foreign_key: true

to this:

  t.references :book_store_author, index: true, foreign_key: true   t.references :book_store_category, index: true, foreign_key: true

this seems not work because there attribute in bookstore::books named book_store_author , book_store_category resulting in bookstore::books.book_store_author not scoped engine properly.

is possible need change migration code reflect namespace of engine on separate line?

original code

authors

# migration comes book_store (originally 20150814153615) class createbookstoreauthors < activerecord::migration   def change     create_table :book_store_authors |t|       t.string :name       t.text :description       t.string :slug        t.timestamps null: false     end     add_index :book_store_authors, :slug, unique: true   end end

categories

# migration comes book_store (originally 20150814153710) class createbookstorecategories < activerecord::migration   def change     create_table :book_store_categories |t|       t.string :title       t.text :description       t.string :slug        t.timestamps null: false     end     add_index :book_store_categories, :slug, unique: true   end end

books

# migration comes book_store (originally 20150814153733) class createbookstorebooks < activerecord::migration   def change     create_table :book_store_books |t|       t.string :title       t.string :lead       t.text :excerpt       t.text :description       t.decimal :price       t.integer :cover_type       t.integer :num_pages       t.string :isbn       t.integer :year       t.string :buy_link       t.string :size       t.string :cover_image       t.string :slug       t.references :author, index: true, foreign_key: true       t.references :category, index: true, foreign_key: true        t.timestamps null: false     end     add_index :book_store_books, :slug, unique: true   end end

error:

/home/deploy/apps/saturnalia_books/shared/bundle/ruby/2.2.0/gems/activerecord-4.2.3/lib/active_record/migration.rb:797:in `migrate' /home/deploy/apps/saturnalia_books/shared/bundle/ruby/2.2.0/gems/activerecord-4.2.3/lib/active_record/tasks/database_tasks.rb:137:in `migrate' /home/deploy/apps/saturnalia_books/shared/bundle/ruby/2.2.0/gems/activerecord-4.2.3/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>' activerecord::statementinvalid: pg::undefinedtable: error:  relation "authors" not exist : alter table "book_store_books" add constraint "fk_rails_52f80cb3c5" foreign key ("author_id")   references "authors" ("id") /home/deploy/apps/saturnalia_books/shared/bundle/ruby/2.2.0/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `async_exec' /home/deploy/apps/saturnalia_books/shared/bundle/ruby/2.2.0/gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:in `block in execute'      ...    pg::undefinedtable: error:  relation "authors" not exist

edit

here full stack trace

you getting pg::undefinedtable, table author trying reference can't found psql. , couldn't found because table named book_store_authors here create_table :book_store_authors. i'm not sure why working on sqlite, need pass full , valid table name creating model (i mean in singular form if user or in plural if in reason creating users model) t.belongs_to , t.references


-

Comments

Post a Comment

Popular posts from this blog

c# - Binding a comma separated list to a List<int> in asp.net web api -

the default binder in web api expecst http://url.com/webapi/report/?pageids=3243&pageids=2365 to bind public ihttpactionresult report(list<int> pageids){ // exciting webapi code} i wish bind http://url.com/webapi/report/?pageids=3243,2365 as running out of space in url get . i have created class public class commaseparatedmodelbinder : system.web.http.modelbinding.imodelbinder { public bool bindmodel(httpactioncontext actioncontext, modelbindingcontext bindingcontext) { //binding in here } } and registered in webapiconfig.cs var provider = new simplemodelbinderprovider( typeof(list<int>), new commaseparatedmodelbinder()); config.services.insert(typeof(modelbinderprovider), 0, provider); i have altered method signature use model binder so public ihttpactionresult report( [modelbinder] list<int> pageids){ // exciting webapi code} however break point in binder not being
Read more

Delphi 7 and decode UTF-8 base64 -

in delphi 7, have widestring encoded base64(that received web service widestring result) : pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg== when decoded it, result not utf-8: <?xml version="1.0"?> <string>طھط³طھ</string> but when decoded base64decode.org, result true : <?xml version="1.0"?> <string>تست</string> i have use encddecd unit decodestring function. the problem have using decodestring . function, in delphi 7, treats decoded binary data being ansi encoded. , problem text utf-8 encoded. to continue encddecd unit have couple of options. can switch decodestream . instance, code produce utf-8 encoded text file data: {$apptype console} uses classes, encddecd; const data = 'pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg=='; var input: tstringstream; output: tfilestream; begin input := tstringstream.create(data); try output := tfilestream.
Read more

html - Is there any way to exclude a single element from the style? (Bootstrap) -

so, have img logo, overlaid on div styled background-image: url("...") , , both elements inside 2 div classes .to-color , .to-overlay respectively, black transparent overlay. is there way exclude logo style given these 2 classes? here's jsfiddle example: link html , css example: - html - <div class="to-color"> <div class="to-overlay"> <div class="respo"> <div class="row"> <div class="col-xs-4 col-xs-offset-4 text-center"> <img src="http://ansonalex.com/wp-content/uploads/2011/06/google-logo-768x260.png" alt="..." class="img-responsive"> </div> </div> </div> </div> </div> - css - .to-color { background-color: #000; } .to-overlay { opacity : 0.5; } .respo { background-image: url("https://source.unsplash.com/category/objects/1600x900"); background-position: center center;
Read more