Im doing CPV and have this error show up when too much traffic goes through (30,000+)

When I click on a link or I notice traffic is not updating in SPYVIEW. This is what is shown.

INSERT INTO 202_clicks_spy SET click_id='603644', user_id = '1', aff_campaign_id = '238', ppc_account_id = '18', click_cpc = '0.01000', click_payout = '45.00', click_filtered = '1', click_alp = '0', click_time = '1256867773'

The table '202_clicks_spy' is full

All my links are showing this in test view and the "clicks" stop being viewable.

The links still seem to be good external tests show still re-directing, BUT SPY VIEW freezing and test shows that it looks like the links are "Down" are not good!

Anyone know whats going on ?

MY sql DB is around 450MB and host says thats not a problem. Did check and repair DB. Everything checked out there.

I have shut down traffic tell I find out whats up.

Phoenix

Good talking to you on the phone today, although we fixed it I wanted to post a solution here in the forum so other would be able to make the mods until we upgrade the official distribution of p202

To fix this problem, run this command in your phpmyadmin

ALTER TABLE `202_clicks_spy` ENGINE = MYISAM

ALTER TABLE `202_last_ips` ENGINE = MYISAM

Thanks

Nana