I have a legacy database from which I created a model called 'LandSupplier'

    class LandSupplier(models.Model):
        landsupplierid = models.AutoField(primary_key=True,
db_column='LandSupplierId') # Field name made lowercase.
        ...
        class Meta:
            db_table = u'LandSupplier'
            ordering = ("name",)

I have a second model called LandOffer:

    class LandOffer(models.Model):
        id = models.AutoField(primary_key=True)
        name = models.CharField(max_length=300, db_column='Name') #
Field name made lowercase.
        supplier = models.ForeignKey('LandSupplier', db_column='landsupplierid')

I get this error:

Request Method: GET
Request URL:    http://localhost:8000/admin/land/landoffer/
Django Version: 1.3.1
Exception Type: OperationalError
Exception Value:        (1054, "Unknown column
'land_landoffer.landsupplierid' in 'field list'")

It seems to take my fieldname, but not my table name.  I'm wondering
how to fix this.  I could rename the table to 'land_landoffer' but
that would mess up a lot of other code, and I would rather learn what
I am doing wrong here

-- 
Joel Goldstick

-- 
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.

Reply via email to