Hi, Luis.
I assign developer to this thread.
Hi Luis,
Can you provide me phpmyadmin access, please? I need debug the database directly..
thank you
Hi Luis,
This is valid bug, and already added to our bug list.
Thank you
well, we need improve his feature, we need add new filtering in user manager, currently we dont have "pending" user we only have "blocked" user (in current system pending is blocked and this is not correct).. so in another words we will create filter "pending" and "blocked" as well
we will try fix this in version 3.3, because impossible fix this issue in version 3.2.1
thank you
Hi Luis,
This is the patch..
1. please open this file administrator/components/com_community/models/users.php, find this code :
if (!empty($searchQuery)) {
$searchQuery .= ' AND a.block=' . $db->Quote($status) . ' ';
} else {
$searchQuery .= 'WHERE a.block=' . $db->Quote($status) . ' ';
}
$statusBlocked = $status==3 || $status==1?1:$status;
if (!empty($searchQuery)) {
$searchQuery .= ' AND a.block=' . $db->Quote($statusBlocked) . ' ';
} else {
$searchQuery .= 'WHERE a.block=' . $db->Quote($statusBlocked) . ' ';
}
// blocked user $status=3, pending user status=1
if($status==1){
$searchQuery .= ' AND a.lastvisitDate = '. $db->Quote('0000-00-00 00:00:00') . ' ';
}elseif($status==3){
$searchQuery .= ' AND a.lastvisitDate != '. $db->Quote('0000-00-00 00:00:00') . ' ';
Add a comment to this line
}
$statusArray = array(2=>JText::_('COM_COMMUNITY_ALL_USER'),0=>JText::_('COM_COMMUNITY_ACTIVITIES_ACTIVE'),1=>JText::_('COM_COMMUNITY_PENDING'));
$statusArray = array(2=>JText::_('COM_COMMUNITY_ALL_USER'),0=>JText::_('COM_COMMUNITY_ACTIVITIES_ACTIVE'),1=>JText::_('COM_COMMUNITY_PENDING'),3=>JText::_('COM_COMMUNITY_BLOCKED'));
Good morning, I tried to modify the code myself, although I am not a computer, nor do I have much experience with codes, I've done locally to not break anything, and I can not run the code rather break something in jomsocial and not get verloen backend. It would be nice to make the change tn yourself?
Thank you very much.
Hi Luis,
Well, I suggest we wait the latest stable version for fixing this, because the next version will be released soon.
Thank you
I have 14 days subscription and seeing that every time I update jomsocial problems arise that did not exist, it gives me is not enough to wait for update time, install the update, check that errors occur and add new tickets to me the resolved.