Error accessing db through model - Rails 2.2.2, MySql 5.1.30

rubyonrails-talk
1

Folks,

I just installed Rails 2.2.2 on my box and MySql 5.1.30. Running a simple <Model>.find(:all) gives me a bunch of errors - snippet below. The only answer I have found in searching around is to go back to an older version of MySql. Is there any way to fix this or do I really have to revert the MySql version?

Meal.find(:all)

ArgumentError: NULL pointer given         from (eval):3:in `each_hash'         from (eval):3:in `all_hashes'         from C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record /connection_adapters/mysql_adapter.rb:564:in `select'         from C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record /connection_adapters/abstract/database_statements.rb:7:in `select_all_without_qu ery_cache'

Thanks for your help.

-S

2

Have you created the database and migrated?

3

Is it possible that you need to re-install the mysql gem? I think you said you upgraded MySQL but you didn't say from what version. I know the mysql gem includes a C component that hooks in to the MySQL library, this might be the source of your problem.