Ah, I can see that is still not going to work if you don’t have MYSQL functions installed on your server.
Try replacing the ELISQLREPORTS_make_Backup function with this:
function ELISQLREPORTS_make_Backup($date_format, $backup_type = “manual”, $db_name = DB_NAME, $db_host = DB_HOST, $db_user = DB_USER, $db_password = DB_PASSWORD) {
global $wpdb, $wp_version;
ELISQLREPORTS_set_backupdir();
$db_date = date($date_format);
$db_port = ”;
if (strpos($db_host, ‘:’)) {
list($db_host, $db_port) = explode(‘:’, $db_host, 2);
if (is_numeric($db_port))
$db_port = ‘ –port=’.escapeshellarg($db_port);
else
$db_port = ‘ –socket=’.escapeshellarg($db_port);
}
$db_port .= ‘ ‘;
$subject = “$backup_type.$db_name.$db_host.sql”;
$filename = “z.$db_date.$subject”;
$backup_file = trailingslashit($GLOBALS[“ELISQLREPORTS”][“settings_array”][“backup_dir”]).$filename;
$content = ”;
$uid = md5(time());
$message = “\r\n–$uid\r\nContent-type: text/html; charset=\”iso-8859-1\”\r\nContent-Transfer-Encoding: 7bit\r\n\r\n”;
if (isset($GLOBALS[“ELISQLREPORTS”][“settings_array”][“backup_method”]) && $GLOBALS[“ELISQLREPORTS”][“settings_array”][“backup_method”] == 1) {
$mysqlbasedir = $wpdb->get_row(“SHOW VARIABLES LIKE ‘basedir'”);
if(substr(PHP_OS,0,3) == ‘WIN’)
$backup_command = ‘”‘.(isset($mysqlbasedir->Value)?trailingslashit(str_replace(‘\\’, ‘/’, $mysqlbasedir->Value)).’bin/’:”).’mysqldump.exe”‘;
else
$backup_command = (isset($mysqlbasedir->Value)&&is_file(trailingslashit($mysqlbasedir->Value).’bin/mysqldump’)?trailingslashit($mysqlbasedir->Value).’bin/’:”).’mysqldump’;
$backup_command .= ‘ –user=’.escapeshellarg($db_user).’ –password=’.escapeshellarg($db_password).’ –add-drop-table –skip-lock-tables –host=’.escapeshellarg($db_host).$db_port.escapeshellarg($db_name);
if (isset($GLOBALS[“ELISQLREPORTS”][“settings_array”][“compress_backup”]) && $GLOBALS[“ELISQLREPORTS”][“settings_array”][“compress_backup”]) {
$backup_command .= ‘ | gzip > ‘;
$backup_file .= ‘.gz’;
} else
$backup_command .= ‘ -r ‘;
passthru($backup_command.escapeshellarg($backup_file), $errors);
$return = “Command Line Backup of $subject returned $errors error”.($error!=1?’s’:”);
} elseif ($GLOBALS[“ELISQLREPORTS”][“backup_file”] = fopen($backup_file, ‘w’)) {
if (mysql_connect($db_host, $db_user, $db_password)) {
if (mysql_select_db($db_name)) {
$server = strtolower(isset($_SERVER[“HTTP_HOST”])?$_SERVER[“HTTP_HOST”]:(isset($_SERVER[“SERVER_NAME”])?$_SERVER[“SERVER_NAME”]:$_SERVER[“SERVER_ADDR”]));
$ip = explode(“$server”, get_option(“siteurl”).”$server”);
if (!(count($ip) == 3 && strlen(trim($ip[1], ” \t\r\n/”)) > 0))
$ip[1] = $_SERVER[“SERVER_ADDR”];
fwrite($GLOBALS[“ELISQLREPORTS”][“backup_file”], ‘– EZ SQL Backup ‘.ELISQLREPORTS_VERSION.’, for ‘.$server.’ (‘.trim($ip[1]).’)
—
— Host: ‘.$db_host.’ Database: ‘.$db_name.’
— ——————————————————
— WordPress version ‘.$wp_version.’ ‘.$db_date.’
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE=\’+00:00\’ */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=\’NO_AUTO_VALUE_ON_ZERO\’ */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;’);
$sql = “show full tables where Table_Type = ‘BASE TABLE'”;
$result = mysql_query($sql);
$errors = “”;
if (mysql_errno())
$errors .= “/* SQL ERROR: “.mysql_error().” */\n\n/*$sql*/\n\n”;
else {
while ($row = mysql_fetch_row($result)) {
$errors .= ELISQLREPORTS_get_structure($row[0]);
if (!is_numeric($rows = ELISQLREPORTS_get_data($row[0])))
$errors .= $rows;
}
mysql_free_result($result);
$sql = “show full tables where Table_Type = ‘VIEW'”;
if ($result = mysql_query($sql)) {
while ($row = mysql_fetch_row($result))
$errors .= ELISQLREPORTS_get_structure($row[0], “View”);
mysql_free_result($result);
}
}
fclose($GLOBALS[“ELISQLREPORTS”][“backup_file”]);
$return = “Backup: $subject Saved”;
$message .= “A database backup was saved on “.(get_option(“blogname”)).”.\r\n<p>
$errors
<p>”;
if (isset($GLOBALS[“ELISQLREPORTS”][“settings_array”][“compress_backup”]) && $GLOBALS[“ELISQLREPORTS”][“settings_array”][“compress_backup”]) {
$zip = new ZipArchive();
if ($zip->open($backup_file.’.zip’, ZIPARCHIVE::CREATE) === true) {
$zip->addFile($backup_file, $filename);
$zip->close();
}
if (is_file($backup_file) && is_file($backup_file).’.zip’) {
if (@unlink($backup_file))
$backup_file .= ‘.zip’;
} else
$return .= ” but not Zipped”;
}
} else
$return = “Failed to save backup!”;
if (isset($GLOBALS[“ELISQLREPORTS”][“settings_array”][$backup_type.”_backup”]) && $GLOBALS[“ELISQLREPORTS”][“settings_array”][$backup_type.”_backup”] > 0) {
$sql_files = array();
if ($handle = opendir($GLOBALS[“ELISQLREPORTS”][“settings_array”][“backup_dir”])) {
while (false !== ($entry = readdir($handle)))
if (is_file(trailingslashit($GLOBALS[“ELISQLREPORTS”][“settings_array”][“backup_dir”]).$entry))
if (strpos($entry, $subject))
$sql_files[] = “$entry”;
closedir($handle);
rsort($sql_files);
}
$del=0;
while (count($sql_files)>$GLOBALS[“ELISQLREPORTS”][“settings_array”][$backup_type.”_backup”])
if (@unlink(trailingslashit($GLOBALS[“ELISQLREPORTS”][“settings_array”][“backup_dir”]).array_pop($sql_files)))
$del++;
$message .= “\r\nNumber of archives:
- Deleted: $del
- Kept: “.count($sql_files).”
<p>”;
}
if (strlen($GLOBALS[“ELISQLREPORTS”][“settings_array”][“backup_email”])) {
$headers = ‘From: ‘.get_option(“admin_email”).”\r\n”;
$headers .= “MIME-Version: 1.0\r\n”;
$headers .= “Content-Type: multipart/mixed; boundary=\”$uid\”\r\n”;
$upload = wp_upload_dir();
if (file_exists($backup_file)) {
$file_size = filesize($backup_file);
$handle = fopen($backup_file, “rb”);
$content .= “The backup has been attached to this email for your convenience.\r\n\r\n–$uid\r\nContent-Type: application/octet-stream; name=\””.basename($backup_file).”\”\r\nContent-Transfer-Encoding: base64\r\nContent-Disposition: attachment; filename=\””.basename($backup_file).”\”\r\n\r\n”.chunk_split(base64_encode(fread($handle, $file_size)), 70, “\r\n”);
fclose($handle);
}
if (mail($GLOBALS[“ELISQLREPORTS”][“settings_array”][“backup_email”], $return, $message.$content.”\r\n\r\n–$uid–“, $headers))
$return .= ” and Sent!”;
else
mail($GLOBALS[“ELISQLREPORTS”][“settings_array”][“backup_email”], $return, $message.strlen($content).” bytes is too large to attach but you can download it here.\r\n\r\n–$uid–“, $headers);
} else
$return = ‘Database Selection ERROR: ‘.mysql_error();
} else
$return = ‘Database Connection ERROR: ‘.mysql_error();
}
return $return;
}
..and next time you post the contents of your error_log you don’t need to make a screenshot, just paste the text into you post so I can see all of it ??
