Role and User models, have HABTM relationship, and role_id, user_id columns musb be on the link table roles_users, but the query do not include JOIN......
On Sep 1, 6:20 pm, Sri Sri <[EMAIL PROTECTED]> wrote: > Sorry I didn't work much on nested and 'craete table'. I directly create > tables in MySQL. > > However I see that you have 'roles_users.user_id' instead of > 'roles.user_id' in the WHERE clause of the SQL. > > andrea wrote: > > I'm running ActiveScaffold 1.2RC1 (from > > git://github.com/activescaffold/active_scaffold.git) > > and Rails 2.1, with MySQL 5.0.51 as the database. I'm having a problem > > select a nested HABTM association; when click on the respective > > column, i have : > > > ---------------------------------------------------------- > > ActiveRecord::StatementInvalid in RolesController#table > > > Mysql::Error: Unknown column 'roles_users.user_id' in 'where clause': > > SELECT DISTINCT `roles`.id FROM `roles` WHERE (roles_users.user_id > > = '1') ORDER BY roles.`id` ASC LIMIT 0, 15 > > Missing JOIN with users table ?? I have the same error on the roles > > table with nested users column. > > ---------------------------------------------------------- > > > class Role < ActiveRecord::Base > > has_and_belongs_to_many :users > > end > > > class User < ActiveRecord::Base > > has_and_belongs_to_many :roles > > end > > > class RolesController < ApplicationController > > active_scaffold :role do |config| > > config.columns = [:name, :users] > > end > > end > > > class UsersController < ApplicationController > > active_scaffold :user do |config| > > config.columns = [:login, :roles] > > end > > end > > > class CreateUsers < ActiveRecord::Migration > > def self.up > > create_table :users do |t| > > t.string :login > > t.timestamps > > end > > create_table :roles_users do |t| > > t.integer :user_id, :role_id, :null => false > > t.timestamps > > end > > end > > > def self.down > > drop_table :users > > end > > end > > > class CreateRoles < ActiveRecord::Migration > > def self.up > > create_table :roles do |t| > > t.string :name > > t.timestamps > > end > > end > > end --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "ActiveScaffold : Ruby on Rails plugin" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/activescaffold?hl=en -~----------~----~----~----~------~----~------~--~---
