﻿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
2512	[patch] Do not fail on update of a primary-key only table	Daniel Hahler	Adrian Holovaty	"Foo has a model with only id (primary key).

Calling:
{{{
existing_id = 1
foo = Foo( existing_id )
foo.save()
}}}

fails like this:
{{{
Traceback (most recent call last):
  File ""convert_raw.py"", line 7, in ?
    foo.save()
  File ""/usr/lib/python2.4/site-packages/django/db/models/base.py"", line 183, in save
    db_values + [pk_val])
  File ""/usr/lib/python2.4/site-packages/MySQLdb/cursors.py"", line 138, in execute
    self.errorhandler(self, exc, value)
  File ""/usr/lib/python2.4/site-packages/MySQLdb/connections.py"", line 33, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, ""You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `id`=142' at line 1"")
}}}

The generated SQL is:
{{{
UPDATE `proj_foo` SET  WHERE `id`=%s
}}}

A patch to fix this is attached."	defect	closed	Database layer (models, ORM)	dev	normal	fixed			Unreviewed	1	0	0	0	0	0
