What is the primary key in the Product table? Is it 'id' or something else?
On May 4, 11:40 am, Shane Corbin <[email protected]> wrote: > Problem > --------- > ActiveRecord appears to be failing on my Windows install > > Setup > --------- > I have MySql version 5.0.51 running on a debian box, let's call it (A) > I have Ruby w/ the ActiveRecord gem installed on an ubuntu box, let's > call it (B) > I have Ruby w/ the ActiveRecord and mysql gems installed on a Windows > box, let's call it (C) > > Scenario > --------- > I have a simple table named 'Software' in a database named 'master' on > (A). > > I have written a dirt simple script to show me all of the records in the > 'Software' table. > > Here it is: > <code> > require 'rubygems' > require 'activerecord' > require 'pp' > > class Software < ActiveRecord::Base > set_table_name "Product" # Not "Softwares" > end > > ActiveRecord::Base.establish_connection( > :host => "deb", > :adapter => "mysql", > :database => "master", > :username => "username", # this is not my real username > :password => "password", # this is not my real password > :autocommit => true > ) > > pp Software.find(:all) > </code> > > (B) executes properly without any problems, however (C) fails to execute > with the following dump... > > <code> > (eval):3:in `each_hash': NULL pointer given (ArgumentError) > from (eval):3:in `all_hashes' > from > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/mysql_adapter.rb:596:in > `select' > from > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in > `select_all_without_query_cache' > from > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/query_cache.rb:62:in > `select_all' > from > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:661:in > `find_by_sql' > from > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1553:in > `find_every' > from > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:615:in > `find' > from > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1905:in > `find_all_by_Product_Name' > from > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1890:in > `send' > from > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1890:in > `method_missing' > from simpleConnectMySql.rb:24 -- this is my simple script > </code> > > Any help would be greatly appreciated. Like I said I'm new to this > ActiveRecord stuff, so it could be a very simple problem. I'm just > confused because it works perfectly on my ubuntu machine (B). > > Thanks guys! > -- > Posted viahttp://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
