Skip to content

A Big Prosper202 Fix

Quite some time ago I wrote a post called How To Fix Prosper202 If Spy/Analyze Stops Working.  If you run a lot of traffic to your Prosper202 setup you probably find yourself having to dump the databases often.

Yesterday, the one and only Wes Mahler left a comment on that post stating:

Updated so you don’t have to manually do it each time, we just change the MYSQL TABLE type so it’s no longer a memory table, which removes having any limit at all.

the issue with the above post is it dose clears it, but it’ll fill up again if you have lots of traffic. this fix changes the table type so it won’t have a memory limit any more and will never happen again

The fix can be found at the Prosper202 forums but I’ll copy it here just to make your life easier:

To fix this problem, run this command in your phpmyadmin

ALTER TABLE `202_clicks_spy` ENGINE = MYISAM


The discussion thread can be found here.  Hopefully this saves you from having to dump your databases on a regular basis.

Ad Hustler | Subscribe To Ad Hustler

Published inAffiliate MarketingTracking


  1. Sweet deal! I love it. This fix will make my life a bit easier… now if only I could figure out how to track across multiple pages correctly.

  2. Wass Wass

    Awesome. Thanks for the heads up!

  3. How much traffic do you have to run through P202 for this to be an issue?

  4. Thanks for the heads up! I’ve had a few pubs with this issue. I’ll let them know 🙂

  5. Ben Ben

    @ken you have to run a pretty sizeable amount of traffic to 202. if you’re running 5-20k clicks a day you probably want to do this and think about running it on a dedicated server with memcached.

  6. Ad Dominator Ad Dominator

    Hi Wes, Could you guys put out a new Prosper 1.33 version
    with the new table types plus some other goodies,
    so we don’t have to make the change on every install ?

Leave a Reply

Your email address will not be published. Required fields are marked *