Uploaded image for project: 'PresideCMS'
  1. PRESIDECMS-1153

Asset Download - AssetID is urlEncoded and throwing a SQL error

    Details

    • Type: Improvement
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects versions: None
    • Fix versions: 10.8.81
    • Labels:
      None
    • Sprint:
    • Accepted:
      Yes

      Description

      On asset download...

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

      SQL:

      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( ... )

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              niall.odoherty Niall O'Doherty
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: