CiviCRM Community Forums (archive)

We keep archived versions of old emails in the news section of the website. Following a recent domain name change (and server move), all of the old email links redirect to [Site URL]/administrator/components/com_civicrm/civicrm/extern/url.php?u=10503&qid=332063 or something similar, instead of the intended page. The links worked prior to the change, and all new links work that we created after the change. I'm assuming this has something to do with the way that CiviCRM stores the links in the database, and the fact that our site URL has changed. Is there an easy way to correct this, without having to go in and edit each link? There are probably upwards of 1000 links that this pertains to.

We're running CiviCRM 4.4 on Joomla 2.5.17. Thanks!

That's a bit beyond my capabilities, unfortunately!

However, I went back in and did a little more digging, and I'm wondering if the issue could be stemming from some cause other than our domain name change. I checked over a dozen emails, and about half had working links, while the other half all redirected to the site back-end. On hover, the links were all formatted the same with /administrator/components/com_civicrm/civicrm/extern/url.php?u=URLID&qid=QueueID.

I checked out the TrackableURLOpen.php file, and found this comment:
  /**
   * Track a click-through and return the URL to redirect.  If the numbers
   * don't match up, return the base url.
   *
   * @param int $queue_id     The Queue Event ID of the clicker
   * @param int $url_id       The ID of the trackable URL
   *
   * @return string $url      The redirection url, or base url on failure.
   * @access public
   * @static
   */

It seems to me that there is a problem with the URL, probably in the queue because I checked a handful of URL IDs in the database and those all matched up. However, instead of returning the base site URL, it returns the admin URL. Where would I need to make a change to prevent this? And is there any way to recover the queue event ID for those that seem to be broken?