If you use prosper202 and use it a lot you have most likely seen this error, if not, you’re either lucky or don’t have a ton of traffic.
I use to get this error all the time because the table would get full before it had time to whipe the stuff older than 24 hours.
So how can you fix this?
The quick fix is to reboot your MySql service. This will fix it right away, don’t worry all your click data is still stored!
How to prevent this from happening again?
There is 2 options I know of to prevent this from happening in the future, the first is to increase your Post_Max_Size to as high as you can.
If your table is still filling up too quickly you can set it up to clear out every hour instead of every day.
Goto /202-cronjobs/index.php
Goto line 95 and add this
/* ——– THIS CLEARS OUT THE CLICK SPY MEMORY TABLE ——— *///this function runs everyday at midnight to clear out the temp clicks_memory table $from = time() – 86400;
//this makes it so we only have the most recent last 24 hour stuff, anything older, kill it.
//we want to keep our SPY TABLE, low
$click_sql = “DELETE FROM 202_clicks_spy WHERE click_time < $from”;
$click_result = _mysql_query($click_sql);
//$click_count = mysql_affected_rows();
So it’ll be right after the
if ($check_count == 0 ) {
add that line of code, TEST TO MAKE SURE IT WORKS,
that should clear out your spy every hour, instead of the default, every-day! lets see if that fixes it for you.
Credits to Wes for the second fix which was found in the thread here.
{ 1 trackback }
{ 2 comments… read them below or add one }
hmm, i’ve run more than a million clicks through multiple prosper domains and never gotten this error. I guess i’m just lucky? I’ve actually never gotten a sql error from prosper
Brandons last blog post..Protecting Against Your Prosper202/Tracking202 Server Going Down
Reply
Bryn Youngblut Reply:
April 12th, 2009 at 9:24 am
It’s only if it happens during the 24 hour period, where the spy table can get full before it’s wiped.
Reply
This is one of the reasons I no longer host p202 for myself. I was getting random table and SQL errors, and really had no where to turn to for support. I am not a server admin, a mySQL expert, or anything of the sort. Trying to run p202 on my own servers takes away time from actual marketing and making money.
I firmly believe that if something is not your core competency, you should outsource or have an expert host/administer it for you.
My previous company was probably spending close to $500k/year hosting MS Exchange because they lacked the experience, know-how, etc. System admins, outages, weird policies, no archiving, OWA was broken half the time — what a disaster it was. This was a $100mil a year company wasting tremendous time and resources and hosting email for themselves when they could have paid a nominal fee per user for a hosted solution.
So how many campaigns are people not able to do because they are wasting time with p202 or other apps they are not qualified to run it? (not singling you out, just making a point in general)
newjerseys last blog post..Making money with affiliate marketing – networks I use
Reply