Become a leader in the IoT community!

Join our community of embedded and IoT practitioners to contribute experience, learn new skills and collaborate with other developers with complementary skillsets.

Step 1 of 5

CREATE YOUR PROFILE *Required

OR
Step 2 of 5

WHAT BRINGS YOU TO DEVHEADS? *Choose 1 or more

Connect & collaborate 🀝with other tech professionals
Learn & Grow πŸ“š
Contribute Experience & Expertise πŸ”§
Step 3 of 5

WHAT'S YOUR INTEREST OR EXPERTISE? *Choose 1 or more

Hardware Design πŸ’‘
Embedded Software πŸ’»
Edge Networking ⚑
Step 4 of 5

Personalize your profile

Step 5 of 5

Read & agree to our COMMUNITY RULES

  1. We want this server to be a welcoming space! Treat everyone with respect. Absolutely no harassment, witch hunting, sexism, racism, or hate speech will be tolerated.
  2. If you see something against the rules or something that makes you feel unsafe, let staff know by messaging @admin in the "support-tickets" tab in the Live DevChat menu.
  3. No age-restricted, obscene or NSFW content. This includes text, images, or links featuring nudity, sex, hard violence, or other graphically disturbing content.
  4. No spam. This includes DMing fellow members.
  5. You must be over the age of 18 years old to participate in our community.
  6. You agree to our Terms of Service (https://www.devheads.io/terms-of-service/) and Privacy Policy (https://www.devheads.io/privacy-policy)
By clicking "Finish", you have read and agreed to the our Terms of Service and Privacy Policy.

I’m working on an IoT project that involves storing data in a database.

Hi everyone,

I’m working on an IoT project that involves storing data in a database. While writing the SQL code, I encountered the following error:

“violated – parent key not found”

I search everywhere, Has anyone else encountered this issue, or can anyone provide guidance on how to fix
file0.jpg

  1. jjbitnicπŸ‘€#0000

    Check if the colums/fields in your query maych that of the table in database. What is the database vendor? Can you run the same query manually using native db client? Are you doing a select, update, or insert?

  2. wafa_athmani#0000

    i am using MySQL, I am entering a values linked to a foreign key (FK)..

  3. jjbitnicπŸ‘€#0000

    Sounds like a db issue with the query. I would approach this by trying with the mysql native client to see if it works there. There is a post on Stack Overflow that describes similar issue: https://stackoverflow.com/questions/69042788/im-repeatedly-getting-this-integrity-constraint-violated-parent-key-not-found

  4. wafa_athmani#0000

    Thank you @jjo548 , actually i found that one of the FOREIGN KEY values in the REFERENCE Table does not exist in the Parent Table. I just Ensure that the ID value matches in both tables. βœ…

CONTRIBUTE TO THIS THREAD

Browse other questions tagged 

Leaderboard

RANKED BY XP

All time
  • 1.
    Avatar
    @Nayel115
    1620 XP
  • 2.
    Avatar
    @UcGee
    650 XP
  • 3.
    Avatar
    @melta101
    600 XP
  • 4.
    Avatar
    @chitour
    600 XP
  • 5.
    Avatar
    @lifegochi
    250 XP
  • 6.
    Avatar
    @Youuce
    180 XP