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
3447	"Attempt to add new inline-edited item in admin interface results in ProgrammingError ERROR: invalid input syntax for integer: """".  Used to work in older SVN snapshot."	mdkemp	Adrian Holovaty	"Consider the following extremely-simple inline-edited relationship:

{{{
class Case(models.Model):
	name = models.CharField(maxlength=100)

	class Admin:
		pass


class Label(models.Model):
	case = models.ForeignKey(Case, edit_inline=models.TABULAR)
	name = models.CharField(maxlength=100, core=True)

	class Admin:
		pass
}}}

In this case, if I try to add a new Label to a Case (while editing the Case via its admin interface view), I get the following error:

{{{
Exception Type:  	ProgrammingError
Exception Value: 	ERROR: invalid input syntax for integer: """" SELECT 1 FROM ""peopledb_label"" WHERE ""id""='' LIMIT 1
}}}

The following were the arguments from the HTTP POST operation when I clicked Save:

{{{
label.0.id     ''
name           'Case1'
label.0.name   'TestLabel1'
}}}

It appears that when trying to determine if an old record should be updated rather than inserted into the database, an invalid query was built.  I've encountered this problem now on three different django projects.  This used to work in a version of django from a SVN snapshot around 12/15/2006, and does work if I revert my installed django to that version."		closed	contrib.admin	dev		fixed	edit_inline, ProgrammingError	mir@…	Accepted	0	0	0	0	0	0