Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

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 abilities CASCADE

error

error

rails r db/scripts/create_tags_path_view.rb
error

error

Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

0 comment threads

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.

Why does this post require moderator attention?
You might want to add some details to your flag.

0 comment threads

Sign up to answer this question »

This community is part of the Codidact network. We have other communities too — take a look!

You can also join us in chat!

Want to advertise this community? Use our templates!

Like what we're doing? Support us! Donate