ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

mysql_real_escape_string() error

August 02, 2007 2:21pm

Subscribe [1]
  • #16 / Aug 02, 2007 4:17pm

    Big Skillet

    364 posts

    ok… hallelujah… got all that upgraded and managed to save my site.  I’m still getting some hardcore errors though.  I noticed that if I close FireFox and open it back up my site works fine… no errors, but the minute I open up the control panel, it creates errors in both the CP and Site.  Let me show you some screen shots.

  • #17 / Aug 02, 2007 4:21pm

    Big Skillet

    364 posts

    Screenshots

  • #18 / Aug 02, 2007 4:40pm

    Lisa Wess

    20502 posts

    Ok, since we know about those errors and are investigating, since they are not interrupting your site, head to Admin -> Output and Debugging and turn PHP errors off.  We know the issue and are investigating so we don’t need to see a ton of copies of them. =)

  • #19 / Aug 02, 2007 4:42pm

    Derek Allard

    3168 posts

    Hey earph.

    I suspect that what happened was that your host turned on all warnings and errors at the server level, or you changed error messages in the admin tab?  Try turning them off in the CP.  If that doesn’t work, the best thing to do for now is contact your host and ask them to disable warnings.

    Here is some further changes you could make.  Open up system/db/db.mysql.php and find line 610-617

    if (function_exists('mysql_escape_string'))
            {
                return mysql_escape_string(stripslashes($str));
            }
            else
            {
                return addslashes(stripslashes($str));
            }

    Change it to look like this

    if (function_exists('mysql_real_escape_string'))
            {
                return mysql_real_escape_string(stripslashes($str));
            }
            elseif (function_exists('mysql_escape_string'))
            {
                return mysql_escape_string(stripslashes($str));
            }
            else
            {
                return addslashes(stripslashes($str));
            }

    Let us know if that helps

  • #20 / Aug 02, 2007 4:44pm

    Big Skillet

    364 posts

    OK… I just turned them off in the CP.  Everything is working great now. Derek, I’ll probably implement your fix later on.  Thanks!

  • #21 / Aug 02, 2007 5:16pm

    Big Skillet

    364 posts

    So, since the new version of EE has the “pages” module now, there is not reason to use “Tome”, right?

  • #22 / Aug 02, 2007 5:20pm

    Lisa Wess

    20502 posts

    You’ll need to compare the two and make your own decision on that =)

  • #23 / Aug 02, 2007 5:56pm

    Big Skillet

    364 posts

    I noticed that my publish drop down menu is gone now that I did the 1.6 upgrade along with the Tome install.  Have you ran into this issue before?

  • #24 / Aug 02, 2007 6:00pm

    Derek Allard

    3168 posts

    In CP Home ›  Admin ›  System Preferences ›  Control Panel Settings, is your Publish tab set to “hover”?  That would be my first thought.

  • #25 / Aug 02, 2007 6:03pm

    Big Skillet

    364 posts

    Yes it is.

  • #26 / Aug 02, 2007 6:06pm

    Derek Allard

    3168 posts

    OK, let’s try this.  Set it to “none”, save and then exit EE.  Then log back in, set it to hover try again.  Just trying to make it stick here.

    My next thoughts would be to (a) try it in a different webbrowser; (b) clear your webbrowser and site cache and try again; and (c) reupload the EE files.

  • #27 / Aug 02, 2007 6:27pm

    Big Skillet

    364 posts

    No luck…. I also noticed that the back is not hovering on rollover either.

  • #28 / Aug 02, 2007 8:15pm

    Lisa Wess

    20502 posts

    Check in “My Account” -> Control Panel settings, and make sure you’re on the Default theme. You can check also the default in Admin -> Control Panel settings.

  • #29 / Aug 03, 2007 1:41pm

    Big Skillet

    364 posts

    Yes, it is set to default in both of those places.  Would you like to login into my account so you can see what the button is doing?  PM me and I’ll give you the info.

  • #30 / Aug 03, 2007 1:58pm

    Derek Allard

    3168 posts

    No need for us to login earph.  Thanks for the offer.  Did you try all of my suggestions including reuploading the files?

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases