ActiveRecord::StatementInvalid in BlogController#index

Hello. I'm trying to do the video tutorial "how to build a blog engine
in 15 minutes with ruby on rails" from the main rubyonrails website,
and I'm getting an error when I try to use scaffold :post after
editing my config file for the mysql database.

Here is the exact error I'm getting:

ActiveRecord::StatementInvalid in BlogController#index

ActiveRecord::StatementInvalid
RAILS_ROOT: ./script/../config/..

Application Trace | Framework Trace | Full Trace
Request

Parameters: None

Show session dump

Response

Headers: {"cookie"=>[], "Cache-Control"=>"no-cache"}

If anyone can help me I would greatly appreciate it. I'm really
stumped here.

Heya

That video is REALLY out of date, so it won't work - it's a pre-
release version of Rails that was being used.

Try out some of my videos... they're free (for a limited time) :wink:

See below!

Julian.

Learn Ruby on Rails! Check out the FREE VIDS (for a limited time)
VIDEO #4 coming soon!
http://sensei.zenunit.com/

Heya

That video is REALLY out of date, so it won't work - it's a pre-
release version of Rails that was being used.

Try out some of my videos... they're free (for a limited time) :wink:

Although according to the first video you're using rails 1.2.4, so
hardly latest and greatest.

Fred

Unfortunately, neither of these responses helped me or had anything to
do with my question.

Can anyone else be so kind as to give me a hint, I'm stuck here.

Unfortunately, neither of these responses helped me or had anything to
do with my question.

Can anyone else be so kind as to give me a hint, I'm stuck here.

You need to tell us more. there should be more to the error in the
logs (in particular what is the sql statement that was invalid).

Fred