I am just beginning to learn RoR, following the “Up and running”
setup: ruby and ror=latest; mysql 4.0.17; WEBrick.
#Created the app I had to add the -d mysql after looking in the forums,
latest RoR does not defaults to mysql
rails -d mysql \chapter1
create database chapter1_development;
grant all on . to ‘ODBC@localhost’;
ruby script/generate controller Greeting
At this point I should see at localhost:3000/greeting something like
“an error message telling you that index is an unknown action.” (the
Instead I see this:
ActiveRecord::StatementInvalid in GreetingController#index
Mysql::Error: Unknown system variable ‘NAMES’: SET NAMES ‘utf8’
This is the response I get for EVERY request, even
MySQL complains about an unknown system variable, NAMES. I searched the
mysql docs, hoping this variable would be present in later versions of
MySQL; so upgrading the database would solve the problem. But this
variable is nonexistent, in any version of the database.
So what’s going on?
Thanks to all