Nagios Support Forum

Posted: **Tue Nov 05, 2019 3:39 am**

good morning
Recently update my NagiosXi to version 5.6.7
Now the reports menu takes a long time to load.
Looking at the logs I find this:

PHP Deprecated: mysql_escape_string (): This function is deprecated; use mysql_real_escape_string () instead. in /usr/local/nagiosxi/html/includes/db.inc.php on line 372, referr: https: //IP/nagiosxi/includes/components/nocscreen/noc.php

Please can you tell me how to fix it?
thanks greetings

Posted: **Tue Nov 05, 2019 2:41 pm**

This is actually just a test in the software to see if the function is available

Code: Select all

// If we can't use mysql_escape_string then we have to
// just add slashes since we have no open connection
if (function_exists('mysql_escape_string')) {
    $escaped = mysql_escape_string($in);
} else {
    $escaped = addslashes($in);
}

Also, this will not affect reporting performace.

Posted: **Wed Nov 06, 2019 3:45 am**

Good morning ok
And then why does the error appear when I try to get a report?
and because the reports take so long, more than 5 minutes for the report of the day.
Greetings

Posted: **Wed Nov 06, 2019 8:04 am**

I'm not sure what report you are having problem with but the above line was referred by the Operations Screen

Code: Select all

referr: https: //IP/nagiosxi/includes/components/nocscreen/noc.php

Nagios Support Forum

error PHP Deprecated: mysql_escape_string():

error PHP Deprecated: mysql_escape_string():

Re: error PHP Deprecated: mysql_escape_string():

Re: error PHP Deprecated: mysql_escape_string():

Re: error PHP Deprecated: mysql_escape_string():