I posted this in the Ruby forum but I was told it would be more at home
here.
I''m very new to ruby so for all I know this could be ridiculously easy.
Thank you in advance for any and all suggestions!
Here is the error:
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:2962:in
`log_protected_attribute_removal'': undefined method `debug''
for
nil:NilClass (NoMethodError)
from
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:2946:in
`remove_attributes_protected_from_mass_assignment''
from
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:2739:in
`attributes=''
from
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:2439:in
`initialize''
from
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:726:in
`new''
from
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:726:in
`create''
from ./read_categories.rb:42
from
/home/emergenc/RubyGems/gems/parseexcel-0.5.2/lib/parseexcel/worksheet.rb:143:in
`each''
from
/home/emergenc/RubyGems/gems/parseexcel-0.5.2/lib/parseexcel/worksheet.rb:143:in
`each''
from ./read_categories.rb:41
When I traced it in the code this error is what would be displayed if
that debug undefined method error wasn''t there:
"WARNING: Can''t mass-assign these protected attributes:
#{attributes.join('', '')}"
Here is the relevant code:
#!/usr/bin/ruby
ENV[''GEM_PATH''] =
''/home/emergenc/RubyGems:/usr/lib/ruby/gems/1.8''
require ''rubygems'';
require ''parseexcel''
require ''net/ftp''
require ''activerecord''
require ''csv''
#Make Database Connection
ActiveRecord::Base.establish_connection(:adapter=>"mysql",:host=>"localhost",:username=>"xxxxxxx",:password=>"xxxxx",:database=>"e_shop")
class Category < ActiveRecord::Base
end
class Subcategory < ActiveRecord::Base
end
class Item < ActiveRecord::Base
end
#Open the excel file
cat_worksheet
Spreadsheet::ParseExcel.parse("/home/emergenc/DataFiles/categories.xls").worksheet(0)
subcat_worksheet
Spreadsheet::ParseExcel.parse("/home/emergenc/DataFiles/subcategories.xls").worksheet(0)
#Delete Currently Existing Data
Category.connection.execute("TRUNCATE TABLE categories")
Subcategory.connection.execute("TRUNCATE TABLE subcategories")
Item.connection.execute("TRUNCATE TABLE items")
(I CUT OUT IRRELEVANT CODE, LINE 39 Starts with #LOAD, LINE 40 starts
with cat_w..., and LINE 41 starts with Category.create to map from the
error message)
#Load Category Data
cat_worksheet.each(1) do |row|
Category.create(:description=>(row.at(1).to_s(''latin1'')).split(/\s+/).each{
|word| word.capitalize! }.join('' ''), :id =>
row.at(0).to_s(''latin1''))
unless row.nil?
end
Category.connection.execute("UPDATE categories c SET grouping_id (SELECT
max(id) FROM groupings g where lower(c.description) like
concat(''%'',lower(g.description),''%''))")
Category.connection.execute("UPDATE categories c SET grouping_id (SELECT
grouping_id FROM grouping_overrides g where c.description g.category_desc) WHERE
grouping_id is nul$
Category.connection.execute("UPDATE categories c SET grouping_id (SELECT id
FROM groupings g where g.description = ''Other Items'') where
grouping_id is null")
--
Posted via http://www.ruby-forum.com/.