CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Civimail create 15,000 urls to track!
Pages: [1]

Author Topic: Civimail create 15,000 urls to track!  (Read 1782 times)

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Civimail create 15,000 urls to track!
October 23, 2007, 03:16:37 am
So if I do not upload a text file and only and html and let civimail create the text file I get 15,000 urls to track.
Now if I run this query
 SELECT *
FROM `civicrm_mailing_trackable_url`
WHERE `mailing_id` =15
AND url NOT LIKE '%optOut%'
AND url NOT LIKE '%unsubscribe%'
ORDER BY `civicrm_mailing_trackable_url`.`url` ASC
I get the 8 that I want.  Can I just run a query to delete the rest.
Versus
SELECT *
FROM `civicrm_mailing_trackable_url`
WHERE `mailing_id` =15
where I get 15,000

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Civimail create 15,000 urls to track!
October 23, 2007, 04:27:41 am
The optOut and unsubscribe URLs (as well as any other ‘internal’ CiviCRM ones) should not be tracked (nor replaced in the final mailing).

Do you use CiviCRM 1.9 beta? I think we addressed this in 1.9; if you have this in a 1.9 install, please file an issue in our issue tracker.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

alfred_nutile

  • Ask me questions
  • ****
  • Posts: 464
  • Karma: 14
    • River Valley Tech Collective
Re: Civimail create 15,000 urls to track!
October 23, 2007, 05:37:46 am
I am on the verge of going to 1.9 just need civinode to work which it is not last time I looked.
If I can get civinode to work again the I would go with 1.9.
Thats why I am not sure if this is worth spending time on?
I ran the above query and cleared out any that where not already tracked.
Al

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Civimail create 15,000 urls to track!
October 23, 2007, 06:25:09 am
If it’s a bug only in 1.8, then we won’t fix it (as it’s not critical). If it’s still a bug in 1.9 beta, we’d like to fix it before the release; still, I believe we tinkered a bit with not replacing ‘internal’ URLs in 1.9, and I can’t recall any situation where such URLs would get replaced in my tests.

It’d be great if you could test whether this bug still happens in your case in 1.9 beta so we can fix it before 1.9 goes stable.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Civimail create 15,000 urls to track!

This forum was archived on 2017-11-26.