Rails - Feb 2010 - Problem: The command "rake db:create:all" crashes

Hi All,

I''m running:
Rails 2.3.5
MySQL 5.1.44
WindowsXP-Pro/SP3

Following Noel Rappin''s book, Pro RoR, I successfully got past the
point of creating my first scaffold:
ruby script/generate scaffold supplier nickname:string  qbname:string
That produced the migration, 20100221011210_create_suppliers.rb:
class CreateSuppliers < ActiveRecord::Migration
  def self.up
    create_table :suppliers do |t|
      t.string :nickname
      t.string :qbname

      t.timestamps
    end
  end

  def self.down
    drop_table :suppliers
  end
end

Then I ran "rake db:create:all".  The Command  Window display for this
is:


K:\_Projects\Ruby\_Rails_Apps\_EIMS\RTS>rake db:create:all
(in K:/_Projects/Ruby/_Rails_Apps/_EIMS/RTS)
K:/_Utilities/ruby186-26_rc2/ruby/lib/ruby/gems/1.8/gems/
activesupport-2.3.5/lib/active_support/core_ext/module/
introspection.rb:73: [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.

K:\_Projects\Ruby\_Rails_Apps\_EIMS\RTS>


Then I checked for generated databases with:
mysql> show databases;

Among several tables, it showed only one of my RTS app''s expected
databases: rts_development.
My database.yaml specifies the normal 3: development, test and
production

Further, I tested whether this database had the specified table
"supplier":
mysql> show tables in rts_development;
Empty set (0.00 sec)

Then I tested whether I could drop the RTS database:
mysql> drop database if exists rts_development;
Query OK, 0 rows affected (0.01 sec)

All the logs in RTS\log are empty except for development.log.  But as
far as I can tell,  all that data was written a couple of days ago
when I had an older edition of MySQL and gave me crashes.

Any ideas on how to proceed.  I''ve tested my current version of MySQL
with a number of commands in the MySQL monitor in a Windows Command
Window and seems to perform well.

Any ideas?

Thanks in Advance,Richard

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

> Any ideas on how to proceed.  I''ve tested my current version of
MySQL
> with a number of commands in the MySQL monitor in a Windows Command
> Window and seems to perform well.
> 
> Any ideas?
> 
> Thanks in Advance,Richard
I know there are some issues with RoR and MySQL 5.1 on windows, at least
for Vista x64 and Win7 x64. I dont know if there''s a bug with the 
adapter or if
its mysql itself. I suggest you try version 5.0.
-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Hi Sharagoz,
> I suggest you try version 5.0.
5.0 was working well for years on my WinXP machine.  I thought that
since I had a bad installation for the purpose rake db:create:all, I
outgh to get the latest release of MySQL.  But that extra step might
have been unwise.

Thanks for the suggestion.
Richard

On Feb 23, 3:58 am, Sharagoz --
<li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>
wrote:
> > Any ideas on how to proceed.  I''ve tested my current version
of MySQL
> > with a number of commands in the MySQL monitor in a Windows Command
> > Window and seems to perform well.
>
> > Any ideas?
>
> > Thanks in Advance,Richard
>
> I know there are some issues with RoR and MySQL 5.1 on windows, at least
> for Vista x64 and Win7 x64. I dont know if there''s a bug with the
> adapter or if
> its mysql itself. I suggest you try version 5.0.
> --
> Posted viahttp://www.ruby-forum.com/.
-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.