I just started with Simply Rails 2 ebook and am stuck on page 102,Shmay, not sure if my problem was related, but I tried to paste the code on page 102 into the sqlite console (while I am in the "app" directory:
CREATE TABLE stories (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"name" varchar(255) DEFAULT NULL,
"link" varchar(255) DEFAULT NULL,
"created_at" datetime DEFAULT NULL,
"updated_at" datetime DEFAULT NULL
and, I get the message:
Unable to open database "db/development.sqlite3": unable to open database file
I'm not sure if it is because I am in the wrong folder when I execute the command? I usually move into the "app" directory to do this. I think that the installation went all right, because it gives the version number when i check, and when i enter: "sqlite3 db/development.sqlite3"
I get the following:
SQLite version 3.5.4
Enter ".help" for instructions
If anyone else is reading this, please let me know what i'm doing wrong!!
Thanks so much!!