Back in April I wrote about a temporary (and most likely outdated) fix to the error I face so often when sending mass volume through prosper202.
Recently Wes (thank god) let me know about a way to fix it for good and I can say I haven’t had a problem since I applied this 2 second update to my prosper202.
If you’ve ever gotten or fear getting the “The table ‘202_clicks_spy’ is full” error message, which essentially makes all your traffic go to a white screen until you finally notice it and reboot your mysql then you will want to do this update (holy run on sentence).
When logged in to phpMyAdmin run these sql statements SEPERATELY:
ALTER TABLE `202_clicks_spy` ENGINE = MYISAM
ALTER TABLE `202_last_ips` ENGINE = MYISAM
That’s it, the problem shouldn’t happen again and hopefully you’ll save some potentially lost monies.
{ 1 trackback }
{ 3 comments… read them below or add one }
Alternatively, I believe he mentioned the latest ver of p202 has been patched, so if you update, the spy table issue should be resolved?
Reply
Bryn Youngblut Reply:
November 1st, 2009 at 1:05 pm
Well that’s what he said should be but I was on the latest version and still getting those problems.
Reply
andrew wee Reply:
November 1st, 2009 at 6:21 pm
Ok, so the phpMyAdmin patch resolves the prob in the latest p202 ver?
No recurring probs thus far?
Reply
Bryn Youngblut Reply:
November 1st, 2009 at 7:41 pm
Yup has for me so far – that was the point of this post. 😉
Thanks Bryn! As always your blog is one of the few I read for reasons like this!
Reply
Thanks Bryn… Of course this happened to me for the first time ever when I was on vacation. After traveling for 2 days I check up on my campaigns only to realize one of my larger offers made no money.
Last time I went on vacation my hosting went down.
Reply
Bryn Youngblut Reply:
July 23rd, 2010 at 10:21 am
Glad this helped you 🙂
Reply