SQLite3::SQLException: unable to open database file

Hi. I was trying to code same as the rails guide : getting started. I could follow steps to 6.3 Working with Posts in the Browser. (setting home page, creating a resource, running a migration)

After clicked create button, errors are occured. SQLite3::SQLException: unable to open database file: INSERT INTO "posts" ("name", "created_at", "title", "updated_at", "content") VALUES ('123123123', '2009-04-25 22:23:51', '12312312', '2009-04-25 22:23:51', '4123123123')

There is a db file at db folder named development.sqlite3 what's wrong with me? Somebody help me, please.

Thanks in advance.

serenobs wrote:

There is a db file at db folder named development.sqlite3

What does it say?

serenobs wrote:

what's wrong with me? Somebody help me, please.

Also, looking over the directions in the guide, this part is plain wrong:

Of course ruby, ruby gems and sqlite3 are installed on my system (CentOS 5.3)

#gem install sqlite3-ruby Building native extensions. This could take a while... Successfully installed sqlite3-ruby-1.2.4 1 gem installed Installing ri documentation for sqlite3-ruby-1.2.4... Installing RDoc documentation for sqlite3-ruby-1.2.4..

it is installed properly, isn't it? I can execute irb shell(ruby), sqlite3.

. .

There is a db file at db folder named development.sqlite3 what's wrong with me? Somebody help me, please.

Did your migration complete successfully? i.e. does the table posts exist in your database? Does your database.yml file point to your db file - development.sqlite3? It should look something like this: development:   adapter: sqlite3   database: db/development.sqlite3   pool: 5   timeout: 5000