postal icon indicating copy to clipboard operation
postal copied to clipboard

link tracking function is trimming long urls to 255 char

Open hadifarnoud opened this issue 7 years ago • 6 comments

we have long urls which contains token key for download. when I click on the url it redirects to the original one which is trimmed to 255 characters.

hadifarnoud avatar Sep 25 '18 18:09 hadifarnoud

You'll have to modify the database for that specific Postal server to alter the varchar field for url into a text field (or mediumtext etc)

image

Atech or someone else will have to add a migration to make a similar change. I'm not sure how to migrate those databases.

willpower232 avatar Sep 26 '18 15:09 willpower232

I think we can consider this a bug. there are many cases that urls are longer than 255 characters.

hadifarnoud avatar Sep 26 '18 19:09 hadifarnoud

Yes it most certainly is but the only way to fix it is to make the database modifications I have mentioned.

willpower232 avatar Sep 27 '18 08:09 willpower232

I was unable to fix it locally. Not a Rails literate here. I ran into gem install issues and eventually gave up after days of debugging.

can someone please make a pull request for this bug?

hadifarnoud avatar Oct 08 '18 13:10 hadifarnoud

As I said, the problem is in the database so you'll need to use MySQL tools to make the fix for now.

willpower232 avatar Oct 10 '18 08:10 willpower232

I've found a fix but it needs to be merged and run manually at the minute

willpower232 avatar Oct 17 '18 11:10 willpower232