From 323813b37319a88b6b0569657143d9fb0c038122 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Mon, 1 Nov 2010 22:52:01 +0100 Subject: [PATCH] Prevents empty education inclusions. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/1.0.1/merge.php | 3 +++ 1 file changed, 3 insertions(+) diff --git a/upgrade/1.0.1/merge.php b/upgrade/1.0.1/merge.php index e1e7ba5..223249e 100755 --- a/upgrade/1.0.1/merge.php +++ b/upgrade/1.0.1/merge.php @@ -264,6 +264,9 @@ echo "Addresses inclusions finished.\n"; // Retrieves education from AX database. This is the hardest part since AX only kept education as an unformated string. echo "Starts educations inclusions.\n"; +// Deletes empty educations. +XDB::rawExecute("DELETE FROM fusionax_formations + WHERE Intitule_formation = '' AND Intitule_diplome = '' AND Descr_formation = ''"); // Insert ids into fusionax_formations to prevent many joins. XDB::rawExecute('UPDATE fusionax_formations AS f LEFT JOIN profile_education_enum AS pe ON (pe.name = f.Intitule_formation) -- 2.1.4