Group announcement emails not sending

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

6 years 2 months ago

#185246

Topic Author
Bob Garbett
Offline
Fresh Boarder
Posts: 2
Thank you received: 0

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');

6 years 2 months ago

#185302

Pankaj Sharma
Offline
Moderator
Posts: 875
Thank you received: 130

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

6 years 2 months ago

#185336

Topic Author
Bob Garbett
Offline
Fresh Boarder
Posts: 2
Thank you received: 0

Licenses:

JomSocial Active iSEO Expired Socialize Expired

Hi Pankaj
We are using version 4.5

6 years 2 months ago

#185355

Pankaj Sharma
Offline
Moderator
Posts: 875
Thank you received: 130

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

Notice

Support Forum

Group announcement emails not sending

Licenses:

Licenses:

Licenses:

Licenses:

Join 180,000 websites creating Amazing communities

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere