I seem to get this no matter what I do:
-- change_column("bj_config", :bj_config_id, :primary_key)
rake aborted!
Mysql::Error: #42000Multiple primary key defined: ALTER TABLE `bj_config` CHANGE `bj_config_id` `bj_config_id` int(11) DEFAULT NULL auto_increment PRIMARY KEY DEFAULT NULL
Here is the problem table:
create_table "bj_config", :primary_key => "bj_config_id", :force => true do |t|
t.string "hostname"
t.string "key"
t.text "value"
t.text "cast"
end
When I removed the :primary_key, it worked.
I dropped the database and recreated it and still kept getting this problem.