We're updating the issue view to help you get more done.Learn more

Asset Download - AssetID is urlEncoded and throwing a SQL error

On asset download...

Detail:
Data truncation: Data too long for column 'asset' at row 1

SQL:

1 insert into `_version_psys_asset_derivative` ( `datemodified`, `_version_is_latest_draft`, `_version_is_draft`, `asset_type`, `asset`, `_version_has_drafts`, `is_trashed`, `datecreated`, `_version_is_latest`, `_version_changed_fields`, `asset_version`, `id`, `_version_author`, `storage_path`, `label`, `_version_number` ) values ( {ts '2018-02-21 15:02:13'}, true, false, 'PENDING', '42EAA9A0%2D6A5F%2D414C%2D93705EA264E80FFA', false, false, {ts '2018-02-21 15:02:13'}, true, ',datemodified,_version_is_draft,asset_type,_version_has_drafts,asset,is_trashed,datecreated,asset_version,id,storage_path,label,', null, '2D46DD16-7C6E-441A-833AEE9EE110E66E', null, 'PENDING-57EF1C84-168D-4593-994BE547BB7DE794', 'productitem7985e2ccc44d4ee701927eb5750da127', 235143924 )

Note the asset ID value is encoded:
42EAA9A0%2D6A5F%2D414C%2D93705EA264E80FFA

This is instigated from AssetDownload.cfc - line 24
asset = assetManagerService.getAssetDerivative( ... )

Status

Assignee

Unassigned

Reporter

Niall O'Doherty

Accepted

Yes

Fix versions

Priority

Medium