From ae29bacba05f112732feba4d9ac3127143a54433 Mon Sep 17 00:00:00 2001 From: Florent Bruneau Date: Thu, 7 Oct 2010 13:13:18 +0200 Subject: [PATCH] Fix publicity of entries in search_name table. A full reindexation of the names must be performed during the upgrade. Signed-off-by: Florent Bruneau --- classes/profile.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/classes/profile.php b/classes/profile.php index 0adc9d3..8b53e40 100644 --- a/classes/profile.php +++ b/classes/profile.php @@ -1013,7 +1013,7 @@ class Profile WHERE pid = {?}', $pid); $keys = XDB::iterator("SELECT CONCAT(n.particle, n.name) AS name, e.score, - FIND_IN_SET('public', e.flags) AS public + IF(FIND_IN_SET('public', e.flags), 'public', '') AS public FROM profile_name AS n INNER JOIN profile_name_enum AS e ON (n.typeid = e.id) WHERE n.pid = {?}", -- 2.1.4