Dear List,
I'm developing with 1.0.2 and am getting the following error:
(1451, 'Cannot delete or update a parent row: a foreign key constraint
fails (`project/comment_comment`, CONSTRAINT
`in_reply_to_id_refs_id_35b80077` FOREIGN KEY (`in_reply_to_id`)
REFERENCES `comment_comment` (`id`))')
... where the Comment model i've defined is:
class Comment(models.Model):
objects = CommentManager()
user = models.ForeignKey(User)
title = models.CharField(max_length=60)
comment = models.TextField()
content_type = models.ForeignKey(ContentType)
object_id = models.PositiveIntegerField()
owner = generic.GenericForeignKey('content_type', 'object_id')
in_reply_to = models.ForeignKey('self', null=True, blank=True,
related_name='reply_to')
rating = models.FloatField(default=5.00)
created = models.DateTimeField('date created', auto_now_add=True)
... when trying to delete the owner object (genericforeignkey) and
when there are two comments pointing to the owner object - one with
in_reply_to == None, and the other with in_reply_to == the first
comment. The cascade works fine if I try to delete the first comment,
but when i'm trying to delete the owner object the error comes up???
Could anyone please help me understand why this exception is being
thrown, and how to possibly fix it?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
