ISSUE SUMMARY:
In latest JomSocial version 4.2.2 the user rule scan is broken. It does not do anything.

STEPS TO REPLICATE:
1 Login to JomSocial demo administration:
demo.jomsocial.com/administrator/index.p...nity&view=userpoints
2 Select configuration > user points
3 Make a rule scan

RESULT
Nothing happens.

EXPECTED RESULT
Normally it would find something or end up with no new detections during scan.

BROWSER
IE, Firefox, Chrome

Hi Guido,
To fix this please open this file administrator/components/com_community/tables/userpoints.php, find this code :

$query = 'SELECT count(' . $db->quoteName('id') . ' ) as '. $db->quoteName('count') . '  FROM '.$db->quoteName('__community_userpoints');

$query = 'SELECT count(' . $db->quoteName('id') . ' ) as '. $db->quoteName('count') . '  FROM '.$db->quoteName('#__community_userpoints');