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
-~----------~----~----~----~------~----~------~--~---