Integrity Error 1452
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and error 1452: cannot add or update a child row: a foreign key constraint fails policies of this site About Us Learn more about Stack Overflow the
Error Code 1452 Mysql Workbench
company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags mysql error 1452 foreign key constraint fails Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes
A Foreign Key Constraint Fails Mysql Insert
a minute: Sign up Django Integrity Error 1452, Cannot add or update a child row: a foreign key constraint fails up vote 1 down vote favorite 1 models.py: from django.db import models class Line(models.Model): text = models.CharField(primary_key=True, max_length=255) class Line2 (models.Model): text_line = models.ForeignKey ("Line", primary_key = True) views.py: from django.core.context_processors import csrf from django.shortcuts import render import datetime from models cannot add or update a child row a foreign key constraint fails on delete cascade on update cascade) import Line, Line2 def test_page (request): if 'uid' in request.POST: user_id = request.POST['uid'] line_query = Line.objects.get (text = user_id) new_entry = Line2 (text_line_id = line_query) new_entry.save() return render(request, "templateFiles/testPage1.html", {"page_result":"Data Entered"}); else: return render(request, "templateFiles/testPage1.html") template:
{{ page_result }} The data which I'm sending exists in the parent key, but I'm getting IntegrityError (1452, 'Cannot add or update a child row: a foreign key constraint fails (tempDB.testDBProjectApp_line2, CONSTRAINT text_line_id_refs_text_f741df88 FOREIGN KEY (text_line_id) REFERENCES testDBProjectApp_line (text))') My Database Parent Table "line" is as follows: mysql> select * from testDBProjectApp_line; +-------+ | text | +-------+ | test1 | | test2 | +-------+ python mysql django share|improve this question edited Nov 13 '15 at 11:22 Alasdair 93.4k11151195 asked Nov 13 '15 at 9:27 Rajiv Gupta 105 Even if there was provision for that(I don't know), it really wouldn't make sense. A parent relation tuple can be referenced by multiple child relation tuples - thereby breaking the uniqueness
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings
Mysql Replication Error 1452
and policies of this site About Us Learn more about Stack
Er_no_referenced_row_2
Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs set foreign_key_checks=0 mysql Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; http://stackoverflow.com/questions/33689509/django-integrity-error-1452-cannot-add-or-update-a-child-row-a-foreign-key-con it only takes a minute: Sign up Mysql error 1452 - Cannot add or update a child row: a foreign key constraint fails up vote 179 down vote favorite 53 I'm having a bit of a strange problem, I'm trying to add a foreign key to one table that references another, but it is failing for some reason. With my http://stackoverflow.com/questions/1253459/mysql-error-1452-cannot-add-or-update-a-child-row-a-foreign-key-constraint-fa limited knowledge of MySQL, the only thing that could possibly be suspect is that there is a foreign key on a different table referencing the one I am trying to reference. Here is a picture of my table relationships, generated via phpMyAdmin: Relationships I've done a SHOW CREATE TABLE query on both tables, sourcecodes_tags is the table with the foreign key, sourcecodes is the referenced table. CREATE TABLE `sourcecodes` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL, `language_id` int(11) unsigned NOT NULL, `category_id` int(11) unsigned NOT NULL, `title` varchar(40) CHARACTER SET utf8 NOT NULL, `description` text CHARACTER SET utf8 NOT NULL, `views` int(11) unsigned NOT NULL, `downloads` int(11) unsigned NOT NULL, `time_posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `language_id` (`language_id`), KEY `category_id` (`category_id`), CONSTRAINT `sourcecodes_ibfk_3` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `sourcecodes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `sourcecodes_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UP
Sign in Pricing Blog Support Search GitHub This repository Watch 145 Star 3,221 Fork 601 https://github.com/coleifer/peewee/issues/737 coleifer/peewee Code Issues 7 Pull requests 4 Projects 0 Wiki Pulse Graphs New issue peewee.IntegrityError: (1452, 'Cannot add or update a child row: a foreign key constraint fails (test_peewee_tree.node, CONSTRAINT node_ibfk_1 FOREIGN KEY (parent_id) REFERENCES node (id))') db = MySQLDatabase #737 Closed slukin1 opened this Issue Oct 23, 2015 · 8 comments error 1452 Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 2 participants slukin1 commented Oct 23, 2015 peewee.IntegrityError: (1452, 'Cannot add or update a child row: a foreign key constraint fails (test_peewee_tree.node, CONSTRAINT node_ibfk_1 FOREIGN KEY (parent_id) REFERENCES node (id))') db = MySQLDatabase Owner coleifer foreign key constraint commented Oct 23, 2015 Uhh, did you make the parent foreign key nullable? This looks like a data integrity error rather than peewee. slukin1 commented Oct 24, 2015 Yes, parent foreign ey made nullable: mysql_db = MySQLDatabase('test_peewee_tree') class BaseModel(Model): class Meta: database = mysql_db class Node(BaseModel): label = CharField() parent = ForeignKeyField('self', default=0) left = IntegerField(default=0) right = IntegerField(default=1) depth = IntegerField(default=0) def get_parent(self, level=1): parent = self for i in range(level): parent = parent.parent return parent if __name__ == '__main__': Node.create_table() n1 = Node(label='root') n2 = Node(label='a') n3 = Node(label='b') n4 = Node(label='c') n1.append(n2) n1.append(n3) n2.append(n4) slukin1 commented Oct 24, 2015 Same peewee.IntegrityError: (1452.... if changed to parent = ForeignKeyField('self', default=0, null = True) or parent = ForeignKeyField('self', db_column='parent_id', default=0, null = True) slukin1 commented Oct 24, 2015 No error peewee.IntegrityError: (1452... with peewee version 2.2.4 and parent = ForeignKeyField('self', null = True) slukin1 commented Oct 24, 2015 With parent = ForeignKeyFie