Skip to content

Instantly share code, notes, and snippets.

@1stevengrant
Created February 22, 2012 11:11
Show Gist options
  • Save 1stevengrant/1884188 to your computer and use it in GitHub Desktop.
Save 1stevengrant/1884188 to your computer and use it in GitHub Desktop.
ngen file field upgrade - Swap out XX for your file field ID and swap out YY for your file upload location ID.
UPDATE exp_channel_data
SET field_id_XX = CONCAT('{filedir_YY}', field_id_XX)
WHERE field_id_XX != ''
AND field_id_XX NOT LIKE '{filedir_%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment