From 907177e03cde4f37863bd0d437704ff11530a2dd Mon Sep 17 00:00:00 2001 From: marcus Date: Tue, 30 Dec 2008 18:29:01 +0000 Subject: Closes #643: Confirmed bug, applied fix as suggested. git-svn-id: https://code.elgg.org/elgg/trunk@2523 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/lib/metadata.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/engine/lib/metadata.php b/engine/lib/metadata.php index eddc3c169..896b7652f 100644 --- a/engine/lib/metadata.php +++ b/engine/lib/metadata.php @@ -472,7 +472,7 @@ $where[] = "m.value_id='$meta_v'"; } if ($site_guid > 0) - $where[] = "m.entity_guid = {$site_guid}"; + $where[] = "e.site_guid = {$site_guid}"; $query = "SELECT m.*, n.string as name, v.string as value from {$CONFIG->dbprefix}entities e JOIN {$CONFIG->dbprefix}metadata m on e.guid = m.entity_guid JOIN {$CONFIG->dbprefix}metastrings v on m.value_id = v.id JOIN {$CONFIG->dbprefix}metastrings n on m.name_id = n.id where"; foreach ($where as $w) -- cgit v1.2.3