I noticed in my logs I started getting the same error about 30 days ago (although diff. code line, probalby due to version difference).  They occur regardless of user activity on EE, about 5 - 10 every 1 - 3 minutes.  Log file is getting pretty big.

So if I read the above post correctly, resolution is to do a complete re-install or shutoff EE error logging in CP?

EE v1.6.3

Mod note- split from here as that was Tome related and this isn’t.

I’ll give the crew a ‘heads up’- I’m not sure it should be changed to use the new one, but I’m not sure it shouldn’t.  Was depreciated 4.3.0, new option only available as of 4.3.0.  But- I’d imagine putting some error suppression on it if left in makes sense.

For a short fix- could edit system/db/db.mysql around line 636- try using mysql_real_escape_string insteand of mysql_escape_string in:

See if that does the trick.  And I’ll ask the crew as well.

Make sense?

If I change the check and invoking to mysql_real_escape_string I get the following for any site hit.

So there must be a syntax difference for the i/o, as if I just change the function name in the if test, mysql_escape_string() is still ran, so it recognizes the newer version of the function exists.

This function is identical to mysql_real_escape_string() except that mysql_real_escape_string() takes a connection handler and escapes the string according to the current character set. mysql_escape_string() does not take a connection argument and does not respect the current charset setting.

So I’m not sure I can modify the input properly with my limited understanding to be valid for the function.

Thanks for the reply!

Hm- yep, me too. 

Hang tight until I hear back from the crew.  If it’s just throwing messages, it’s not critical.  I’d rather wait to hear what they say than have you do too much experimenting.

Sound good?

Agreed, thanks for passing it on.

Are you seeing anything odd as a result- or is it just the error log?  And can you run down for me again both mysql version and php version?

And- do you have all errors showing?  I wonder if you test this in a template w/php turned on whether we can trigger the error:

The above code does indeed invoke 3 duplicates of the error.

I do not see any results problems that I know of.  I’ve been focusing on getting data entered, generating the forms and learning the hierarchy, so I haven’t paid too close (nor do I have a lot of data) so that I can say definitely no, but I don’t think so.  Just filling up the logs.

PHP v5.2.6
MySQL Client api v5.0.51a (per PHP Info)
MySQL v5.0.51b-community-nt (per MySQL Administrator)

Just letting you know- crew is still looking into this one.

Good morning leejb.  Apologies for the wait you sustained here.  I’ve identified and fixed the issue.  If you’d like to email me (derek.allard@ellislab.com) I’d be happy to provide you with a fixed file to test out.

Hey guys, I am running into the same issue.  I would like to replace the mysql_escape_string with mysql_real_escape_string.  Can you advise how to make this possible?  Currently if I replace it, I get the error mentioned above: “Site Error: Unable to Load Site Preferences; No Preferences Found”.

Thanks!

Hello fireengine,

The way the code in EE works in recent versions is to try mysql_real_escape_string() first, and only if that function doesn’t exist does it try mysql_escape_string(), so you should be fine.  Just be sure you’re running the latest version (and build) of EE.  You won’t need to modify any code to make this happen.