I'm going through Simply Rails 2, and am on page 255. It is creating the users table.

I generated the model, and then created the model it said to create:

Code:
class CreateUsers < ActiveRecord::Migration
  def self.up
    create_table :users do |t|
      t.string :login
      t.string :password
      t.string :name
      t.string :email

      t.timestamps
    end
    add_column :stories, :user_id, :integer
    add_column :votes, :user_id, :integer
  end

  def self.down
    drop_table :users
    remove_column :stories, :user_id
    remove_column :votes, :user_id
  end
end
When I run db:migrate, though, I get an error:

Code:
$ rake db:migrate
(in /home/Brandon/projects/shovell)
==  CreateUsers: migrating ====================================================
-- create_table(:users)
   -> 0.0970s
-- add_column(:stories, :user_id, :integer)
rake aborted!
An error has occurred, all later migrations canceled:

SQLite3::SQLException: unable to open database file: VACUUM

(See full trace by running task with --trace)
I don't understand this error at all. I couldn't migrate down, so I deleted db/development.sqlite3 and tried again. I got the same result at the same spot.

I have Ruby 1.8.7, Rails 2.2.2, running on Cygwin.

Why would this be happening?