Edit Question - KnowledgeHub

Title Body

Alright, so here's the deal. I have two tables and a join table since it's a many-to-many relationship. I have an order and an order can have many products. Obviously it goes the other way since products can be on many orders. I've got the following classes: class Order < ActiveRecord::Base has_many :orders_products has_many :products, :through => :orders_products end class OrderProduct < ActiveRecord::Base belongs_to :order belongs_to :product end class Product < ActiveRecord::Base has_many :orders_products has_many :orders, :through => :orders_products end I'm getting a page to display and I'm able to enter stuff and when I go to interact with the products on the saved order via @order.products I'm getting the following error: SQLite3::SQLException: no such table: order_products: SELECT "products".* FROM "products" INNER JOIN "order_products" ON "products".id = "order_products".product_id WHERE (("order_products".order_id = 1)) My join table is named orders_products , but as you can see it's trying to join through order_products . My limited knowledge of Rails naming conventions tells me that orders_products is the correct way to name it, and then name my model as OrderProduct . I'm really pounding my head against a wall on this one. EDIT: I see that even though it saved my order it and I selected multiple checkboxes it did not save any values in the orders_products table, presumably for the same reason as it is erroring now.

Tags (comma-separated) Cancel