Page 1 of 1

Starting getting a mySql error message all of the sudden

Posted: Wed Oct 25, 2006 2:29 am
by danielbone1
I was changing some content in the admin area last week and when hitting submit it gave me this error all down the screen.
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/username/public_html/lib/adodb_lite/adodbSQL_drivers/mysql/mysql_driver.inc on line 174
Then the site started just giving me a url not found page.  It seemed to work about an hour later, but I have been getting emails stating that the site is doing down alot.  I am assuming it is from this error.  Tonight I went in again to work on some content and it worked on one page and then I tried another and hitting submit gave me the same error. 

I contacted my host and he said everything is resolving fine on his end. 

I'm at a loss.  I haven't changed anything config wise for a few months.  Just wondering how and why this just started happenning.

Any help would be greatly appreciated.

Dan

Re: Starting getting a mySql error message all of the sudden

Posted: Wed Oct 25, 2006 8:36 am
by Dee
Hmm, this was reported before. No idea what's causing it though (anyone else?)

Re: Starting getting a mySql error message all of the sudden

Posted: Wed Oct 25, 2006 8:39 am
by Dee
It seems ADOdb tries to connect to the database for mysql_real_escape_string without using a username and password.

Re: Starting getting a mySql error message all of the sudden

Posted: Wed Oct 25, 2006 9:55 am
by Ted
Sounds like we need to switch everything back to mysql_escape_string.  Go PHP!  :)

Re: Starting getting a mySql error message all of the sudden

Posted: Wed Oct 25, 2006 3:31 pm
by danielbone1
So where do I go from here?

Is there something I can do to fix this?

Re: Starting getting a mySql error message all of the sudden

Posted: Tue Oct 31, 2006 2:51 am
by danielbone1
Hey all,

Sorry to be a pest, but any advice on what i can do about this.  The site was down all afternoon today because of this. 
I have searched and can't find the answer.

Thanks,
Dan

Re: Starting getting a mySql error message all of the sudden

Posted: Tue Oct 31, 2006 7:25 am
by tsw
changing all the mysql-real-escape-string function calls to mysql_escape_string could work, but Im not sure if the parameters are the same.

or I would ask my hosting company why their php version doesnt support it....

Re: Starting getting a mySql error message all of the sudden

Posted: Fri Nov 03, 2006 6:51 pm
by danielbone1
Me Again ...

So I asked the hosting company and they said that it should be working fine for me.  That they support it.

My site was working fine until about a month ago also.  I havent changed anything major since then, but now I can't even change the content
on the site because it keeps giving me the error.  The site is down iat certain times during the day because of this also..

Is there anything on my end that I can do at this point?

Do I need to scrap this and just start fresh with something else?

Dan

Re: Starting getting a mySql error message all of the sudden

Posted: Fri Nov 03, 2006 7:38 pm
by tsw
danielbone1 wrote: The site is down iat certain times during the day because of this also..
Only sometimes?

if it works sometimes it surely is something to do with the server

Re: Starting getting a mySql error message all of the sudden

Posted: Fri Nov 03, 2006 7:48 pm
by danielbone1
What happens is when I try to make a change I will get the error and then the homepage is unreachable for a little while. 

Re: Starting getting a mySql error message all of the sudden

Posted: Fri Nov 03, 2006 8:18 pm
by tsw
well thats new...

I have no idea but it sounds more like server issue