mysql - 如何在 "Unknown column ' 中获取 1054, 'field list' CarrierID_id' 错误

Question

我有两个模型:具有外键载体 ID 的运输模型，它引用另一个模型载体。当我想添加新的运输时，我收到上述错误。据我所知，我没有载体 ID_id 字段，但我不知道为什么会收到此错误。

这是我的模型的结构:

class Carrier(models.Model):
    class Meta:
        verbose_name_plural='carriers'
    carrierID=models.CharField(max_length=15, unique=True)
    carrierName=models.CharField(max_length=50)
    carrierTelephoneNumber=models.CharField(max_length=14)
    carrierAddress=models.TextField()
    def __str__(self):
        return '{}{}{}{}'.format(self.carrierID,' ' , self.carrierName,' ', self.carrierTelephoneNumber,' ',self.carrierAddress)


class Shipping(models.Model):
    shippingID = models.AutoField(primary_key=True)
    carrierID = models.ForeignKey(Carrier, on_delete=models.CASCADE)
    shippingDate = models.DateTimeField()
    productName=models.CharField(max_length=30)
    shippingAddress = models.TextField()
    sendTo = models.CharField(max_length=50)
    shippingStatus = models.BooleanField(default=False)
    promisedDate=models.DateTimeField()
    comment = models.TextField()

shippingForm的结构如下:

class ShippingForm(forms.ModelForm):
    carrier = Carrier.objects.only('carrierID')
    print(carrier)
    carrierID = forms.ModelChoiceField(carrier)
    shippingDate = forms.DateTimeField(required=False)
    productName = forms.CharField(max_length=30, required=False)
    shippingAddress = forms.Textarea()
    sendTo = forms.CharField(max_length=50)
    shippingStatus = forms.BooleanField(required=False)
    promisedDate = forms.DateTimeField(required=False)
    comment = forms.Textarea()
    class Meta:
        model=Shipping
        fields=('carrierID','shippingDate', 'productName','shippingAddress', 'sendTo','shippingStatus','promisedDate', 'comment',)

下面是我的 MySQL 表:

这是运输的 SQL。

create table pages_shipping(shippingID int auto_increment, 
carrierID int(11), 
shippingDate date, 
prductName varchar(50), 
shippingAddress text, 
sendTo varchar(50), 
shippingStatus boolean, 
promisedDate date, 
comment text,
primary key(shippingID), 
foreign key(carrierID) REFERENCES pages_Carrier(id) ON DELETE CASCADE);

请帮忙

Answer 1

我知道发生了什么。这是因为当我运行py manage.py makemigrations命令时，未添加字段载体ID。不幸的是，我不知道强制 Django 添加它