That was it. I was using the ruby version. Once I installed the win32 version it works.
THANK YOU!!!! Paul -----Original Message----- From: Chris Williams [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 6:01 PM To: Paul Cortens Subject: Re: [Activewarehouse-discuss] Newbie needs help! Which MySQL gem are you using? I think you want to make sure you are using the win32 version, not the ruby version. On Dec 13, 2007 8:05 PM, Paul Cortens <[EMAIL PROTECTED]> wrote: > Thanks. If I add "LINES TERMINATED BY '\r\n'" to the MySQL query, then I > don't have the line break problem. But I am still stuck as to why > ActiveWarehouse chokes, but I can manually run the exact same SQL code > through MySQL manually. > > Cheers, > Paul > > > -----Original Message----- > From: Chris Williams [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 13, 2007 3:46 PM > To: Paul Cortens > Subject: Re: [Activewarehouse-discuss] Newbie needs help! > > Hi Paul. I ran in to some of the same problems when running on > Windows. I went through some of my old posts to the list but can't > find exactly what I did. I know I made some code changes to AW in > order to get rid of the \n in the last field in the CSV file. I will > keep searching and see if I can help out at all. > > Chris > > On Dec 13, 2007 6:29 PM, Paul Cortens <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Hi, > > > > I have been trying to work through the tutorial posted > here, > > and I haven't been having much luck. > > > > > > > > > > > > When I try to run author_dimension.ctl I get the following error. > > > > > > > > ****************** > > > > > > > > F:\ruby_testing\DW\rails_warehouse\db\etl>etl author_dimension.ctl > > > > Using AdapterExtensions > > > > Starting ETL process > > > > initializing ETL engine > > > > Processing author_dimension.ctl > > > > > > > > Executing screens > > > > Screens passed > > > > > > > > Executing post processes > > > > > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.1/lib/active_record/connecti > on_a > > > > dapters/abstract_adapter.rb:150:in `log': Mysql::Error: #42000The used > > command i > > > > s not allowed with this MySQL version: LOAD DATA LOCAL INFILE > > './author_dimensio > > > > n.txt' INTO TABLE author_dimension FIELDS TERMINATED BY ',' (name) > > (ActiveRecord > > > > ::StatementInvalid) > > > > from > > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.1/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:46: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:68:in `process' > > > > from > > c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.1/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:58: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.1/lib/active_suppo > > > > rt/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:16:in `load' > > > > from c:/ruby/bin/etl:16 > > > > > > > > > > > > ****************** > > > > > > > > > > > > This is my environment: > > > > Windows XP Pro SP2. > > > > rails -v => 2.0.1 > > > > ruby -v => ruby 1.8.6 (2007-03-13 patchlevel 0) [i386-mswin32] > > > > gem -v => 0.9.4 > > > > MySQL 'select @@version;' => 5.0.27-community-nt > > > > > > > > > > > > If I run the command "LOAD DATA LOCAL INFILE './author_dimension.txt' INTO > > TABLE author_dimension FIELDS TERMINATED BY ',' (name);" directly in > MySQL, > > then the data imports just fine. (Actually it is not completely fine, it I > > get line breaks at the end of some of the strings.) > > > > > > > > Any ideas? > > > > > > > > Thanks, > > > > Paul > > > > > > _______________________________________________ > > Activewarehouse-discuss mailing list > > Activewarehouse-discuss@rubyforge.org > > http://rubyforge.org/mailman/listinfo/activewarehouse-discuss > > > > > > _______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
