以10为基数的int（）的文本无效：“N/A”Djang

Question

我是Django新手。我按照this教程创建了一个带有MySQL数据库的web界面。以下是我的型号代码：

from django.db import models
from django.contrib.auth.models import User

# Create your models here.


class Strain(models.Model):
    """;
    Model representing strains.
    """
    strain_name = models.CharField(max_length=100, blank=False, null=True, default=None)
    data_of_generation = models.DateField(null=True, blank=True, default= None)

    submitter = models.ForeignKey(User,null=True, blank = False, on_delete= models.CASCADE, default= None)

    class Meta:
        ordering = ["strain_name"]

    def get_absolute_url(self):
        """
        Returns the url to access a particular author instance.
        """
        return reverse('strain-detail', args=[str(self.id)])

    def __str__(self):
        """
        String for representing the Model object.
        """
        return '{0}'.format(self.strain_name)


class Plasmid(models.Model):
    """;
    Model representing an Plasmid Database.
    """
    plasmid_name = models.CharField(max_length=35, blank=False)
    data_of_generation = models.DateField(null=True, blank=True, default= None)
    restriction_sites = models.CharField(max_length=100, blank=False, null=True)

    host_strain = models.ForeignKey(Strain, null=True, blank = True, on_delete= models.CASCADE, default= None)


    class Meta:
        ordering = ["plasmid_name"]

    def get_absolute_url(self):
        """
        Returns the url to access a particular author instance.
        """
        return reverse('plasmid-detail', args=[str(self.id)])

    def __str__(self):
        """
        String for representing the Model object.
        """
        return '{0}'.format(self.plasmid_name)

当我第一次编写代码时，我无意中为变量host_应变的默认选项写了“N/A”。当我试图迁移更改时，我遇到了这个错误：ValueError: invalid literal for int() with base 10: 'N/A'

当我将默认选项改为None时，错误仍然没有消失。我甚至试着删除mysql数据库中的表，但是仍然得到相同的错误。有人知道为什么吗？在

Answer 1

问题可能是django试图使用'N/A'值应用最新的（错误的）迁移，但它失败了。我建议您做的是查看应用程序的migrations文件夹，删除最新的（由于error而未应用）迁移，或者尝试自己编辑它；它会的 包含“N/A”作为默认值，您应该将其更改为其他默认值。在