Guest User

Untitled

a guest
Mar 2nd, 2018
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.38 KB | None | 0 0
  1. c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_
  2. adapters/abstract_adapter.rb:128:in `log': Mysql::Error: Unknown column 'message
  3. s.member_id' in 'where clause': SELECT * FROM messages WHERE (messages.member_id
  4. = 3) LIMIT 1 (ActiveRecord::StatementInvalid)
  5. from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_recor
  6. d/connection_adapters/mysql_adapter.rb:243:in `execute'
  7. from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_recor
  8. d/connection_adapters/mysql_adapter.rb:399:in `select'
  9. from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_recor
  10. d/connection_adapters/abstract/database_statements.rb:7:in `select_all'
  11. from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_recor
  12. d/base.rb:427:in `find_by_sql'
  13. from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_recor
  14. d/base.rb:997:in `find_every'
  15. from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_recor
  16. d/base.rb:991:in `find_initial'
  17. from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_recor
  18. d/base.rb:417:in `find'
  19. from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_recor
  20. d/associations/has_one_association.rb:60:in `find_target'
  21. from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_recor
  22. d/associations/association_proxy.rb:131:in `load_target'
  23. from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_recor
  24. d/associations/has_one_association.rb:29:in `replace'
  25. from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_recor
  26. d/associations.rb:908:in `message='
  27. from ActiveRecord_test.rb:25
  28.  
  29.  
  30. All of that is generated from this innocent coe
  31.  
  32. require 'rubygems'
  33. require 'mysql'
  34. require_gem 'activerecord'
  35. puts Mysql::VERSION
  36.  
  37. ActiveRecord::Base.establish_connection(
  38. :adapter => "mysql",
  39. :host => "localhost",
  40. :database => "gassms",
  41. :username => "gasser",
  42. :password => "sms")
  43.  
  44. class Member < ActiveRecord::Base
  45. has_one :message
  46. end
  47.  
  48. class Message < ActiveRecord::Base
  49. belongs_to :member, :class_name => "Member", :foreign_key => "recieving_member"
  50. end
  51.  
  52. a_student = Member.find(3)
  53. puts a_student.phone.to_s
  54. puts a_student.firstname.to_s
  55.  
  56. a_student.message = Message.new(:modul1 => "fri i idræt", :text => "Naaaajs")
  57. a_student.save
Add Comment
Please, Sign In to add comment