Thread

Hi,

We upgrade from 2.5.0 to 2.5.1 today, and upgrade MSM to 2.1.3. In a nutshell:

With site_name set in the index.php file (any site including main site) we get the error:

An Error Was Encountered
Site Error: Unable to Load Site Preferences; No Preferences Found

With that commented out in the main index.php, the main site loads, but on all sites of course. With debugging turned on in index.php on one of the sub sites I get this message:

A PHP Error was encountered

Severity: Warning

Message: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'nobody'@'localhost' (using password: NO)

Filename: mysql/mysql_driver.php

Line Number: 319

My database.php and config.php file are intact and properly set. Any suggestions?

Same situation with site_name set in admin.php. admin.php gives “Site Error: Unable to Load Site Preferences; No Preferences Found” error with site_name set, and error goes away when commented out.

Got exactly the same error when updating a MSM Site to 2.5.1 and MSM 2.13. Reverted to backup for now.

Sadly, that is good to know I guess, means I haven’t made a stupid mistake 😊

Ellislab, I’m standing by to debug this issue if you want to work with me on it. PM me if you want to view our installation etc.

Would this make a difference (as @CS_sean stated) both EE and MSM need to be upgraded instep. If I ran the upgrade from admin.php before upgrade MSM, will MSM miss some database changes?

Does MSM need to be upgraded after installing the new version, and if so, how can I run that separately.

Grasping at straws now before I revert all our sites to 2.5.0. 😊

Okay, found the solution. That warning from the MySQL_driver.php file was the ticket. Just comment out lines 317 - 320 which disables the check for mysql_real_escape_string. Everything functions correctly.

I realize that the issue is deeper than this, but, this is the solution for the MSM issue on this upgrade.

$str = mysql_real_escape_string($str, $this->conn_id);
  }
/*
  elseif (function_exists('mysql_real_escape_string'))
  {
   $str = mysql_real_escape_string($str);
  }
*/
  elseif (function_exists('mysql_escape_string'))
  {
   $str = mysql_escape_string($str);

All my MSM sites now work correctly. Looking forward to a real fix from Ellislab.

Hi khronos,

I had exactly the same problem, sleepless night trying to figure out where I went wrong.
Upgrading from 2.2.2 -> 2.5.1

Cannot thank you enough for this fix! Also looking forward to an Ellislab fix.

Seb

You are more than welcome Seb! Glad my solution is helping.

Have you submitted this as a bug yet?

Seb

I have now. Thanks for the reminder on that.

Hi khronos,

Thank you for your perseverance and bug report!

I’m sorry we weren’t able to get to you in time, but is there anything else I can assist you with?

Cheers,

Good for now, thanks!

Hi khronos,

Fantastic.

If you need anything else, just let us know.

Cheers!