On Tue, Feb 28, 2012 at 3:24 PM, Joel Goldstick
<joel.goldst...@gmail.com> wrote:
> 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
Nothing like posting to clear the problem. I put this in my model,
and then added supplier_id to my table by hand. Problem solved
supplier = models.ForeignKey('LandSupplier')
--
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.
