From: lewcio@...
Date: 2005-10-26T16:07:13+09:00
Subject: help: trouble with ONLamp's cookbook tutorial / mysql

I haven't yet touched the tutorial app's code except to change the
database.yml to read:
development:
  adapter: mysql
  database: cookbook
  host: localhost
  ...

Application starts up fine at http://127.0.0.1:3000

When I try to test http://127.0.0.1:3000/recipe/list I get the
following error:
ActiveRecord::StatementInvalid in Recipe#list
Invalid argument: SELECT * FROM recipes

Yet I'm able to query SELECT * FROM recipes in Eclipse's "Instant SQL"
tool and get the correct results.

What could be the problem? I have read somewhere that it could be that
the ruby mysql driver is outdated. Unfortunately I wasn't able to find
one to install. Any ideas?

running on Win XP:
Eclipse 3.1.1, app launched with WEBrick
Instant Rails 1.0 preview 1
Ruby 1.8.2
MySQL 4.1.9