People From The Neighborhood v1.2

Release Notes

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

  • 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

  • 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.

emdagon

+8 years since I have been here! xD

Stats

  • Category: Misc
  • License: GNU General Public License (GPL) version 2
  • Updated: 2014-11-17
  • Downloads: 3349
  • Recommendations: 19

Other Projects

View emdagon's plugins