Violation of Unique Key constraint

[ninajlu]

('23000', "[23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'UQaccounts70648D1C466017C6'. Cannot insert duplicate key in object 'dbo.accounts_telemetryevent'. The duplicate key value is (). (2627) (SQLExecDirectW); [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (3621)") I am using pyodbc as follows to link a Django app to Azure SQL db: DATABASES = { 'default': { 'ENGINE': 'sql_server.pyodbc', 'NAME': 'db', 'USER': 'xxxx', 'PASSWORD': 'xxxx', 'HOST': 'xxx', 'PORT': '1433', 'OPTIONS': { 'use_legacy_datetime' : True, },

   }
}

I added use_legacy_datetime to correct for an error that said Unicode object didn't have timezones. However, it does not seem like the database is creating primary keys correctly since it is trying to add a new entry with a key that is NULL when it usually just generates a unique primary key in another DB like MySQL or SQLite, which I was using before. Do you have any thoughts on why this might be? The unique primary key of a new entry should not be NULL--it should be generated automatically and be unique and it isn't doing that for some reason. Thus, any additions to the db just aren't working due to duplicate unique keys that are Null.

[michiya]

Thank you for reporting and sorry for my delay. Could you give me your model definition and code snippet to reproduce the error?

[hoscanoa]

class Menu(models.Model):
    descripcion = models.CharField(verbose_name='descripción', max_length=20)
    link = models.CharField(max_length=100)
    icono = models.CharField(verbose_name='ícono', max_length=100, blank=True, null=True)
    padre = models.OneToOneField('self', blank=True, null=True)