Thread

I’ve been building a site over the past week and things have worked just fine, but now I’m getting an error on both my EE Administration area as well as the site I’ve been working on.  It just appeared out of no where….

Have you seen this before?

Warning: mysql_escape_string() [function.mysql-real-escape-string]: This function is deprecated; use mysql_real_escape_string() instead. in /home/dave/public_html/admin/db/db.mysql.php on line 612

Thanks!

I haven’t seen that.  Can you let us know what version and build of EE you are using, as well as the version of both PHP and MySQL?

Thank you!

EE - 1.5.1
PHP - 4.1.21-standard
MSQL - 4.1.10

Also note that I’m using the “Pages” Module create by Mark Huot, although I don’t know if that has anything to do with it.  It was working fine with that installed also….

Where, exactly, does it appear? Have you added any custom SQL statements to your templates or added new extensions at all? Were any changes made to your server environment lately?

I know you don’t want this answer, as well, but to help troubleshoot this I’m going to need you to update to the latest version and build. Your version is 8ish months old…

No, I have not changed anything… no SQL, no extensions…. nothing.  That’s why I’m baffled…

Could you point me in the right directions to some instructions on how to upgrade EE?

Found it: http://expressionengine.com/docs/installation/update.html

Ok…. I think I totally screwed up.  I didn’t realize that the “Pages” module was included with the new version of EE…  There are so many threads around about “static pages”, “Tome”, etc etc… I’m not sure what to do….

I’m getting this error:

MySQL ERROR:

Error Number: 1146

Description: Table ‘dave_stonecrossing.exp_sites’ doesn’t exist

Query: SELECT es.* FROM exp_sites AS es WHERE es.site_id = ‘1’

I have my DB backed up… the question is, will it work with the upgrade considering things were set up with the “pages” module?  I deleted all of Mark Huot’s modules and extensions and was going to try and do a clean upgrade considering all the problems people are having.

Ah,yes - it was linked from the in a support note from the changelog. But that error means you haven’t yet run update.php, which is in the update instructions.

Also, just a note that what you see is a warning, which isn’t an error - its just the server passing notes onto you.  Most servers have those supressed, and you might want to suppress them.

What we do is first check for the existence of that function, and if its found, we use it.  Your server has it, but is saying “you might want to use something else”.  I’ll investigate deeper, thanksearph.

Yes, I did read that post, but I’ve already over wrote all the “pages module” files!  Am I screwed?

I’m doing the update now, but it says: Update from Version 1.5.1 to Version 1.5.2.  I just uploaded version 6.  What’s the deal?

It steps you through the updates, don’t worry about that.

You may want to rever the files back and get rid of Tome first or upgrade it, as per the instructions, otherwise the upgrade may end up a lot of blank pages.

I pretty much just got rid of all the Tome files.  That should be alright, shouldn’t it?  All my weblog data will still be there… I’d just need to set up all the pages again?

No, it’s the tables that cause the problem - the ones in the database.  You need to clean those up prior to upgrading.

I assume you’re meaning this update: http://www.domain.com/system/update-pages.php, or is there something else?  I’m not seeing anything on that page.

I don’t know what update-pages.php is, I mean whatever is instructed by the support note.