Answers.Body: <p>Yes. </p>
  
  <p>There is a way that doesn't involve nginx regex's (<a href="https://xkcd.com/208/" rel="nofollow noreferrer">https://xkcd.com/208/</a>)</p>
  
  <p>If you are comfortable accessing your civicrm database directly you can locate the correct row in the civicrm_mailing_trackable_url and update the value of the url.</p>
  
  <p>If you run </p>
  
  
  
  <pre><code>select id, url, mailing_id from civicrm_mailing_trackable_url where mailing_id = X;
  </code></pre>
  
  <p>Where X is the mailing id - you will get a list of urls for that mailing and you should be able to pick out the broken link and update it.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-05-08T03:26:21.290Z
Answers.LastActivityDate: 2019-05-09T20:01:20.253Z
Answers.LastEditDate: 2019-05-09T20:01:20.253Z
Answers.UserDisplayName: Luke Stewart
Body: <p>I've just realised I've sent an email out with a broken link.</p>
  
  <p>Unfortunately it's munged in a way that means that I can't easily catch it with a drupal redirect.</p>
  
  <p>I could probably figure out an nginx regex to match this - but is there an easier way?</p>
  
Tags: <civimail>
Title: Mailing sent with wrong link
ThreadText: # Mailing sent with wrong link
  
  (Asked by: username_0 on 2019-05-08)
  
  I've just realised I've sent an email out with a broken link.
  
  Unfortunately it's munged in a way that means that I can't easily catch it with a drupal redirect.
  
  I could probably figure out an nginx regex to match this - but is there an easier way?
  
  **Tags:** civimail
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2019-05-08. Score: 1
  
  Yes.
  
  There is a way that doesn't involve nginx regex's (<https://xkcd.com/208/>)
  
  If you are comfortable accessing your civicrm database directly you can locate the correct row in the civicrm\_mailing\_trackable\_url and update the value of the url.
  
  If you run
  
  ```
  select id, url, mailing_id from civicrm_mailing_trackable_url where mailing_id = X;
  
  ```
  
  Where X is the mailing id - you will get a list of urls for that mailing and you should be able to pick out the broken link and update it.
  
  
  ---
  
  