When user has uploaded a new asset that consists of a really long name.
Gilkes Turbine No 490 with 30hp invented by Henry Watson, Lord Armstrong of Cragside and Gilkes, credit D Burton Feature Services Ltd.jpg.jpg
It then generates slug like this:
The slug is still less than 150 characters.
However, when the it merges with the website domain and etc, the asset url becomes a really long text.
Pull request created
This is an issue for asset_derivative as well where the asset URL is too long due to long file name. Especially when asset derivative url contains 2 sets of ID, the asset and the derivative ids.
I would suggest to remove the index of the asset url and create a new field to keep the hash of the asset URL and index the hash value instead. This will allow long asset url without the restriction od 255 characters. The changes needs to be implemented on both asset and asset derivative’s asset_url field.