Become a leader in the IoT community!
New DevHeads get a 320-point leaderboard boost when joining the DevHeads IoT Integration Community. In addition to learning and advising, active community leaders are rewarded with community recognition and free tech stuff. Start your Legendary Collaboration now!
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?
i am using MySQL, I am entering a values linked to a foreign key (FK)..
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
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