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

RalphS007Asked:
Who is Participating?
 
PranjalShahConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.