I just updated to EasyBlog 3.9.15064 and get the same error message:

Subquery returns more than 1 row SQL=update ov8sp_social_stream set ispublic = '1' where `id` = ( select `uid` from `ov8sp_social_stream_item` where `context_type` = 'blog' and `context_id` = '6')

Hi Randall,

I am sorry for the delay of this reply.

Regarding your issue, strange, this issue already fixed in EasySocial 1.0.6 but when I look at the file from your site, the fix doesn't get applied

Anyway, I've applied the same patch on your site and now updating blog no longer hit this issue.
Please verify again.

Below is what i did:

Open file 'JOOMLA/administrator/components/com_easysocial/models/privacy.php' and go to line at 650:

$updateQuery .= ' where `id` = ( select `uid` from `#__social_stream_item` where `context_type` = ' . $db->Quote( $context ) . ' and `context_id` = ' . $db->Quote( $uId ) . ')';

and replaced the above with following:

$updateQuery .= ' where `id` IN ( select `uid` from `#__social_stream_item` where `context_type` = ' . $db->Quote( $context ) . ' and `context_id` = ' . $db->Quote( $uId ) . ')';

Hope this help and have a nice day

Thanks Sam,

I will check this when I get to my laptop in the morning. Thanks very much for applying the update.

Hi Randall,

You are welcome