Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Group announcement emails not sending

1 year 6 months ago
Licenses:
JomSocial Active iSEO Expired Socialize Expired

You may already have fixed this, I can see a topic from a month ago that seems to be the same issue. Emails are not being sent when a group announcement is made. The cause seems to be when it counts the number of members in the group, but uses a GROUP BY in the SQL causing it to get 1 as the count. I have commented out line 500 in com_community/models/groups.php:

			$query	= 'SELECT COUNT(*) FROM ' . $db->quoteName('#__community_groups_members') . ' '
					. 'WHERE '.$db->quoteName('groupid').'=' . $db->Quote( $id ) . ' '
					. 'AND ' . $db->quoteName( 'approved' ) . '=' . $db->Quote( '1' ) . ' ';
					//. 'GROUP BY ' . $db->quoteName('memberid');

1 year 6 months ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi
May i know the Jomscial version you are using on your site that is giving this error to you?

Regards

1 year 6 months ago
Licenses:
JomSocial Active iSEO Expired Socialize Expired

Hi Pankaj
We are using version 4.5

1 year 6 months ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi
Thanks for report, We fixed the issue, and it will added in the next update of Jomsocial
Here are the details :
Path components/com_community/models/groups.php

{
  			$query	= 'SELECT COUNT(*) FROM ' . $db->quoteName('#__community_groups_members') . ' '
  					. 'WHERE '.$db->quoteName('groupid').'=' . $db->Quote( $id ) . ' '
 				. 'AND ' . $db->quoteName( 'approved' ) . '=' . $db->Quote( '1' ) . ' ';
 				//. 'GROUP BY ' . $db->quoteName('memberid');
 				. 'AND ' . $db->quoteName( 'approved' ) . '=' . $db->Quote( '1' );
  
  			$db->setQuery( $query );


Regards

The following user(s) said Thank You: Bob Garbett
Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW