Hello, I run the wesbite [url removed, login to view] Ive had the site for about 2 years now & have been using hostgator for hosting. Everything has been fine & we have been getting the same amount of traffic for roughly the last 7 months. However one day last week, we started getting an error messege when clciking on a video. You can view this error messege by clicking on any of the videos here at this link [url removed, login to view]
Then I recieved an email from hostgator that stated the following
Chiefly the MySQL queries that were being made are a problem. Each time they run, several thousand rows are returned at random, which can take quite some time when several of them are being made at once. You can see some examples of why this is this sort of query can cause issues as more and more rows are added, as well as some possible changes that can be made here ([url removed, login to view]). You will need to make some modifications to this query, or consider caching this query for some time, and then getting a different random result after that time has passed. Likely the original author would be able to assist you with making such a change.
If you reply back to this with your IP address ([url removed, login to view]) we will be more than happy to go ahead enable HTTP access for you, so that you can safely work on the script without it causing further issues. Please let us know how you would like to proceed.
I have attached the full email from hostgator to this post being that there wasnt enough room for me to post it on freelancer in its entirety. So please download the attachment so you can read the full email.
Now the person that made my site originally used php melodys script. [url removed, login to view] I know that php melody has put out alot of upgrades since my site was first created. Im not really too savvy when it comes to these types of issues, so I dont know if we just simply need an upgrade that will fix this problem, or some other kind of other alteration of the script. Please let me know if you understand what the issue is. Thank You
9 freelancere byder i gennemsnit $88 på dette job
Hello. I can help you fix those errors. My IP is: [url removed, login to view] I looked at the error log that you sent but still I need to look on the code to solve this problem. Best regards.