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://

  • I've answered a more general version of your question below. – Alan Dixon Nov 6 '19 at 15:19

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"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.