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?

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.