"Sqlite3::Sqlexception: no such table: main.Category" running rake db:migrate with Gem Acestry

Question

I’m having a hard time using Gem Acestry in so far as it says:

Add index to Migration: add_index [table], :ancestry (UP) / remove_index [table], :ancestry

I’m creating a method called Category and trying to add Acestry but the following error appears in Powershell:

== AddAncestryToCategory: migrating ========================================== -- add_column(:Categories, :ancestry, :string) -> 0.0140s -- add_index(:Category, :ancestry) rake aborted! An error has occurred, this and all later Migrations canceled:

Sqlite3::Sqlexception: no such table: main.Category: CREATE INDEX "index_category_on_ancestry" ON "Category" ("ancestry ")C:/sites/projects/mymoney/db/migrate/20140205153511_add_ancestry_to_category.Rb:4:in change' C:inmigrate' Tasks: TOP => db:migrate (See full trace by running task with --trace)

Follow the code of migrates:

class CreateCategories < ActiveRecord::Migration
  def change
    create_table :categories do |t|
      t.string :name

      t.timestamps
    end
  end
end

And

class AddAncestryToCategory < ActiveRecord::Migration
  def change
    add_column :categories, :ancestry, :string
    add_index :category, :ancestry
  end
end

Answer 1

According to the documentation of add_index, http://api.rubyonrails.org/classes/ActiveRecord/ConnectionAdapters/SchemaStatements.html#method-i-add_index
The table name is passed in the plural, so I think if you change the example to add_index :categories, :ancestry, will work normally.