In your database ( not in the model ) rename the field 'category in table MdlCourse to category_id and it should fix the problem... normally a ForeignKey field name in the database is ClassName_id
On Apr 2, 6:12 pm, mthorley <[EMAIL PROTECTED]> wrote: > Greetings, I used inspectdb to create my models and then tried editing > the generated models in order to define the ForeignKey relationships, > and I'm getting an error. > > Here's what I have. Note: I commented out the original category field > and tried adding my own ForeignKey > > class MdlCourseCategories(models.Model): > id = models.IntegerField(primary_key=True) > name = models.CharField(max_length=765) > description = models.TextField(blank=True) > parent = models.IntegerField() > > class Meta: > db_table = u'mdl_course_categories' > > class MdlCourse(models.Model): > id = models.IntegerField(primary_key=True) > #category = models.IntegerField() > category = models.ForeignKey(MdlCourseCategories, to_field='id') > sortorder = models.IntegerField() > password = models.CharField(max_length=150) > fullname = models.CharField(max_length=762) > shortname = models.CharField(max_length=300) > > class Meta: > db_table = u'mdl_course' > > Using these models I do the following in the manage.py shell > > >>> from cca.moodle.models import * > >>> cs = MdlCourse.objects.all() > >>> cs > > OperationalError: (1054, "Unknown column 'mdl_course.category_id' in > 'field list'") > > to_field doesn't work quite like I expected. Does anyone know a way to > make models.ForeignKey to at a specific table.column? > > Humblest Thanks and Kind Regards > -- > matthew --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
