SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Sep 2009
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    simply rails create a table..

    simply rails chapter 4 104pg
    I am trying to create a table
    I am at the command prompt E:\instantRails-2.0-win\rails-apps>

    when I insert the
    $ sqlite3 db/development.sqlite3
    and
    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
    );

    I get sqlite3:unable to open the database file..

    where do I go wrong please help...

  2. #2
    SitePoint Enthusiast
    Join Date
    Jan 2010
    Location
    Cleveland, OH
    Posts
    49
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think you are in the wrong directory. Make sure to go to the root directory of your Rails application. In the case of Rails 2 book, make sure you are in the shovell directory and then try those commands.

  3. #3
    SitePoint Member
    Join Date
    Sep 2009
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks kmsolorio i will try that, great day!!


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •