mysql return error `ActiveRecord::StatementInvalid: Mysql2::Error: Cannot drop table 'abilities' referenced by a foreign key constraint 'fk_rails_de15a6ad96' on table 'user_abilities'.: DROP TABLE IF EXISTS abilities` Question
+1
−0
After cloning qpixel (yesterday), I can't post anything. I was trying to setup database properly.
rails db:create
database already exists
rails db:schema:load
-- create_table("abilities", {:options=>"ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci", :force=>:cascade}) rails aborted! ActiveRecord::StatementInvalid: Mysql2::Error: Cannot drop table 'abilities' referenced by a foreign key constraint 'fk_rails_de15a6ad96' on table 'user_abilities'.: DROP TABLE IF EXISTS
abilitiesCASCADE
error
rails r db/scripts/create_tags_path_view.rb
error
1 answer
+2
−0
You've already got a database there that you're trying to overwrite. As long as it hasn't got anything in it that you want, do a drop database qpixel_dev and drop database qpixel_test, then re-run from the start.
0 comment threads
0 comment threads