Closed (duplicate)
Project:
Flag Friend
Version:
6.x-1.0-rc1
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
18 Oct 2009 at 09:01 UTC
Updated:
4 Nov 2009 at 16:18 UTC
Hi,
I noticed that sometimes the friend list that is rendered from default view built into flag friend module, has duplicate elements.
The sql command observable from views2 interface is:
SELECT DISTINCT(users.uid) AS uid,
users.picture AS users_picture,
users.name AS users_name,
flag_friend.uid AS flag_friend_uid,
flag_friend.created AS flag_friend_created
FROM users users
LEFT JOIN flag_friend flag_friend ON users.uid = flag_friend.uid
WHERE (users.status <> 0)
AND ((users.uid IN (SELECT f.friend_uid FROM flag_friend f WHERE f.uid = 16)) OR (users.uid IN (SELECT f.uid FROM flag_friend f WHERE f.friend_uid = 16)))
ORDER BY flag_friend_created ASC
whose output is rendered into img2.jpg, but, on the contrary, the {flag_friend} table is consistent as rendered into img1.jpg.
Comments
Comment #1
sirkitree commentedduplicate #592622: Duplicate friend listing in Views2