Hi,
Joomla : v3.3.1
JomSocial:v3.2.0.7
Socialize:v1.2.7
since the upgrade to v3.2.0.7, gender stats are not displayed anymore at the frontend, through the community jomsocial statistics module. See attached files in relations with, all the gender stats are missing. Was working in v3.2.0.5.
Can be seen on our live site. Log with user:Admin password same as described for JSupport.
Same issue at the backend: Demographic picture is blank, see also attached file.
Cheers,
L

Hi,

please apply this fixes:
/administrator/components/com_community/models/users.php line 409:

from
$query = 'SELECT SUM(CASE ' . $db->quoteName('value') . ' WHEN ' . $db->Quote('Male') . ' THEN 1 ELSE 0 END) as Male, ' .
'SUM(CASE ' . $db->quoteName('value') . ' WHEN ' . $db->Quote('Female') . ' THEN 1 ELSE 0 END) as Female ' .
'FROM ' . $db->quoteName('#__community_fields_values');

to
$query = 'SELECT SUM(CASE ' . $db->quoteName('value') . ' WHEN ' . $db->Quote('Male') . ' THEN 1 ELSE 0 END OR CASE ' . $db->quoteName('value') . ' WHEN ' . $db->Quote('COM_COMMUNITY_MALE') . ' THEN 1 ELSE 0 END) as Male, ' .
'SUM(CASE ' . $db->quoteName('value') . ' WHEN ' . $db->Quote('Female') . ' THEN 1 ELSE 0 END OR CASE ' . $db->quoteName('value') . ' WHEN ' . $db->Quote('COM_COMMUNITY_FEMALE') . ' THEN 1 ELSE 0 END) as Female ' .
'FROM ' . $db->quoteName('#__community_fields_values');

Hi,
applying your changes, fix the backend gender stats display. thank you.
What's about the frontend display shown in my second attached file from my first post ?
We suppose another patch is needed isn't it ?
Cheers,
L

Hi,

About the stats. module please replace with this:
put it at modules, and don't forget backup first.

we've applied your changes, unfortunately no effects. We've provided you our ftp access (see details in our previous post). On the frontend you have to log as: Admin with password same as JSupport in order to get the statistics menu.
Cheers,
L

Hi,

please check it again. I made the fixes for you:
/public_html/modules/mod_statistics/helper.php
line 92

From
$genders = $stats->getGendersCount($gender_fieldcode, $gender_male, $gender_female);
To
$genders = $stats->getGendersCount($gender_fieldcode, 'COM_COMMUNITY_MALE', 'COM_COMMUNITY_FEMALE');

From
$case = JString::strtolower($data->value);

To
$case = $data->value;

Hi,
well done !
Thank you for your support