Show people "liked this" link not show users if users not upload avatar [#1896256]

Show people "liked this" link not show users if users not upload avatar.
In file heartbeat/modules/heartbeat_plugins/includes/heartbeatflagplugin.inc, I found this:

$result = db_query("SELECT u.name, files.uri, f.uid FROM {file_managed} files INNER JOIN {users} u ON u.picture = files.fid INNER JOIN {flag_content} f ON f.uid = u.uid WHERE content_id = :uaid AND content_type = 'heartbeat_activity' ", array(':uaid' => $uaid));

Query above isn't select users if user haven't picture. How to fix this issue?

Comment	File	Size	Author
#3	no_picture_people-1896256-1.patch	996 bytes	duynguyen
	show liked this 1.png	10.04 KB	duynguyen
	show liked this.png	19.8 KB	duynguyen

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

duynguyen CreditAttribution: duynguyen commented 23 January 2013 at 08:08

My solution is change INNER JOIN users and file_managed to LEFT JOIN

$result = db_query("SELECT u.name, files.uri, f.uid FROM {users} u LEFT JOIN {file_managed} files ON u.picture = files.fid INNER JOIN {flag_content} f ON f.uid = u.uid WHERE content_id = :uaid AND content_type = 'heartbeat_activity' ", array(':uaid' => $uaid));