Hello guys, my website was fine for 2 months and now all of a sudden it stopped working and I don't know why... I also don't know how or where to start from to troubleshoot the problem...
Here is what happens:
My script (which useless to say, has always worked and nobody has touched or changed in the past months) fails when entering values into the database. I looked at the code and it fails at this line:
if ( !mysql_query($sql, $connection) ) {
echo "Query failed. Try Later";
include ('menu.inc');
}
I know that it fails at that point because it is the only point in that file where the following line appears:
echo "Query failed. Try Later";
and that is exactly the error I get.
Here is what I did so far:
I contacted who wrote the script which of course told me that he can't do anything because if nobody changed anything in the script there is no reason it should stop working!
I contacted my hosting company and they said they haven't changed a thing in the past week.
I logged in to PHPMyAdmin and I tried entering values manually to see if there was a space restriction in effect. The manuals went into the database and appeared on the site, which makes me think it is not an issue of space. Besides the size of my dB is less than 1Mb!
Of course the site successfully takes information from the database, the problem only happens when writing to the database.
I overwrote the file that produces the error with the same file I had backed up on my machine.
This is what I did...
Now I know that you can't troubleshoot for me with so little information but considering the fact that nobody has touched anything and the connection to MySQL when writing data has just stopped working 48 hours ago or so, what would you suggest checking or doing or what do you think could possibly have happened???
I am lost...