CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this community
When attempting to reuse a mail, things work normally until clicking 'Edit' which results in a mostly blank page - some of the Mosaico page is shown but not the content.
What turns out to be important is that the site recently moved from using http:// to https://
If you change your site's domain, the specific sql that you can run to fix your templates and (separately) your existing messages (e.g. those in progress or in case you want to copy them):
From "olddomain.org" to "newdomain.org":
update civicrm_mosaico_template set metadata = replace(metadata,'olddomain.org','newdomain.org');
update civicrm_mailing set template_options = replace(template_options,'olddomain.org','newdomain.org');
If your old/new domains share some parts (e.g. you're going from domain.org to www.domain.org) you'll want to be careful not to run it more than once and it may mess up something else.
If you're also changing the protocol (http to https), then it's a bit tricky because the template_options field is in json notation with "/" escaped. You could do it in a separate step, replacing 'http' with 'https' for example.
There's an open issue here: https://github.com/veda-consulting/uk.co.vedaconsulting.mosaico/issues/87 to try and fix it.
Using the browser network tools shows a failure to load the template with a "mixed content" message. The problem is that the template metadata includes the full URL of the template.
The fix is to update the template URL in the Mosaico metadata to use https:// in place of http://
With db access, you can update template_options in civicrm_mailing.
Alternatively, start from cv api Mailing.get id=...
There is now an API call to update the templates for you. See the docs
cv api MosaicoTemplate.replaceurls from_url="http://old.server.org" to_url="https://new.server.org"
