Suggested Friends v1.0
Release Notes
Initial Release
Matt Beckett
I'm a self-employed web developer, family man, nerd, scuba diver. Manager/maintainer of this elgg community site, and core Elgg development team member.
Project Info
Stats
- Category: Widgets
- License: GNU General Public License (GPL) version 2
- Updated: 2015-10-16
- Downloads: 5843
- Recommendations: 19
Other Projects
View Matt Beckett's plugins
nice plugin matt :)works cool.... recommended
I'm getting Fatal Error...
Fatal Error.
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 = '35') AND ((e.type = 'group')) AND (e.site_guid IN (1)) AND ( (1 = 1) and e.enabled='yes') ORDER BY time_created DESC
Where are you seeing this?
me too! when I click on suggested friends tab!
Error Fatal
Column 'time_created' in order clause is ambiguous
QUERY: SELECT DISTINCT e.*, r.* FROM planteas_entities e JOIN planteas_entity_relationships r on r.guid_two = e.guid WHERE (r.relationship = 'member' AND r.guid_one = '35') AND ((e.type = 'group')) AND (e.site_guid IN (1)) AND ( (1 = 1) and e.enabled='yes') ORDER BY time_created DESC
This is because of a bug in core that was fixed in 1.8.4: http://trac.elgg.org/ticket/4409 Upgrade to the latest version of Elgg and it should work.
@Matt - You might want to update the manifest to require version of Elgg >= 1.8.4, or change the code to explicitly use e.time_created.
Ah, thanks Brett.
I'll force 1.8.4 in the manifest I think, as people should be upgrading regardless.