From a7189c65575becfeb03eed05972a45eeef96ccc5 Mon Sep 17 00:00:00 2001 From: marcus Date: Thu, 4 Dec 2008 13:51:25 +0000 Subject: Fixed update script git-svn-id: https://code.elgg.org/elgg/trunk@2502 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/upgrades/2008112002.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'engine/schema/upgrades/2008112002.sql') diff --git a/engine/schema/upgrades/2008112002.sql b/engine/schema/upgrades/2008112002.sql index 31b3cc6eb..cdd308fe0 100644 --- a/engine/schema/upgrades/2008112002.sql +++ b/engine/schema/upgrades/2008112002.sql @@ -10,7 +10,7 @@ INSERT INTO `prefix_private_settings` (entity_guid, name, `value`) -- Delete previous settings CREATE TEMPORARY TABLE __upgrade_2008112002_1 ( - SELECT distinct meta.id as id from `prefix_metadata meta` + SELECT distinct meta.id as id from `prefix_metadata` meta JOIN `prefix_private_settings` settings ON meta.entity_guid = settings.entity_guid JOIN `prefix_entities` e ON e.guid = meta.entity_guid -- cgit v1.2.3