Can not run MySQL migration

[killerboy]

In a db: migrate (whatever there is to migrate, even if there is anything else), I get the following message:

rake aborted!
undefined method `each' for #<Mysql:0x48cfb8c>
(See full trace by running task with --trace)
C:/ruby/bin/rake:19: [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.

I'm on Windows, Rails 2.2.2, MySQL 5.1.30, mysql 2.7.3 gem. Problem gem so I suppose someone has already met the concerns?

And when pressed (the result above on a virgin), a second db: migrate gives this:

rake aborted!
Mysql::Error: Commands out of sync; you can't run this command now: SHOW TABLES
(See full trace by running task with --trace)

The migration is performed, but the schema is not fully updated (I just "ActiveRecord:: Schema.define () do" nothing more in the file).

Why does MySQL migration guves me such messages?

[Modifier]

All your gems are up to date? Especially ruby, since in the previous version was a warning that appeared during migration it seems. Did you searched or contacted ruby regarding updates? Also one more thing: Why ms windows installed version and why not one written in Ruby?

I have Rails 2.2.2, but I turn my Mac and I use PostgreSQL so I can not help more.

[killerboy]

Yes everything is up-to-date . Rubygems 1.3.1. For the rest:

actionmailer (2.2.2)
actionpack (2.2.2)
activerecord (2.2.2)
activeresource (2.2.2)
activesupport (2.2.2)
fxri (0.3.6)
fxruby (1.6.12)
hpricot (0.6)
log4r (1.0.5)
mysql (2.7.3)
rails (2.2.2)
rake (0.8.3, 0.7.3)
sources (0.0.1)
sqlite3-ruby (1.2.3)
win32-api (1.0.4)
win32-clipboard (0.4.3)
win32-dir (0.3.2)
win32-eventlog (0.4.6)
win32-file (0.5.4)
win32-file-stat (1.2.7)
win32-process (0.5.3)
win32-sapi (0.1.4)
win32-sound (0.4.1)
windows-api (0.2.0)
windows-pr (0.7.2)

Why ms windows installed version and why not one written in Ruby?

Here it is strong, I'm in the office, with a proxy that blocks it. So I do local installations only. The only thing I found is for win32, mysql-ruby is available in source form only, and is specified POSIX systems (again, I may crash.)

[Modifier]

Generally those who run under Windows using InstantRails (if it still exists?) If cygwin, the rest is Mac or Linux. Besides you have installed ruby and rails how?

It is not particularly help you right away, but personal I uninstalled it from my old iBook and there's no photo for anything I do not return to Windows for the rails.

[killerboy]

I was not happy to InstantRails simply because the rail installs on same offline, its trivial. On this machine, I'm as small test projects with a SQLite database. To answer your question, install ruby + rubygems. Then, as it installs gems locally.

Regarding the environment, I have a max stress that I spare you, but basically it will be Windows or nothing, not Cygwin. It should also pose no worries (for mysql in any case, I forgot postgres win in yet), I already had a Windows turning this way without trouble (retail versions close ).