SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'sort_order' in order clause is ambiguous

If you encounter the following error, usually when you try to look up after a certain customer in Magento Admin, it is probably because you used Cart2Cart to migrate over to Magento products/customers/orders. For some reason Cart2Cart imported the wrong attribute_set_id. The solution is running the following SQL queries on your Magento database:

UPDATE customer_entity SET attribute_set_id = 0 WHERE 1

UPDATE customer_address_entity SET attribute_set_id = 0 WHERE 1

For more details check the original solution posted on the following Magento Forum thread [1]

Still need help? Get Help Get Help