Exception Value: Expression contains mixed types: TextField, IntegerField. You must set output_field.

I get this error here:

It's here:

django-admin-sortable2/adminsortable2/admin.py

Lines 339 to 342 in 7bb2640

    
           def get_max_order(self, request, obj=None): 
        
               return self.model.objects.aggregate( 
        
                   max_order=Coalesce(Max(self.default_order_field), 0) 
        
               )['max_order']

I just add a poor work-a-round:

    def get_max_order(self, request, obj=None):
        return 0

Does this mean that method get_max_order returns a string rather than a number?

What's the field type of the field you're using for ordering? Please show me your model.

Model is here: https://github.com/jedie/PyInventory/blob/140edd20b024af2db974cd3a5cecc6e7285bf765/src/inventory/models/item.py#L25

Work-a-round added here: jedie/PyInventory@4f16e6d#diff-06e796a58db7d52539c1cf5d11602d4bfbd0f96072b0de6a4c54ab55b0795285R88-R90

well, you're using a TextField as ordering variable. For obvious reasons this can't work and should have been discovered by yourself in the first place.

	def get_max_order(self, request, obj=None):
	return self.model.objects.aggregate(
	max_order=Coalesce(Max(self.default_order_field), 0)
	)['max_order']