1242 Error - Can't update post
By marco deluca on Sunday, 10 November 2013
Posted in General Issues
Replies 3
Likes 0
Views 895
Votes 0
When trying to update a post, I get this error:
1242
Subquery returns more than 1 row SQL=update dctyl_social_stream set ispublic = '1' where `id` = ( select `uid` from `dctyl_social_stream_item` where `context_type` = 'blog' and `context_id` = '2').

This is in Joomla 3.2. Also, I noticed that this blog was posted in easysocial stream 3 times.
Same problem here but when updating a easyblog entry.

1242
Erreur: 1242
Subquery returns more than 1 row SQL=update jos_social_stream set ispublic = '1' where `id` = ( select `uid` from `jos_social_stream_item` where `context_type` = 'blog' and `context_id` = '2')


I have Easyblog and EasySocial both installed.

B.
Benoit Gonneville Damme
·
Monday, 11 November 2013 03:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Updating a post = updating an easyblog entry, so its the same problem.
marco deluca
·
Monday, 11 November 2013 19:52
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi all,

Regarding the sql error issue, its a bug in EasySocial and we have fixed the issue internally. For the quick fix, open the file 'JOOMLA/administrator/components/com_easysocial/models/privacy.php' and look for 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 replace 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 ) . ')';


This will fix the sql error

Hope this help and have a nice day
Sam
·
Wednesday, 13 November 2013 16:03
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post