RESPOND ASAP (FAST SERVER - LINUX -PHP BUG2)

IN PROGRESS
Bids
11
Avg Bid (USD)
$30
Project Budget (USD)
$30 - $250

Project Description:
This is very fast to fix. I will pay anyone $15 to fix this. My database was disabled by godaddy because they said some script is causing it to overload their system. They send over.... (the info below)

It has come to our attention that your hosting account, specifically the jandhdbdatabase is causing the shared resources to be over-utilized. This, in turn, affects the usage by other customers.

============================
We have disabled your database to return the server to normal usage. To re-enable your database, you will need to correct the following query:

select id from tbl_asocialpedia_edits where asocialpedia_id=9

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tbl_asocialpedia_edits ref asocialpedia_id asocialpedia_id 9 const 5215163 Using where; Using index

This query examines 5215163 rows, which is unacceptable in shared hosting.
============================

and when i ask them which file causing that they said

=========
We are unsure of what file is running the query. The query invoked can be the result of several scripts providing information for a query, and so cannot be single-targeted. Additionally, one script can run several different types of queries based on input, and so on. Thus, we cannot detail which file is causing the issue. The issue may stem from said files not being specific enough on the query, also.

Lastly, we cannot re-enable the database until you have provided information to us as to what may be causing the issue, and have given a plan of action to fix it. When this information has been obtained, please reply with your plan so we may reinstate the database to allow completion of the troubleshooting.

Please contact us if you have any further issues.
=================

I know this is very fast to fix if you know what you are doing. If you can fix this i will release $15 immediately just find hte file that is causing the problem and rename it or delete it thanks. Please bid $15 for this quick work.

Before you bid please answer the questions.
1. what do you think the problem is?
2. how would you go about to find out which file it is our website has 1000+ files
3. what is the best way to fix this?

Skills required:
Linux, MySQL, PHP, System Admin, Web Security
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 1 days
Hire Adecode
$ 30
in 1 days
Hire developerhari
$ 30
in 1 days
$ 30
in 1 days
Hire rayinblair
$ 30
in 1 days
$ 30
in 0 days
Hire jetzumy2k
$ 30
in 1 days
Hire Metonym
$ 30
in 1 days
Hire pallavas1
$ 30
in 1 days
Hire macrosoft2010
$ 30
in 0 days