Hello. When I installed a plug-in called hypefeed and opened http://(domain)/plus/activity/friends/, I got this error.
An exception occurred while executing 'SELECT COUNT(*) as total FROM ( SELECT DISTINCT river.*, feeds.story_guid, feeds.owner_guid, GROUP_CONCAT(feeds.id) AS related_ids, TIMESTAMPDIFF(DAY, FROM_UNIXTIME(feeds.posted), NOW()) AS group_interval FROM (SELECT rv.* FROM elgg_river rv JOIN elgg_entities oe ON rv.object_guid = oe.guid LEFT JOIN elgg_entities te ON rv.target_guid = te.guid WHERE rv.owner_guid != 1 AND rv.enabled = 'yes' AND ((1 = 1) AND (oe.enabled = 'yes')) AND (((1 = 1) AND (te.enabled = 'yes')) OR te.guid IS NULL) ORDER BY rv.posted desc) river JOIN elgg_feeds AS feeds ON river.id = feeds.id WHERE EXISTS (SELECT 1 FROM elgg_entity_relationships WHERE guid_one = feeds.owner_guid AND guid_two = 36 AND relationship IN ('friend')) AND feeds.owner_guid != 1 GROUP BY feeds.story_guid, group_interval ) groups': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rv.owner_guid' in 'where clause' QUERY: SELECT COUNT(*) as total FROM ( SELECT DISTINCT river.*, feeds.story_guid, feeds.owner_guid, GROUP_CONCAT(feeds.id) AS related_ids, TIMESTAMPDIFF(DAY, FROM_UNIXTIME(feeds.posted), NOW()) AS group_interval FROM (SELECT rv.* FROM elgg_river rv JOIN elgg_entities oe ON rv.object_guid = oe.guid LEFT JOIN elgg_entities te ON rv.target_guid = te.guid WHERE rv.owner_guid != 1 AND rv.enabled = 'yes' AND ((1 = 1) AND (oe.enabled = 'yes')) AND (((1 = 1) AND (te.enabled = 'yes')) OR te.guid IS NULL) ORDER BY rv.posted desc) river JOIN elgg_feeds AS feeds ON river.id = feeds.id WHERE EXISTS (SELECT 1 FROM elgg_entity_relationships WHERE guid_one = feeds.owner_guid AND guid_two = 36 AND relationship IN ('friend')) AND feeds.owner_guid != 1 GROUP BY feeds.story_guid, group_interval ) groups PARAMS: Array ( ) Log at time 1568288224 may have more data.
What is the corrective action?
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.
- seri_ng@seri_ng

seri_ng - 0 likes
- ryusei - koseki@reix

ryusei - koseki - 0 likes
You must log in to post replies.Because there is no owner_guid in elgg_river table WHERE rv.owner_guid != 1. I dont know if what you want instead of rv.owner_guid is rv.subject_guid or not.
elgg uses version 2.3.14.