Beginner question - MySQL db:migrate error

rubyonrails-talk
1

Hi,

I am pretty frustrated with my first attempts to create a simple ruby on rails project with mysql.

I get a strange error when I run the rake db:migrate

"NoMethodError: undefined method `ord' for 1:Fixnum: SHOW TABLES"

Anybody any suggestions what that might be?

Thanks bbrails

Mac OS X: 10.5.8 MySQL: 5.0.83

gem list

*** LOCAL GEMS ***

actionmailer (2.3.5, 1.3.6) actionpack (2.3.5, 1.13.6) actionwebservice (1.2.6) activerecord (2.3.5, 1.15.6) activeresource (2.3.5) activesupport (2.3.5, 1.4.4) acts_as_ferret (0.4.1) BlueCloth (1.0.1) capistrano (2.0.0) cgi_multipart_eof_fix (2.5.0) configuration (1.1.0) daemons (1.0.9) dnssd (0.6.0) faker (0.3.1) fastthread (1.0.1) fcgi (0.8.7) ferret (0.11.4) gem_plugin (0.2.3) haml (2.2.19) heroku (1.8.0) highline (1.2.9) hpricot (0.6) json_pure (1.2.0) launchy (0.3.5) libxml-ruby (0.9.5) linecache (0.43) mime-types (1.16) mocha (0.9.8) mongrel (1.1.4) mysql (2.8.1) needle (1.3.0) net-sftp (1.1.0) net-ssh (1.1.2) populator (0.2.5) postgres-pr (0.6.3) rack (1.0.1) rails (2.3.5, 1.2.6) rake (0.8.7, 0.7.3) RedCloth (3.0.4) rest-client (1.3.1) ruby-debug-base (0.10.3) ruby-debug-ide (0.4.5) ruby-openid (1.1.4) ruby-yadis (0.3.4) rubygems-update (1.3.5) rubynode (0.1.3) sqlite3-ruby (1.2.5, 1.2.1) termios (0.9.4) thoughtbot-factory_girl (1.2.2) thoughtbot-shoulda (2.10.2)

2

Hi,

I am pretty frustrated with my first attempts to create a simple ruby

on rails project with mysql.

I get a strange error when I run the rake db:migrate

“NoMethodError: undefined method `ord’ for 1:Fixnum: SHOW TABLES”

Anybody any suggestions what that might be?

First, I would recommend trying something simply like the following:

$ rails test

$ cd test

$ script/generate scaffold post title:string body:text

$ rake db:migrate

$ script/server

Next, verify that you can properly navigate to the URL, http://localhost:3000/posts

Finally, posts the results of the above simple experiment. OK?

Good luck,

-Conrad