RoR and SQL issu

rubyonrails-talk
1

I've set up on Windows 7 Eclipse with ruby and radrails and want to use MySQL as a database. I've executed: gem install mysql2 And changed the database.yml

I have tried to use MySQL 5.5 and 5.1 and the error still exists.

rake aborted! Please install the mysql adapter: `gem install activerecord-mysql-adapter` (mysql is not part of the bundle. Add it to Gemfile.)

I've also copia a libmysql dll into de ruby .bin folder.

Any help? I have searched everywhere and cant get it fix. How and where in the gem file do I add what?

On another note, if I have 2 tables, one with its primary key being a foreign key, does RoR automatically create a <columname_to> on that table?

Thanks in advance, im stuck :confused:

Attachments: http://www.ruby-forum.com/attachment/7225/rake.jpg

2

I've set up on Windows 7 Eclipse with ruby and radrails and want to use MySQL as a database. I've executed: gem install mysql2 And changed the database.yml

what did you change it to? I'd wager you've got adapter: mysql, whereas it should be adapter mysql2

Any help? I have searched everywhere and cant get it fix. How and where in the gem file do I add what?

Your Gemfile lists all the gems your app uses, if you're using the mysql2 gem you'd need

gem 'mysql2'

(If you're using an older rails version you may need to specify a version of mysql2 that is compatible with your rails version.

On another note, if I have 2 tables, one with its primary key being a foreign key, does RoR automatically create a <columname_to> on that table?

Not sure I quite get the question, but rails doesn't create any columns automatically. Use a migration to add tables or change existing tables. There are a few shortcuts you can use in the migration / generators (e.g. rails g model1 model2:belongs_to will add a column called model2_id as well as an index)

Fred

3

Your Gemfile lists all the gems your app uses, if you're using the mysql2 gem you'd need

gem 'mysql2'

(If you're using an older rails version you may need to specify a version of mysql2 that is compatible with your rails version.

Im using rails 3.2.2 na in my: C:\Ruby187\lib\ruby\gems\1.8\gems

folder I can see the: mysql-2.8.1-x86-mingw32, mysql2-0.3.11-x86-mingw32 and mysql2-0.3.11-x86-mswin32-60

folders.

Doesn't this mean its installed already? :confused:

4

Your rails app will only use the gems specified in your Gemfile (and their dependencies). If it's not in your Gemfile, it's not loaded, even if it is already installed

Fred

5

Your rails app will only use the gems specified in your Gemfile (and their dependencies). If it's not in your Gemfile, it's not loaded, even if it is already installed

Fred

Thank you for the explanation and time dedicated Fred

Best regards