[solved] 3 gender fields?!

hi,

if i enable the gender field i get 3 options?!

Hi Dennis,

The query only selects distinct values, so there might be at least one entry in your database where mannlich has a space added somewhere.

You can try running this query in phpmyadmin to see:

Make sure you replace #_ with your db prefix and 2 with your gender field ID (2 is the default FIELD_GENDER)

Let me know the result.

on jomsocial i have only 2 fields and everything works fine. i dont know much about sql. please can you look into it? i sent you cpanel login a few weeks ago

No, not everything woks fine. Stats are mistaken also.


Some of your users have:
male as value wereas others have COM_COMMUNITY_MALE

Geommunity3 take it as 2 different values.
Your mistaken values probably come from older Jomsocial (or language files) versions values.
Go to:
administrator/index.php?option=com_community&view=users

and save once again the Gender field for every users.
This will solve the issue.

Let me know

You were right. Now it works:-)