Error Message

Posted on 2011-10-10
Last Modified: 2012-05-12
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` (

Open in new window

Question by:RalphS007
    LVL 8

    Accepted Solution

    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.
    LVL 8

    Expert Comment

    I meant the value is not available on the skills_category in admin_akills_category table

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    In Solr 4.0 it is possible to atomically (or partially) update individual fields in a document. This article will show the operations possible for atomic updating as well as setting up your Solr instance to be able to perform the actions. One major …
    Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now