API tools faq
paste
Guest User

Untitled

a guest
Nov 22nd, 2018
145
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.78 KB | None | 0 0
raw download clone embed print report
  1. # ruby version: 1.9.3p136
  2. # rails version: 3.2.6
  3. # mysql2 version: 0.3.11
  4.  
  5.  
  6. # User - Schema:
  7. # =============
  8. # Table name: users
  9. #
  10. # id :integer(4) not null, primary key
  11. # mail :string(255) default(""), not null
  12. # encrypted_password :string(128) default(""), not null
  13. # password_salt :string(255) default(""), not null
  14. # remember_token :string(255)
  15. # remember_created_at :datetime
  16. # sign_in_count :integer(4) default(0)
  17. # current_sign_in_at :datetime
  18. # last_sign_in_at :datetime
  19. # current_sign_in_ip :string(255)
  20. # last_sign_in_ip :string(255)
  21. # first_name :string(255)
  22. # last_name :string(255)
  23. # username :string(255) not null
  24. # parent_id :integer(4)
  25. # created_at :datetime
  26. # updated_at :datetime
  27. # client_id :integer(4) not null
  28. # account_id :integer(4)
  29. # account_type :string(255)
  30. # deleted :boolean(1) default(FALSE)
  31. # parent_type :string(255)
  32.  
  33. # Client - Schema
  34. # ===============
  35.  
  36. # == Schema Information
  37. #
  38. # Table name: clients
  39. #
  40. # id :integer(4) not null, primary key
  41. # name :string(255)
  42. # created_at :datetime
  43. # updated_at :datetime
  44. # official_name :string(255)
  45. # uid :string(255)
  46. # short_name :string(255)
  47. #
  48.  
  49. # We updated rails from 3.0.13 to rails 3.2.6. After this update we could't run this comand in the console:
  50.  
  51. User.where(:client_id => client.id)
  52.  
  53. # Here the following error:
  54.  
  55.  
  56. 1.9.3p194 :025 > User.where(:client => Client.first)
  57. Client Load (0.4ms) SELECT `clients`.* FROM `clients` LIMIT 1
  58. User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`client` = 1
  59. Hirb Error: Mysql2::Error: Unknown column 'users.client' in 'where clause': SELECT `users`.* FROM `users` WHERE `users`.`client` = 1
  60. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:243:in `query'
  61. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:243:in `block in execute'
  62. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
  63. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activesupport-3.2.6/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  64. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
  65. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:243:in `execute'
  66. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:211:in `execute'
  67. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:215:in `exec_query'
  68. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:224:in `select'
  69. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all'
  70. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all'
  71. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/querying.rb:38:in `block in find_by_sql'
  72. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/explain.rb:40:in `logging_query_plan'
  73. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/querying.rb:37:in `find_by_sql'
  74. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/relation.rb:171:in `exec_queries'
  75. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/relation.rb:160:in `block in to_a'
  76. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/explain.rb:40:in `logging_query_plan'
  77. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/relation.rb:159:in `to_a'
  78. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/activerecord-3.2.6/lib/active_record/relation/delegation.rb:6:in `to_ary'
  79. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/hirb-0.7.0/lib/hirb/formatter.rb:88:in `Array'
  80. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/hirb-0.7.0/lib/hirb/formatter.rb:88:in `determine_output_class'
  81. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/hirb-0.7.0/lib/hirb/formatter.rb:53:in `format_output'
  82. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/hirb-0.7.0/lib/hirb/view.rb:204:in `render_output'
  83. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/hirb-0.7.0/lib/hirb/view.rb:123:in `view_output'
  84. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/hirb-0.7.0/lib/hirb/view.rb:200:in `view_or_page_output'
  85. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/hirb-0.7.0/lib/hirb/view.rb:186:in `output_value'
  86. /Users/uhumac/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/irb.rb:160:in `block (2 levels) in eval_input'
  87. /Users/uhumac/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/irb.rb:273:in `signal_status'
  88. /Users/uhumac/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/irb.rb:156:in `block in eval_input'
  89. /Users/uhumac/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/irb/ruby-lex.rb:243:in `block (2 levels) in each_top_level_statement'
  90. /Users/uhumac/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/irb/ruby-lex.rb:229:in `loop'
  91. /Users/uhumac/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/irb/ruby-lex.rb:229:in `block in each_top_level_statement'
  92. /Users/uhumac/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/irb/ruby-lex.rb:228:in `catch'
  93. /Users/uhumac/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/irb/ruby-lex.rb:228:in `each_top_level_statement'
  94. /Users/uhumac/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/irb.rb:155:in `eval_input'
  95. /Users/uhumac/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/irb.rb:70:in `block in start'
  96. /Users/uhumac/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/irb.rb:69:in `catch'
  97. /Users/uhumac/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/irb.rb:69:in `start'
  98. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/railties-3.2.6/lib/rails/commands/console.rb:47:in `start'
  99. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/railties-3.2.6/lib/rails/commands/console.rb:8:in `start'
  100. /Users/uhumac/.rvm/gems/ruby-1.9.3-p194@bliss/gems/railties-3.2.6/lib/rails/commands.rb:41:in `<top (required)>'
  101. script/rails:6:in `require'
  102. script/rails:6:in `<main>'
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!