[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

Error Message

MySQL said: Documentation
#1452 - Cannot add or update a child row: a foreign key constraint fails (`galaxy_cms`.<result 2 when explaining filename '#sql-13d8_5a'>, CONSTRAINT `#sql-13d8_5a_ibfk_1` FOREIGN KEY (`skill_category`) REFERENCES `admin_skills_category` (`skills_category`))
ALTER TABLE `admin_skills` ADD FOREIGN KEY ( `skill_category` ) REFERENCES `galaxy_cms`.`admin_skills_category` (
`skills_category`
) ON DELETE RESTRICT ON UPDATE RESTRICT ;

Open in new window

0
RalphS007
Asked:
RalphS007
  • 2
1 Solution
 
PranjalShahCommented:
You are trying to add a value for skill_category to the admin_skills table which is not available in the admin_skills_category list.
0
 
PranjalShahCommented:
I meant the value is not available on the skills_category in admin_akills_category table
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now