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.

CommentFileSizeAuthor
img2.jpg91.25 KBalex72rm
img1.jpg64.56 KBalex72rm

Comments

sirkitree’s picture

Priority: Critical » Normal
Status: Active » Closed (duplicate)