Login to download the latest version of Mint and your favorite Pepper, purchase additional licenses, or post in the Forum. Don't have an account? Create one!

In Partnership with Media Temple

Mint Forum

Referrals mishandling URLs

Posted on Mar 24, '07 at 07:27 pm

I’m having a problem with my referrers. All of the links now have a weird http%3A in front of them instead of http://, which means the links I do get look something like this: http://truthandthedevil.com/mint/http%3 … e%20Search

How can I fix this?

Sam Brown
Third-Party Pepper Developer
Posted on Mar 25, '07 at 05:29 am

The solution for this can be found by searching the forums.

Simply create a .htaccess file in your /mint/ directory with the following:

<IfModule mod_rewrite.c>
  RewriteEngine   off

It is more than likely to do with a .htaccess rule you have in your root directory cauising the character encoding problems.

Posted on Mar 25, '07 at 12:11 pm

Thank you. I apologize for not searching thoroughly enough.

You can then also run a couple of quick sql ommands to update your database:

update mint_visit set resource_title = replace(resource_title,’%3A’,’:’);

This replaces all ‘%3A’ in the resource_title field with a ‘:’

You will find that you need o do this a couple of times in different fields.

Oh and BackUp your database.

Posted on Apr 02, '08 at 12:13 pm

Thanks! Now all new urls are correct.

However, the query gives me the following error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘??%3A,:)’ at line 1

What gives? Is this another collation issue?

Posted on May 31, '08 at 11:08 pm

Leevigraham’s SQL has some “fancy” apostrophes in it, so copying and pasting that snippet verbatim won’t work. Here it is again, all cleaned up:

update mint_visit set resource_title = replace(resource_title,'%3A',':');

Remember to backup your database first!

You must be logged in to reply. Login above or create an account

Hey there, I have officially suspended sales and support of Mint. The Create Account, Add License, Transfer License, and Contact forms have been disabled. Existing customers may continue to login and download Mint.

More info Continue