From c4532232a88b1b2f79b4dd7eede1ccaee669d3d2 Mon Sep 17 00:00:00 2001 From: Florent Bruneau Date: Wed, 24 Feb 2010 22:03:53 +0100 Subject: [PATCH] Fix invalid reference to profile_education.pid Signed-off-by: Florent Bruneau --- upgrade/newdirectory-0.0.1/09_education.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/upgrade/newdirectory-0.0.1/09_education.sql b/upgrade/newdirectory-0.0.1/09_education.sql index 95340fb..6906340 100644 --- a/upgrade/newdirectory-0.0.1/09_education.sql +++ b/upgrade/newdirectory-0.0.1/09_education.sql @@ -610,7 +610,7 @@ INSERT INTO profile_education_enum (name, url, country, abbreviation) -- Médecine is not a university but an educational field REPLACE INTO profile_education (pid, id, fieldid, eduid, degreeid) - SELECT e.uid, e.id, f.id, 0, d.id + SELECT e.pid, e.id, f.id, 0, d.id FROM profile_education AS e INNER JOIN profile_education_enum AS l ON (l.id = e.eduid) INNER JOIN profile_education_degree_enum AS d ON (d.degree = "Doctorat") -- 2.1.4