1

I am on windows xp, with rails 3.1 and i use mysql2 0.2.6 but when i when i try to make a request like:

Product.all

i got this responce:

irb(main):001:0> Product.all ←[1m←[36m (0.0ms)←[0m ←[1mSHOW TABLES←[0m ←[1m←[35m (0.0ms)←[0m describe `products` ArgumentError: wrong number of arguments (3 for 2) from D:/projects/rails/_API/rake/ruby/1.9.1/gems/mysql2-0.2.6-x86-mingw32/lib/active_record/connection_adapters/mysql2_adapter.rb:634:in `select' from D:/projects/rails/_API/rake/ruby/1.9.1/gems/activerecord-3.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all' from D:/projects/rails/_API/rake/ruby/1.9.1/gems/activerecord-3.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all' from D:/projects/rails/_API/rake/ruby/1.9.1/gems/activerecord-3.1.0/lib/active_record/base.rb:470:in `find_by_sql' from D:/projects/rails/_API/rake/ruby/1.9.1/gems/activerecord-3.1.0/lib/active_record/relation.rb:111:in `to_a' from D:/projects/rails/_API/rake/ruby/1.9.1/gems/activerecord-3.1.0/lib/active_record/relation/finder_methods.rb:155:in `all' from D:in `all' from (irb):1 from D:/projects/rails/_API/rake/ruby/1.9.1/gems/railties-3.1.0/lib/rails/commands/console.rb:45:in `start' from D:/projects/rails/_API/rake/ruby/1.9.1/gems/railties-3.1.0/lib/rails/commands/console.rb:8:in `start' from D:/projects/rails/_API/rake/ruby/1.9.1/gems/railties-3.1.0/lib/rails/commands.rb:40:in `<top (required)>' from script/rails:6:in `require' from script/rails:6:in `<main>' 

my controller:

 def index @products = Product.all respond_to do |format| format.html # index.html.erb format.json { render json: @products } end end 

my models :

class Product < ActiveRecord::Base define_index do indexes brand indexes name indexes denomination end end 
2
  • Your controller code is not useful, the migration could be more interesting, also have you tried reset your db? $ rake db:reset, also imho, bad choice windows Commented Oct 6, 2011 at 11:06
  • no actually I don't think the migration could help here... I would try a different combination of gems Commented Oct 6, 2011 at 11:09

1 Answer 1

2

mysql2 0.2.6 isn't compatible with Rails 3.1. You should either downgrade Rails to 3.0.7 or upgrade mysql2 to 0.3.1.

Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.