﻿id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
4204	Admin interface attempts to save null to fields not in 'fields': list	david@…	nobody	"Admin appears to attempt to save NULL to fields that are not shown in the Admin interface?

Here is an example model that doesn't work. Trying to update a record using Admin will crash with 

""Data truncated; NULL supplied to NOT NULL column 'nlgroup' at row 1""

David

{{{
from django.db import models
 
# Create your models here.
class People(models.Model):
  def __str__(self):
        return '%s, %s (%s)' % (self.family, self.givens, self.orgname)
# copied from spreadsheet
  peopcode = models.CharField(maxlength=8, verbose_name=""People Code"", unique= True, editable= False)
  family = models.CharField(maxlength=25, verbose_name=""Family"", blank= True)
  givens = models.CharField(maxlength=25, verbose_name=""Givens"", blank= True)
  nlgroup = models.CharField(maxlength=3, verbose_name=""Newsletter Group"", blank= True)
  paddress1 = models.CharField(maxlength=80, verbose_name=""Postal Address Line 1"", blank= True)
  paddress2 = models.CharField(maxlength=80, verbose_name=""Postal Address Line 2"", blank= True)
  email = models.EmailField(verbose_name=""Email"", null = True, blank= True)
  orgname = models.CharField(maxlength=40, verbose_name=""Organisation Name"", blank= True)
  class Admin:
    fields = (
      (None, {
        'fields': (('family', 'givens', 'orgname'), 'email')
      }),
      ('Advanced options', {
        'classes': 'collapse',
        'fields' : ('paddress1', 'paddress2')
      }),
    ) 
  class Meta:
    ordering = ['family', 'givens', 'orgname' ]

}}}
"		closed	contrib.admin	dev		invalid			Unreviewed	0	0	0	0	0	0
