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) »
  • problem with Click-through tracking
Pages: [1]

Author Topic: problem with Click-through tracking  (Read 8926 times)

SeanBurlington

  • Guest
problem with Click-through tracking
January 18, 2008, 10:00:31 am
Hi,
  I've got a problem with click-through tracking.

If I enter email by editing online it works fine

But when I upload files (OpenOffice doc saved as html and txt)

- the link is recorded incorrectly so that the tracking link is embedded in the email - but the user is then redirected incorrectly

The problem seems to be the links that get recorded in the database

The email contains
http://ssca/sites/all/modules/civicrm/extern/url.php?u=7&qid=2

but the user is redirected to
http://ssca/sites/all/modules/civicrm/extern/HREF=%22http://www.southsomersetclimateaction.org.uk/2007/08/24/the-sustainable-community-strategy-for-south-somerset/%22
(which gives me a page not found)

HTML email (snippet of : select * from civicrm_mailing)
Code: [Select]
   <TD WIDTH=178>
                        <P LANG="en-GB" STYLE="margin-top: 0.18cm; page-break-after: avoid">
                        <FONT FACE="Times New Roman, serif"><FONT SIZE=5><B><FONT COLOR="#0000ff"><U><A HREF="http://www.southsomersetclimateaction.org.uk/2007/08/24/the-sustainable-community-strategy-for-south-somerset/"><FONT SIZE=2><FONT FACE="Arial, sans-serif">The
                        Proposed Sustainable Community Strategy for South Somerset</FONT></FONT></A></U></FONT></B></FONT></FONT></P>
                </TD>


database table:
Code: [Select]
select * from civicrm_mailing_trackable_url;
+----+-----------------------------------------------------------------------------------------------------------------------+------------+
| id | url                                                                                                                   | mailing_id |
+----+-----------------------------------------------------------------------------------------------------------------------+------------+
|  1 | http://drupal.org/node/167483                                                                                         |          1 |
|  2 | http://ftp.drupal.org/files/projects/update_status-5.x-2.0.tar.gz                                                     |          1 |
|  3 | http://drupal.org/node/143593                                                                                         |          1 |
|  4 | http://ftp.drupal.org/files/projects/update_status-5.x-2.x-dev.tar.gz                                                 |          1 |
|  5 | HREF="http://www.southsomersetclimateaction.org.uk/"                                                                  |          2 |
|  6 | HREF="http://www.southsomersetclimateaction.org.uk/2007/02/17/evidence-submitted-to-the-house-of-commons/"            |          2 |
|  7 | HREF="http://www.southsomersetclimateaction.org.uk/2007/08/24/the-sustainable-community-strategy-for-south-somerset/" |          2 |
|  8 | HREF="http://www.southsomersetclimateaction.org.uk/2007/05/14/ilminster-town-plan/"                                   |          2 |
|  9 | http://www.southsomersetclimateaction.org.uk/2007/07/01/planning-policy                                               |          2 |
+----+-----------------------------------------------------------------------------------------------------------------------+------------+


any help much appreciated

msn

  • I post frequently
  • ***
  • Posts: 152
  • Karma: 6
  • Please talk to the other site
Re: problem with Click-through tracking
January 26, 2008, 12:12:15 pm
Strange, I have the same issue.
I made a civimail.drupal setup a 3 monts ago, testing and working (mailings and click trough)!

Now a made another domain connected to the civicrm db: mailings are going out, problems with click trough.

I wil search in my setting, any hinds..? 

msn

  • I post frequently
  • ***
  • Posts: 152
  • Karma: 6
  • Please talk to the other site
Re: problem with Click-through tracking
January 26, 2008, 12:42:27 pm
It is solved here:
In html I had to change some url code from drupal root to domain.

fen

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 13
    • CivicActions
  • CiviCRM version: 3.3-4.3
  • CMS version: Drupal 6/7
  • MySQL version: 5.1/5.5
  • PHP version: 5.3/5.4
Re: problem with Click-through tracking
January 26, 2008, 10:00:30 pm
I think I may be seeing something similar.  I've validated the HTML that's being used (Valid HTML 4.0 Transitional) but I'm getting some links broken in a strange way in v1.9 (they worked in v1.7)...

Input:
Code: [Select]
<TD WIDTH=90 HEIGHT=17 BGCOLOR="#92005a">
<DIV ALIGN=CENTER><A HREF="http://realitysandwich.com/psyche"><B><FONT FACE="Arial Narrow, Arial, sans-serif"><FONT COLOR="#ffffff">Psyche</FONT></FONT></B></A></DIV>
</TD>

Output (notice the missing href="...">):
Code: [Select]
<TD WIDTH=90 HEIGHT=17 BGCOLOR="#92005a">
<DIV ALIGN=CENTER><A http://www.realitysandwich.com/sites/realitysandwich.civicactions.net/modules/civicrm/extern/url.php?u=383&qid=10331><B><FONT FACE="Arial Narrow, Arial, sans-serif"><FONT COLOR="#ffffff">Psyche</FONT></FONT></B></A></DIV>
</TD>

I've also noticed that a message sent using CiviCRM v1.7 began with:
Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
but the same message (sent using "re-use") in CiviCRM v1.9 is missing these declarations.

Any ideas?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: problem with Click-through tracking
January 27, 2008, 06:00:10 am

Can you reproduce this on the sandbox server, and if so, file an issue

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: problem with Click-through tracking
April 01, 2009, 12:37:22 am
I am having the exact same problem with an Open Office Write document saved as HTML. The links seem to be corrupted along the line. I will try to test on the sandbox server. I'm not sure if this was ever done before.


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
   <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
   <TITLE>CiviMail Link Test</TITLE>
   <META NAME="GENERATOR" CONTENT="OpenOffice.org 3.0  (Win32)">
   <META NAME="AUTHOR" CONTENT="Dennis Gray">
   <META NAME="CREATED" CONTENT="20090401;16280000">
   <META NAME="CHANGEDBY" CONTENT="Dennis Gray">
   <META NAME="CHANGED" CONTENT="20090401;16330000">
</HEAD>
<BODY LANG="en-AU" TEXT="#000000" LINK="#0000ff" DIR="LTR">
<P CLASS="western" STYLE="margin-bottom: 0cm"><BR>
</P>
<P CLASS="western" STYLE="margin-bottom: 0cm"><BR>
</P>
<P CLASS="western" STYLE="margin-bottom: 0cm"><BR>
</P>
<P CLASS="western" STYLE="margin-bottom: 0cm"><BR>
</P>
<P CLASS="western" STYLE="margin-bottom: 0cm"><BR>
</P>
<P CLASS="western" ALIGN=CENTER STYLE="margin-bottom: 0cm"><FONT COLOR="#ff6600"><FONT SIZE=6 STYLE="font-size: 26pt"><B>CiviMail
Link Test</B></FONT></FONT></P>
<P CLASS="western" ALIGN=CENTER STYLE="margin-bottom: 0cm"><BR>
</P>
<P CLASS="western" ALIGN=CENTER STYLE="margin-bottom: 0cm"><BR>
</P>
<P CLASS="western" ALIGN=CENTER STYLE="margin-bottom: 0cm"><BR>
</P>
<P CLASS="western" STYLE="margin-bottom: 0cm"><BR>
</P>
<P CLASS="western" STYLE="margin-bottom: 0cm"><FONT COLOR="#0000ff"><U><A HREF="http://www.google.com.au/">Google</A></U></FONT></P>
<P CLASS="western" STYLE="margin-bottom: 0cm"><BR>
</P>
<P CLASS="western" STYLE="margin-bottom: 0cm"><FONT COLOR="#0000ff"><U><A HREF="https://webmail1.commerce.nsw.gov.au/">Department
of Commerce Web Mail</A></U></FONT></P>
</BODY>
</HTML>

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Sandbox Server
April 01, 2009, 01:17:53 am
Is the sandbox server different from the demo? If so, how do I access it?

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: problem with Click-through tracking
April 01, 2009, 01:48:20 am
The demo shows the current stable version the sandbox shows the version in development (version 2.3).

Try http://sandbox.civicrm.org

(googling sandbox civicrm also works)
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: problem with Click-through tracking
April 01, 2009, 02:00:53 am
Neither the demo nor the sandbox seem to be able to send out a test CiviMail so I can try to reproduce this.

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: problem with Click-through tracking
April 03, 2009, 05:31:49 pm
I know my comment is on an old post but it is still an open issue and I don't know how to replicate it in the sandbox without having mail turned on. Is there anything else I can do?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: problem with Click-through tracking
April 03, 2009, 07:50:47 pm

hey dennis:

any chance u can reproduce this issue on a 2.2 test install at DA. Rob T probably has a couple of test installs out on your servers :)

thanx

lobo
 
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: problem with Click-through tracking
April 03, 2009, 10:29:25 pm
Thanks, Lobo, but maybe not.

Anyway, we're still at 1.9 in production and it may be several months before we finish the upgrade

conductorchris

  • I post frequently
  • ***
  • Posts: 167
  • Karma: 9
    • Vermont Rail Action Network
  • CiviCRM version: 4.5.0
  • CMS version: Joomla 3.2.7
  • MySQL version: 5.5.32
  • PHP version: 5.3.26
Re: problem with Click-through tracking
April 07, 2009, 08:55:59 am
I've had a similar issue on a Joomla installation which I have not solved, only worked around by changing the link to the generic contributions page I set up and disabling tracking and click-throughs.
Thanks to those who help create and enhance civiCRM!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • problem with Click-through tracking

This forum was archived on 2017-11-26.