X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fdb%2Fmaintenance_db.inc;h=622ed2de448a8caae61b4ef0594fbb3d1517e7a9;hb=c9b7acbdfefe7a626368bfea9af867c4f8b99a1a;hp=1d9a027380273950d44cb58f32aa6ba175f6c2fe;hpb=b6af4ea4c99734cfd051395289107bbba5a405e9;p=fa-stable.git diff --git a/admin/db/maintenance_db.inc b/admin/db/maintenance_db.inc index 1d9a0273..622ed2de 100644 --- a/admin/db/maintenance_db.inc +++ b/admin/db/maintenance_db.inc @@ -137,6 +137,8 @@ function db_import($filename, $connection, $force=true) $sql_errors = array(); ini_set("max_execution_time", "180"); + db_query("SET foreign_key_checks=0"); + // uncrompress gziped backup files if (strpos($filename, ".gzip") || strpos($filename, ".GZIP")) $lines = db_ungzip("lines", $filename); @@ -209,7 +211,7 @@ function db_import($filename, $connection, $force=true) { if (!db_query($table_query[0])) { - if (!$force && !in_array(db_error_no(), $ignored_mysql_errors)) { + if (!in_array(db_error_no(), $ignored_mysql_errors) || !$force) { $sql_errors[] = array(db_error_msg($db), $table_query[1]); } } @@ -223,12 +225,14 @@ function db_import($filename, $connection, $force=true) { if (!db_query($data_query[0])) { - if (!$force && !in_array(db_error_no(),$ignored_mysql_errors)) + if (!in_array(db_error_no(),$ignored_mysql_errors) || !$force) $sql_errors[] = array(db_error_msg($db), $data_query[1]); } } } + db_query("SET foreign_key_checks=1"); + if (count($sql_errors)) { // display first failure message; the rest are probably derivative $err = $sql_errors[0];