Starting getting a mySql error message all of the sudden

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Locked
danielbone1

Starting getting a mySql error message all of the sudden

Post 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
Dee
Power Poster
Power Poster
Posts: 1197
Joined: Sun Mar 19, 2006 8:46 pm

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

Post by Dee »

Hmm, this was reported before. No idea what's causing it though (anyone else?)
Dee
Power Poster
Power Poster
Posts: 1197
Joined: Sun Mar 19, 2006 8:46 pm

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

Post by Dee »

It seems ADOdb tries to connect to the database for mysql_real_escape_string without using a username and password.
Ted
Power Poster
Power Poster
Posts: 3329
Joined: Fri Jun 11, 2004 6:58 pm

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

Post by Ted »

Sounds like we need to switch everything back to mysql_escape_string.  Go PHP!  :)
danielbone1

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

Post by danielbone1 »

So where do I go from here?

Is there something I can do to fix this?
danielbone1

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

Post 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
tsw
Power Poster
Power Poster
Posts: 1408
Joined: Tue Dec 13, 2005 10:50 pm

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

Post 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....
danielbone1

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

Post 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
tsw
Power Poster
Power Poster
Posts: 1408
Joined: Tue Dec 13, 2005 10:50 pm

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

Post 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
danielbone1

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

Post 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. 
tsw
Power Poster
Power Poster
Posts: 1408
Joined: Tue Dec 13, 2005 10:50 pm

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

Post by tsw »

well thats new...

I have no idea but it sounds more like server issue
Locked

Return to “CMSMS Core”