Developed in (and for) Elgg 1.7.6 environment.
I didn't test it properly, so I'll appreciate any comment about your experience using it.
Also, I want you to help me fill the ToDo list with good ideas ;-)
Features:
- Dashboard widget!
Fixes:
- It did suggest some befriended users.
ToDo:
- Profile Widget ?
- Hide person support
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by Raül Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
Hi,
I get the error:
DatabaseException
Column 'time_created' in order clause is ambiguous
QUERY: SELECT DISTINCT e.*, r.* FROM elgg_entities e JOIN elgg_entity_relationships r on r.guid_two = e.guid WHERE (r.relationship = 'member' AND r.guid_one = '82') AND ((e.type = 'group')) AND (e.site_guid IN (1)) AND ( (e.access_id = -2
AND e.owner_guid IN (
SELECT guid_one FROM elgg_entity_relationships
WHERE relationship='friend' AND guid_two=82
)) OR (e.access_id IN (2,1)
OR (e.owner_guid = 82)
OR (
e.access_id = 0
AND e.owner_guid = 82
)
) and e.enabled='yes') ORDER BY time_created DESC
moosh101 , in start.php of this plugin , remove line 93 , it's look like this
/* search by groups */
if ($groups_limit > 0) {
$groups = elgg_get_entities_from_relationship(array(
'type' => 'group',
'relationship' => 'member',
'relationship_guid' => $guid,
'order_by' => time_created DESC,
));
so remove : 'order_by' => time_created DESC
many people ask for limit , you can solve it by adding this line :
'limit' => $friends_limit
in line 94 , after this line :
'order_by' => 'u.last_action DESC',
dont forget to add comma "," after 'order_by' => 'u.last_action DESC',
@ paixland the limit will be of how many numbers of people???
how can i put a maximum of 4 suggestions???
@ PaixLand
Can you do me a soild and just paste all of you start.php because i cant get your fix to work. thanks
Please is there any update on this plugin to work with v1.8.0.1
Error 1.7.9
DatabaseException
Column 'time_created' in order clause is ambiguous
QUERY: SELECT DISTINCT e.*, r.* FROM elgg_entities e JOIN elgg_entity_relationships r on r.guid_two = e.guid WHERE (r.relationship = 'member' AND r.guid_one = '2') AND ((e.type = 'group')) AND (e.site_guid IN (1)) AND ( (1 = 1) and e.enabled='yes') ORDER BY time_created DESC
any plan for 1.8?
could you pls consider updating for elgg 1.8.3 as its no more working on 1.8.3 latest release.thanks.
plans for 1.8.3 version?
regards, fabio
Who is having problem with database excpetion, just follow the tips PaixLand. Copy and paste the code in start.php. excellent plugin.