Problem solved. I had a double defined as my primary key in the mysql db. On Fri, May 18, 2012 at 10:49 PM, Mac <mmack3...@gmail.com> wrote:
> I've set up a 'Reps' model in the admin. I can add records > successfully, but if I try to change a record or field, I get a 404 > error. When I try to delete a record, I get this traceback here: > http://dpaste.com/750121/ > My primary keys are integers, but it appears that the urls return them > as floats. Please see the example below. > > The model in whl.models is as follows: > > class Reps(models.Model): > prim = models.AutoField(primary_key=True, db_column='PRIM') > custno = models.CharField(max_length=50, db_column='CUSTNO', > blank=True) # Field name made . > company = models.CharField(max_length=50, db_column='COMPANY', > blank=True)# Field name made > #etc, etc. > > class Meta: > db_table = u'whl_reps' > def __unicode__(self): > return self.custno + " : " + str(self.company)+" : > "+str(self.city)+" : "+str(self.state) > def get_absolute_url(self): > return "/%i/" % self.prim > > My admin.py is: > > from whl.models import Reps > > class RepAdmin(admin.ModelAdmin): > fields = ('company', 'email', 'salesmn', 'city', 'state') > > And for example when I click on a record to change it, I get a 404 > error with a message "reps object with primary key u'39.0' does not > exist". In this case, when i click on a record, it returns this url > > localhost/admin/whl/reps/39.0/ > > As you can see, the last primary key above is not an integer as it > should be. When I manually change the url to /admin/whl/reps/39/ I can > edit the record. > > I'm using Django 1.4, mysql db on Ubuntu. > > Any thoughts on why this is happening? Any help would be appreciated > very much. Thanks. > > > -- 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.