back to phpList.org

Advanced Statistics: Links are duplicated in the database


#1

Some links are duplicated in the Advance Statistics tab. See image below.

2019-01-04_2158

I can assure you that the links are the same and wondered why there is an apostrophe on each duplicated link?
My guess would be that the links weren’t escaped properly?


#2

@arnoldfudolig You will need to look at the original html of the campaign to see what has caused this. I suspect it might be caused by inconsistent use of single and double quote characters.


#3

Yup, that’s what I thought at first, but I checked all the links but I was using double quote all through out my html.


#4

@arnoldfudolig Please copy/paste part of the html that has one of the problem links. Use the toolbar code button </> for formatting.

Also, which version of phplist are you using?


#5

One is the VIEWBROWSERURL

<td style="text-align: right;"><a href="[VIEWBROWSERURL]" style="text-decoration: none; color: #1e90ff;">View this email in your browser </a></td>

And the normal link is this:

<td style="width: 266px;"><a href="https://www.wash100.com/" rel="noopener" target="_blank"><img height="auto" src="https://salesrobot.com/uploadimages/image/default/Tile%20Ad%202019%20(300X250).png" style="border: 0; display: block; outline: none; text-decoration: none; height: auto; width: 100%;" width="266" /> </a></td>

It is pretty much the same with all other links. I’m still using the version 3.3.2.


#6

@arnoldfudolig All I can think of is that an earlier draft version of the campaign, or possibly the template, did have a problem with double-quotes. If you sent a test email then those corrupted URLs would have been used.

I have looked at the Statistics plugin, which provides the Advanced Statistics page, and do not think that the plugin is causing the problem.


#7

I think I may have found the problem, links are duplicated when using the the TinyMCE editor, but when using the CKEditor, everything seems fine. Nothing was duplicated.