StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POremove_column not removing column or giving any errors in rails
text
Body
copied!<p>I have a sqlite3 db in a rails app with the following schema</p> <pre><code>ActiveRecord::Schema.define(:version => 20100816231714) do create_table "comments", :force => true do |t| t.string "commenter" t.text "body" t.integer "post_id" t.datetime "created_at" t.datetime "updated_at" end create_table "posts", :force => true do |t| t.string "name" t.string "title" t.text "content" t.datetime "created_at" t.datetime "updated_at" end create_table "tags", :force => true do |t| t.string "name" t.integer "post_id" t.datetime "created_at" t.datetime "updated_at" end end </code></pre> <p>I began with a Post :has_many relationship with tags so each tag has a post_id reference.</p> <p>I now want to change this relationship to a 'has_and_belongs_to_many', I know i have to create the joins table etc.... this isn't a problem and is working </p> <p>The problem comes in when i try remove the post_id form the tags table. My migration looks like this: </p> <pre><code>class RemoveFieldsToTags < ActiveRecord::Migration def self.up remove_column :tags, :post_id end def self.down add_column :tags, :post_id, :references end end </code></pre> <p>When I run rake db:migrate and rake db:migrate:up VERSION= Nothing happens when I run rake db:migrate:down VERSION= I get column:</p> <pre><code>SQLite3::SQLException: duplicate column name: post_id: ALTER TABLE "tags" ADD "post_id" references </code></pre> <p>Any one know whats going on?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload