Hello,
I am new in the forum.
When someone registers to our community, the admin gets an email and so does the user.
Then (I'm the admin) I go to the back end to approve this user.
When I select the check box and click on the "approve selected" I get this error:

1054 Unknown column 'b.points' in 'field list' SQL=SELECT *, b.points FROM `jos_users` AS a WHERE a.block='1' ORDER BY id desc

If instead I list the users and click on the red circle "enable user" it enables the user, but there is no email sent to the user telling that he/she has been approved.

Please help!
Thanks

Hi

Your posts have been placed on hold as it appears the backlink has been removed from your site. The Standard licence must have the backlink displaying as per these links www.jomsocial.com/license-agreement or here www.jomsocial.com/pricing in the FAQ

"Standard Licence holders must display the Jomsocial backlink in an un-alerted state. Sites with modified or removed backlinks will not be supported"

Alternatively you can upgrade to the Pro version at any time by doing the following
please send the balance of $50 to sales AT jomsocial.com via PayPal, and drop us an email here. For more information,please contact our billing department.

Please let us know once the backlink is reinstated and we can assist you further

OK. I did not know.
It is back on. I will tell ask around and tell them if they want me to remove it it is $50. My fault.

Also, could you tell me what do I have to change to see the font on the buttons not white? (it is barely readable).
Thanks!!

Hi Chengetai,

Can you provide me cpanel access so i can inspect your phpmyadmin database ?

Warm regards,

David

Is this something I can post here? Is it safe?

Hi Chengetai,

you can add it by edited your first post and added it there :)

Warm regards,

David

Done.
Changed email settings to sendmail but still when admin approves user no email is sent.
All the rest of emails yes...

Hi Chengetai,

i apologize for delay answer because saturday and sunday are weekend :)

back to your issue : i can't login to your cpanel with credentials you gave me... maybe you can check again ?

Warm Regards,

David

Please check now. Sorry about that...

Hi Chengetai,

i already fixed your issue.. i change this file : administator / components / com_community / models / user.php on line 219..
from

$query = 'SELECT *, b.points FROM ' . $db->quoteName('#__users') . ' AS a '

$query = 'SELECT * FROM ' . $db->quoteName('#__users') . ' AS a '

Hi,
Just registered a new user and clicked on approved, and still the same error.
When I go back the user is approved but no email is triggered to tell the user that has been approved.

Also the notification bubble does not reset and gives always a "no result" when clicked

Hi Dani,

you did an upgrade to our latest jomsocial right ? so the change i was made is replace with original file.. i already created same file with "user-copy" as the name..

if you click notifications about on the top jomsocial backend (in this case "Pending member") you must changed the filter into "All User Types" like picture below :)

Hi David,
Now I don't get the error. I will back up the file you modified.
Still when I approve a user no email is sent, so they don't know they are approved.
Thanks for helping me.