Tracking cuts off links after 260 characters

Hi @mekek,

Problem is with Mailpoet core system. Mailpoet plugin save user generated links in a database table namely wp_mailpoet_newsletter_links under url key.

That url key is set to 255 fixed length in database schema. So, if you enter any link that length more than 255, will always be cut off to 255.

I do think it’s Mailpoet development bug. They must not make url key length limited because a tracking url could have multiple tracking parameter , redirection etc. So, if anyone from Mailpoet development team see this message please think about it. Because it will affect lots of user in various scenario.

Now how can you fix it until Mailpoet respond. Here are few suggestions ->

1. You can shortify your url using some online link shortner service like https://goo.gl / https://bit.ly . Using these service you can shorten your url to under 20 character .

2. If you don’t like url shortner than you will have to manually edit mailpoet database wp_mailpoet_newsletter_links structure where you have to set url keys type to var_char and length to 500. ( which is not recommend unless you have mysql database related knowledge )

Let me know if that helps.

Thanks

• This reply was modified 7 years, 3 months ago by tamim71.

Thanks. I changed the varchar characters value from 255 to 500 and now it works! ??
The shortify-tip doesnt work because the vars are not filled in that way. ([subscriber:lastname] etc.)

Thanks, Marco

@tamim71 thanks for the heads-up. Your feedback was already forwarded to our developers.