rake db:migrate fails when trying to do inserts
- by anthony
I'm trying to get a database populate so I can begin working on a project. THis project is already built and I'm being brought in to helpwith front-end work. Problem is I can't get rake db:migrate to do any inserts. Every time I run rake db:migrate I get this:
...
== 20081220084043 CreateTimeDimension: migrating ==============================
-- create_table(:time_dimension)
- 0.0870s
INSERT time_dimension(time_key, year, month, day, day_of_week, weekend, quarter) VALUES(20080101, 2008, 1, 1, 'Tuesday', false, 1)
rake aborted!
Could not load driver (uninitialized constant Mysql::Driver)
...
I'm building on a MBP with Snow Leopard. I've installed XCode from the
disk that comes with the mac. I've updated ruby, installed rails and
all the needed gems. I have the 64 bit version of MySQL installed.
I've tried the 32 bit version of MySQL and I've even tried installing from macports (via http://www.robbyonrails.com/articles/2010/02/08/installing-ruby-on-rails-passenger-postgresql-mysql-oh-my-zsh-on-snow-leopard-fourth-edition)
The mysql gemis installed using: sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/path/to/mysql/bin/mysql_config
the migrate creates the tables just fine but it dies every. single. time. it trys an insert.
Any help would be great