Prosper202 Help: The table ‘202_clicks_spy’ is full

by Bryn Youngblut on April 10, 2009

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.

Share to Google Plus

{ 1 trackback }

Working Prosper202 Fix: The table ‘202_clicks_spy’ is full | Bryn Youngblut
November 1, 2009 at 1:50 am

{ 2 comments… read them below or add one }