south迁移：“数据库后端不接受0作为AutoField的值”（mysql）

Question

我是django的新手，我试图为一个受让人和记者将外键返回给用户。 但当我试图向南方申请变更时，我得到了一个错误

ValueError: The database backend does not accept 0 as a value for AutoField.

我的型号代码：

class Ticket(models.Model):
    title = models.CharField(max_length=80)
    text = models.TextField(blank=True)
    prioritys = models.ForeignKey(Prioritys)
    ticket_created = models.DateTimeField(auto_now_add=True)
    ticket_updated = models.DateTimeField(auto_now=True)
    assignee = models.ForeignKey(User, null=True, related_name='assignee')
    reporter = models.ForeignKey(User, null=True, related_name='reporter')

    def escaped_text(self):
        return markdown.markdown(self.text)

    def __unicode__(self):
        return self.text

Answer 1

很久以前，Autofield有个问题。

https://code.djangoproject.com/ticket/17653

有趣的引语：

答：

It seems you are trying to save 0 to a ForeignKey which points to an AutoField. But, this is illegal, as the AutoField will not accept that value and so the ForeignKey can not hold that value either.

乙：

So this fix creates another problem when you need to be able to accept a value of 0 (or if you are working on a DB that already has a value of 0!) in an autofield. In my case, I need to accept an ID of zero so that my foreign key can point to zero so that a unique constraint can work properly.

看起来你在"user"."user_id"中有0。
但是再一次。。。完整的堆栈跟踪，请。。。