Website php script alteration

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

Evner: MySQL, PHP, Script Installering

Se mere: www freelancer com php, work how freelancer php, work freelancer php, what to put on my website freelancer, what its freelancer, what is php freelancer, what i need after html and php to make website, what freelancer changes, wesbite traffic, website freelancer in us, vlog website, script ip address, post work on freelancer, php freelancer mysql, on what freelancer in website made, link website freelancer, just made my day, it person freelancer, ip address script, im freelancer, http www freelancer com download, html website freelancer, how would being a freelancer work, how work as php freelancer, how was freelancer com made

Om arbejdsgiveren:
( 15 bedømmelser ) maple shade, United States

Projekt ID: #966340

Tildelt til:


I can help you fix your mySQL queries!

$80 USD på 1 dag
(88 bedømmelser)

9 freelancere byder i gennemsnit $88 på dette job


quick pro help. ftp and escrow required.

$100 USD på 1 dag
(621 bedømmelser)

Please see PMB.

$250 USD in 5 dage
(30 bedømmelser)

More details provided via private message.

$75 USD in 0 dage
(10 bedømmelser)

Please check pmb. Thank you.

$30 USD in 2 dage
(44 bedømmelser)

How naughty!!! you would think if they could leave it untouched for several years thaye would at least give you a week to fix it unhindered? OK - so basically we have to recode this to not generate to much rubbis Flere

$100 USD på 1 dag
(5 bedømmelser)

Please check the details in the PM Thanks!

$30 USD in 3 dage
(0 bedømmelser)

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.

$30 USD på 1 dag
(0 bedømmelser)

Ready for further investigation.

$100 USD in 2 dage
(0 bedømmelser)