Cannot update identity column 'id' when adding new question?

Question

Hi guys,

When posting a new question to my new installation of OSQA I'm getting the following error:

(-2147352567, 'Exception occurred.', (0, u'Microsoft OLE DB Provider for SQL Server', u"Cannot update identity column 'id'.", None, 0, -2147217900), None)

UPDATE [forum_node] SET [body] = ?, [last_activity_by_id] = ?, [last_activity_at] = ?, [title] = ?, [tagnames] = ?, [node_type] = ?, [active_revision_id] = ?, [id] = ? WHERE [forum_node].[id] IN (?)

I'm using the django-mssql provider, but I'm not sure the problem lies there. It seems for some reason the ORM is trying to update the id (with the same value it searches on).

Any ideas why this might be? as far as I can establish other routines work fine (such as creating new users). This is on the latest version in the trunk.

Thanks

Answer 1

I'm very new to both Python and Django. Please correct me or offer suggestions if there is a better way, but I was able to work around this by patching _get_update_kwargs() in forum/models/base.py.

Original

def _get_update_kwargs(self):
        return dict([
            (f.name, getattr(self, f.name)) for f in self._meta.fields if self._original_state[f.attname] != self.__dict__[f.attname]
        ])

Patched

def _get_update_kwargs(self):
    return dict([
        (f.name, getattr(self, f.name)) for f in self._meta.fields if self._original_state[f.attname] != self.__dict__[f.attname] and type(f) is not models.AutoField
    ])
                                                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Cannot update identity column 'id' when adding new question?

Original

Patched

Follow this question

Learn more about OSQA

Related questions