Jesper,
Have you tried running the tests that come with the adapter_extensions plugin? Those were the same tests that I was running, so maybe that might help us identify the difference that is causing the problem. Let me know if you need help running the tests. Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jesper Rønn-Jensen Sent: Wednesday, February 20, 2008 3:27 AM To: activewarehouse-discuss@rubyforge.org Subject: Re: [Activewarehouse-discuss] Fwd: problems using bulk_import (to mysql on win xp) Hi Paul Thanks for putting effort into this strange weird behaviour. The change you suggest, however, makes no difference for me. I still get the same error. I'm including stack trace below signature. /Jesper On Feb 20, 2008 8:51 AM, Paul Cortens wrote: I think I have made some progress. I added one line to mysql_adapter.rb in the adapter extensions plugin: + @connection = Mysql.new([EMAIL PROTECTED]) -- ___________________________________________________________ Jesper Rønn-Jensen / Capgemini Denmark Tel. +45 3977 8220 / Mob. +45 2373 6220 / Fax +45 7011 2201 www.dk.capgemini.com / Blog http://justaddwater.dk/ ___________________________________________________________ Executing screens Screens passed Executing post processes c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:150:in `log': Mysql::Error: #42000The used command is not allowed with this MySQL version: LOAD DATA LOCAL INFILE 'C:/Documents and Settings/Administrator/My Documents/rails/ourpeople/import/output/employees.out.txt' INTO TABLE employees FIELDS TERMINATED BY ',' ENCLOSED BY '"' IGNORE 1 LINES (id,cgid,longid,firstname,lastname,displayname,middleinitial,initials,phone,mobile,fax,subcellphone,email,englishtitle,localtitle,secretary_id,mentor_id,substitute_id,manager_id,comment,licenseplate,employment_cgemployee,employment_cgexternal,employment_cgtemporary,employeework_employeeid,employeework_workpercentage,employeework_actualworkpercentage,company_id,grade_id,location_id,organisation_id,profession_id,resourcetype_id,skillsunit_id,staffingunit_id) (ActiveRecord::StatementInvalid) from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:281:in `execute' from c:/ruby/lib/ruby/gems/1.8/gems/adapter_extensions-0.4.0/lib/adapter_extensions/connection_adapters/mysql_adapter.rb:49:in `do_bulk_load' from c:/ruby/lib/ruby/gems/1.8/gems/adapter_extensions-0.4.0/lib/adapter_extensions/connection_adapters/abstract_adapter.rb:18:in `bulk_load' from c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib/etl/processor/bulk_import_processor.rb:73:in `process' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction' from c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib/etl/processor/bulk_import_processor.rb:62:in `process' from c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib/etl/engine.rb:485:in `post_process' from c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib/etl/engine.rb:484:in `each' ... 13 levels... from c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:496:in `require' from c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/etl:28 from c:/ruby/bin/etl:19:in `load' from c:/ruby/bin/etl:19
_______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
