Rails 2.2 MySQL removed error SOLUTION

[protech_v2]

If at any point when you've upgraded to Rails 2.2. you get the following error on Windows:

"!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql."

the problem is because MySQL 5.1 client library doesn't play well with Rails - the solution is simple however:

- download older MySQL client library, for example one from InstantRails: http://instantrails.rubyforge.org/svn/t ... bmySQL.dll

- copy the downloaded file to C:\Ruby\bin (or wherever you installed Ruby)

- restart MySQL server

That's it! Just thought I'd share this with others, lost me an hour of researching.

Good luck!

[killnine]

Oh Em Gee


I was looking for hours for a solution and yours WORKED! Thanks SO MUCH.

[the_drow]

Sticky? please... pretty please

[protospike]

I had the error for several days:

Code: Select all

126: The specified module could not be found.   - c:/ruby/lib/ruby/gems/1.8/gems/mysql-2.7.3-x86-mswin32/ext/mysql.so

and your solution solved it. The error occured after I upgraded to version 2.2.2 of Rails.

Thanks for the solution!

This solution is valid for:
Operating system: Windows
Rails version 2.2.2

[myip]

Thank you protech_v2!

[megacell]

i have the same problem but i really new on aptana and i don`t know where exactly i have to paste this file please help me

[cwilliams]

megacell: You copy it to be a peer of your ruby executable, where that lives. If you're on windows, that means where ruby.exe lives. On *nix, run a "which ruby" to see the path.

[loveajax]

I found only a dll file in the list. I guess that's only for Windows. Any solutions for Mac OSX?

[brunopires]

I found only a dll file in the list. I guess that's only for Windows. Any solutions for Mac OSX?

Hi, I´m using Aptana with Rails 2.2.2 on Leopard and had the same problem. The only way I found to get round it was to use the JRuby interpreter rather than the native Ruby (Configure this in the Aptana preferences under the Rails section)

Then install the activerecord-jdbc-adapter and activerecord-jdbcmysql-adapter gems and whatever else it may require.

Then, in your database.yml file be sure to have jdbcmysql in the adapter setting.

I hope i didn't miss a step.

Bruno

[imgla]

Wow! I wish this forum had a rep feature, because you deserve some for that fix! I searched for hours trying to come up with a fix haha

Thanks!

[puiwia]

Thank you for your advice here. I am new at ROR and have not programmed for about 20 years so each little bump in getting up and going seems like a roller coaster ride. Your advice save me lots of time and hair pulling.

John

[haydenhancock]

Thank you for this. I was able to do migrations now and connect to my local MySQL server. I do still get an error installing the "RDoc documentation for mysql-2.7.3-x86-mswin32." Everything seems to be working fine and I was wondering if anyone else had this particular "error" message?

Thanks again for your fix!

[wido]

THANKS !!!! Saved me hours.... I am posting a <a href="http://www.menhardt.com/wido_technical_problems">link</a> to your fix.

[koicat]

Saved my bacon too! Trying to get up to speed with RoR to juice up the resume a little bit...

[snap40]

Hi @all,

I also have a problem with radrails and it doesn't matter if i use sqlite or mysql,nothing works for me.with sqlite3 i get

Code: Select all

-e:1 warning: already initialized constant RUBY_PLATFORM
(in D:/rails/sblog)
rake aborted!
no such file to load -- sqlite3

and when i try in mysql 5 i get the

!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql.

i am new to ruby and radrails and really wanted to start learning but i can't even get it to work!!! and i have been trying for 4 days now googling and so on;( the ruby language looks very interesting and easy to understand BUT getting it to work properly seems to be more trouble than it is worth.

system: is windows vista 64bit intel I7

thanks for any help
Snap40