From: prash <iprash@...>
Date: 2009-01-25T16:53:07+09:00
Subject: Re: ruby mysql error

On Jan 7, 11:14 am, Maged Makled <almig...@gmail.com> wrote:
> Hi All, I'm trying to run mysql DB with ROR app. I'm using Netbeans 6.5
> and whenever I run the server and it tried to hit the DB, I get the
> error:
>
> ***
> C:/InstantRails-2.0-win/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:38:
> [BUG] Segmentation fault
>
> ruby 1.8.6 (2007-09-24) [i386-mswin32]
>
> This application has requested the Runtime to terminate it in an unusual
> way.
> Please contact the application's support team for more information.
>
> *****
>
> Any thoughts
>
> Thanks in advance
>
> Maged
> --
> Posted viahttp://www.ruby-forum.com/.

ok, i had this problem and solved it.
the problem is that starting from rails 2.2, mysql support is not
included by default
(sqlite3 is the new default) and you have to install it as a gem
so i assume you did "gem install mysql" or something similar.
now the problem is that this gem does not seem to work with newer
versions of mysql
(at least for now).

specifically, in my case, i use windows for development.
one of my machines had mysql community version mysql-5.0.67-win32 and
everything seemed fine.
on a newer machine i had mysql-5.1.30-win32 and it gave me this
segmentation fault!
simply rolling back to version 5.0.67 fixed this problem.

hope that helps.
-prash.