9Bopper-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
2007-Apr-23 01:03 UTC
Unknown column ''role'' in field list
Hello, I''ve added the field ''admin'' to my users database. When I did this, my unit tests broke with an error similar to this one for every test: ActiveRecord::StatementInvalid: Mysql::Error: Unknown column ''role'' in ''field list'': INSERT INTO users (`salt`, `hashed_password`, `role`, `id`, `login`, `email`) VALUES (1000, ''00728d3362c26746ec25963f71be022b152237a9'', ''admin'', 1000003, ''longbob'', ''lbob-pbC8P9QkocYAvxtiuMwx3w@public.gmane.org'') I''ve also tried to edit other databases with similar errors. Since I first edited the DB, I reverted the schema and then tried to change the DB using migrations. I still get the same error. I was under the impression, though, that one could add columns to the DB, and ActiveRecord would make these colums available to the model. Any help would be appreciated. Thanks, Kyle Lape --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Spinoffs" group. To post to this group, send email to rubyonrails-spinoffs-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-spinoffs-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-spinoffs?hl=en -~----------~----~----~----~------~----~------~--~---