From e3423fc85f1f3557ed45fefc8089afbf7d1a2731 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Wed, 21 Oct 2009 16:27:05 +0000 Subject: [PATCH] Fixed refs table upgrade to avoid duplicate record errors. --- sql/alter2.2.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/alter2.2.php b/sql/alter2.2.php index a1a4b1d5..457850ff 100644 --- a/sql/alter2.2.php +++ b/sql/alter2.2.php @@ -56,7 +56,7 @@ class fa2_2 { $info = get_systype_db_info($typeno); if ($info == null || $info[3] == null) continue; $tbl = str_replace(TB_PREF, $pref, $info[0]); - $sql = "SELECT {$info[2]} as id,{$info[3]} as ref FROM $tbl"; + $sql = "SELECT DISTINCT {$info[2]} as id,{$info[3]} as ref FROM $tbl"; if ($info[1]) $sql .= " WHERE {$info[1]}=$typeno"; $result = db_query($sql); -- 2.30.2