It won't give me my stats. It just lags out and says HEY FUCK YOU.
Maximum execution time of 30 seconds exceeded in /home/******/public_html/lib/getdata.php on line 0
What the hell do I do?!?!
I got my hosting on the phone to fix it. They escalated it to second level support to try and fix it but the guy on the phone sounded like they might not be able to help.
Help please!!!
Looks like PHP is timing out retrieving the data from the DB. I haven't used CPV Lab but maybe you need to clear out some data from the DB?
I'm not sure if >30 s is normal if you have a massive database, or if you really need to clean up the DB or optimise your MySQL or whatever, but an easy way to dodge this would be changing your max_execution_time in php.ini (disclaimer: not sure this is the BEST way to remedy this).
How to do this? I'll assume you know nothing. Create a text file, put this in it:
[PHP]
<?
phpinfo();
?>
[/PHP]
Rename that file info.php. Upload to your server, wherever. Load that file in your browser. Will spit out your PHP install info. Find the listed location of your php.ini file. Log in to your server via SSH (i.e. root access) and navigate to where that php.ini file is. Now you want to edit it. Find the "max_execution_time" line which will no doubt be equal to 30. Change, save, php.ini should be uploaded and will ask to replace the existing file.
After that you need to restart your webserver that uses PHP, i.e. Apache or LiteSpeed. Can restart those from your WHM. Or get your host to do all the above for you, that'd be swell to. You will get a jiffy or so of downtime obviously.
Zeno, that sounds good...but how do I get into my SSH? I am using MyHosting.
You will need a client like WinSCP, works similar to an FTP client. Log in with your root username and password. Check with your host if you don't know if you have root access or don't know the login details (e.g. port, username (generally it is root))
...Or I will need to e-mail my hosting with the error message and apparently they fixed it on their end XD
Thanks Zeno lol!!!
I also recommend Notepad++. That will let you FTP directly in to your server and edit any file as if it was on your desktop. I think it's my number one tool.
Its a paid product... just contact their support for help.
Running a popup campaign? Not much you can do about this other than splitting the traffic up. Even after tweaking MySQL a lot my CPVlab times out if a campaign has more than 500k impressions for that day.
If you're having these problems I'd definitely recommend checking your page load and redirect times, too. If CPVLab's timing out, there's a good chance that your landers may be loading very slowly as well, and that'll murder your conversion rates.