Creating a many-to-many link for a UserProfile?

[derek]

Django 1.2.1, with Python 2.6

I am trying to establish a many-to-many for a userprofile (working
with a legacy database so some of the field names are a little
strange...).

The models I have are:

class UserGrouping(models.Model):
    #many-to-many
    id = models.AutoField(primary_key=True, db_column='id')
    grouping = models.ForeignKey(Grouping, db_column='grouping_id')
    user = models.ForeignKey(User, db_column='user_id')
    class Meta:
        db_table = 'usergrouping'
        unique_together = (('grouping', 'user'), )

class UserProfile(models.Model):
    user = models.ForeignKey(User, db_column='user_id', unique=True,
primary_key=True, blank=True, null=True, default=None)
    userid = models.CharField(verbose_name=_('ID'), unique=True,
editable=False, max_length=6, blank=True, null=True)
    records = models.IntegerField(db_column='records', default=20,
blank=True, null=True)
    groupings = models.ManyToManyField(UserGrouping,
db_table="usergrouping")
    class Meta:
        db_table = 'user'

The table structures are as follows:

CREATE TABLE  `usergrouping` (
  `grouping_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  UNIQUE KEY `usergrouping_combo` (`grouping_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE  `user` (
  `user_id` int(11) DEFAULT NULL,
  `userid` varchar(6) DEFAULT '',
  `records` int(11) NOT NULL DEFAULT '10',
  `LastChanged` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8


The error I get is:

OperationalError at /admin/auth/user/895/
(1054, "Unknown column 'T2.userprofile_id' in 'where clause'")

I am not sure why Django is looking for a "userprofile_id", and
therefore how to go about creating the relationship?  (If I remove the
'groupings' link, then the profile works as expected.)

Thanks
Derek

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-us...@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.