Hi All
I have a User model with the following definition:
fields do
name :string
email_address :email_address, :unique, :login => true
administrator :boolean, :default => false
sponsor_code :string, :unique
paypal_email :email_address
minimum_amount :decimal
timestamps
end
has_many :subscribers
has_many :commission_paids
has_many :affiliates, :class_name => 'User', :foreign_key =>
'enroller_id'
belongs_to :enroller , :class_name => 'User'
The problem is with has_many affiliates.
In my cucumber test I have the lines
user1 = User.find_by_email_address(email1)
raise "User #{email1} is not in the database" if user1 == nil
user2 = User.find_by_email_address(email2)
raise "User #{email2} is not in the database" if user2 == nil
raise "No link between users" unless user1.affiliates.include?
(user2)
The last line causes a MySql exception:
Mysql::Error: Unknown column 'users.enroller_id' in 'where
clause': SELECT `users`.id FROM `users` WHERE (`users`.`id` = 13) AND
(`users`.enroller_id = -616251098) LIMIT 1
(ActiveRecord::StatementInvalid)
features/affiliates.feature:167:in `Then the database record for
"[email protected]" should contain a link to "[email protected]"'
enroller_id does appear in the users table
Am I missing something in my definition to link enroller_id with
affiliates? Or is this a bug?
Any help greatfully received!
Cheers
Geoff
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Hobo
Users" 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/hobousers?hl=en
-~----------~----~----~----~------~----~------~--~---
