Forum: Ruby on Rails Listing of Category error

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
85dabd7adebc63dbdae73e5a6ce603db?d=identicon&s=25 haneef5k (Guest)
on 2009-04-24 16:52
(Received via mailing list)
Im trying to see posts index page, In tat im showing category list, im
using collect method it show error..

ActiveRecord::StatementInvalid in Posts#index
Showing app/views/posts/index.html.erb where line #19 raised:

Mysql::Error: Unknown column 'categories_posts.category_id' in 'on
clause': SELECT `categories`.* FROM `categories`  INNER JOIN
`categories_posts` ON `categories`.id =
`categories_posts`.category_id    WHERE ((`categories_posts`.post_id =
1))

Extracted source (around line #19):

16:     <td><%= post.created_at.strftime('%m/%d/%y %I:%m %p') %></td>
17:     <td><%= h(post.title) %></td>
18:     <td><%= h(post.author.display_name) if post.author %></td>
19:     <td><%= post.categories.collect {|cat| [cat.name] }.join(",")
%>
20:     <td><%= h(post.status) %></td>
21:     <td><%= post.comments_count %>

pls help me,, im new to RoR..??
84fbb9c2a7b05c3ddf39904514585a90?d=identicon&s=25 Franco Catena (Guest)
on 2009-04-24 18:13
(Received via mailing list)
You must declare a has_many :categories in the Post model and a
belongs_to :post in the Category model (if the category table has a
post_id column, if not keep reading). If you don't do that, you need
to create a categories_posts table with two columns: category_id and a
post_id.

Regards.

Franco Catena.
85dabd7adebc63dbdae73e5a6ce603db?d=identicon&s=25 haneef5k (Guest)
on 2009-04-24 20:21
(Received via mailing list)
Hi,

Im new to Ror,  i want to do some userful website can u tell me ur
advice and wat steps i should to take basically in Ruby on Rails..??
then im trying to understand tat ( models, controller, action ) it
confusssed..
pls help me..

haneef5k@gmail.com
84fbb9c2a7b05c3ddf39904514585a90?d=identicon&s=25 Franco Catena (Guest)
on 2009-04-24 20:35
(Received via mailing list)
You can read the Agile Web Development With Rails (http://
www.pragprog.com/titles/rails3), is a very good book. It explains step
by step the framework and a very common (but usefull) workflow.

Regards.

Franco Catena.
This topic is locked and can not be replied to.