Geof, Is the neroller_id column present in the users table?
Regards, Tiago Franco On Jul 6, 6:32 am, geoffd123 <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
