From 1be3414f0a9c9b86b4c4c8a8528de105419d54f5 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Wed, 21 Apr 2010 11:25:07 +0000 Subject: [PATCH] ixed incorect backup of tables with multidigit prefix [0000223] --- CHANGELOG.txt | 6 +++++- admin/db/maintenance_db.inc | 2 +- 2 files changed, 6 insertions(+), 2 deletions(-) diff --git a/CHANGELOG.txt b/CHANGELOG.txt index 6e51307..b7a86e2 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -20,7 +20,11 @@ Legend: $ -> Affected files 21-Apr-2010 Joe Hunt -# Deleting a Sales Order with reference to a voided delivery causes SQL error when +# [0000223] Incorrect backup of tables with more than 2 digit prefix +$ /admin/db/maintenance_db.inc + +21-Apr-2010 Joe Hunt +# [0000222] Deleting a Sales Order with reference to a voided delivery causes SQL error when looking at this delivery. Solution, can't delete, but set the deliveries to 0 on the lines. $ /sales/includes/db/sales_order_db.inc diff --git a/admin/db/maintenance_db.inc b/admin/db/maintenance_db.inc index e88c0a1..18e680d 100644 --- a/admin/db/maintenance_db.inc +++ b/admin/db/maintenance_db.inc @@ -551,7 +551,7 @@ function db_export($conn, $filename, $zip='no', $comment='', $tbpref = TB_PREF) { //if ($conn["tbpref"] == "" || strpos($row['Name'], $conn["tbpref"]) !== false) replaced if (($conn["tbpref"] == "" && !preg_match('/[0-9]+_/', $row['Name'])) || - ($conn["tbpref"] != "" && strpos($row['Name'], $conn["tbpref"]) !== false)) + ($conn["tbpref"] != "" && strpos($row['Name'], $conn["tbpref"]) === 0)) $all_tables[] = $row; } // get table structures -- 2.30.2