It wasn't doing it much now it's happening a lot. When I try to see converted clicks:
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/xxxx/public_html/xxx/202-config/functions.php on line 16 Out of resources when opening file './xxxxx_xxxxx/202_clicks#P#p49.MYD' (Errcode: 24) SELECT COUNT(*) AS clicks, AVG(2c.click_cpc) AS avg_cpc, SUM(2c.click_lead) AS leads, SUM(2c.click_payout*2c.click_lead) AS income FROM xxx_clicks AS 2c LEFT JOIN xxx_clicks_advance AS 2ca ON (2ca.click_id = 2c.click_id) LEFT JOIN xxx_clicks_site AS 2cs ON (2cs.click_id = 2c.click_id) LEFT JOIN xxx_aff_campaigns AS 2ac ON (2c.aff_campaign_id = 2ac.aff_campaign_id) LEFT JOIN xxx_aff_networks AS 2an ON (2an.aff_network_id = 2ac.aff_network_id) WHERE 2c.user_id='1' AND 2c.ppc_account_id='31' AND (2c.click_alp = '1' OR (2ac.aff_campaign_deleted='0' AND 2an.aff_network_deleted='0')) AND click_lead='1' AND 2c.click_time > 1352966400 AND 2c.click_time <= 1353052799
Most likely a mysql config issue:
Try increasing the open_file_limit setting in my.cnf
You may want to ask you host to help you if you have no clue
Yes it's true I have no clue... I've asked them, thanks Nana//