MS SQL Server: Problem with User's history in Admin interface
|Reported by:||Rockallite||Owned by:||nobody|
|Cc:||Triage Stage:||Design decision needed|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
Using ado_mssql for db backend, I find that the django_admin_log table created by manage.py install admin command has a problem. The data type of object_id column is "text", which is one of the unsortable data types (text, ntext, image) in MS SQL Server. That makes the user history in Admin interface unusable, throwing expections.
Also it doesn't make much sense if an ID column is of "text" data type. Instead, the data type should be "integer". So the contrib/admin/models.py file has to be modified. I applied the change, and the user history page worked fine.
Change History (10)
comment:1 Changed 8 years ago by mtredinnick
- Summary changed from User history in Admin interface won't work to MS SQL Server: Problem with User's history in Admin interface
comment:4 Changed 7 years ago by Simon G. <dev@…>
- Triage Stage changed from Unreviewed to Design decision needed
comment:5 Changed 6 years ago by jacob
- Keywords ado_mssql added; django_admin_log, object_id removed