Anyway remove the gender selected?
By kerrymusic on Sunday, 14 May 2017
Posted in General
Likes 0
Views 267
Votes 0
Anyway remove the gender selected? not selected any !!!! delete something in database?

have a easy way have one more option of "none" for gender?
if too complicate then forget it

Yes, that is possible but you have change that translation string.

1. Enable Allow 'Custom' option from the Gender custom field setting, screenshot : http://take.ms/DzQXS

2. Override this language translation :


PLG_FIELDS_GENDER_SELECT_CUSTOM



no result for gender at all

Perhaps you can update your Joomla backend, FTP and PHPMYADMIN access at your first post (edit your post and put your site access at your optional information) so we can better have a check.
Arlex Wong
·
Monday, 15 May 2017 14:10
·
0 Likes
·
0 Votes
·
0 Comments
·
Profile types -> Select your desired profile type -> Gender field -> Right side options -> Turn off everything for view and make it a not necessary field in the core options.
Sabih
·
Sunday, 14 May 2017 05:47
·
0 Likes
·
0 Votes
·
0 Comments
·
not !!
Gender field already not compulsory !

I want one of the user dont select any male/female !! but that user already "click" choose as male!
kerrymusic
·
Sunday, 14 May 2017 07:00
·
0 Likes
·
0 Votes
·
0 Comments
·
Can I remove the selected option in database?
kerrymusic
·
Sunday, 14 May 2017 07:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Kerry,

I am sorry but I am actually a little lost here. Did you mean that the "Male" is already pre-selected when you try to register a new user on the site or the other way around?

I have just tested this locally and when I try to register on the site, none of the gender are selected, http://take.ms/C7dmQ
Mark
·
Sunday, 14 May 2017 12:35
·
0 Likes
·
0 Votes
·
0 Comments
·
The quickly way to remove this have to remove the record from your database.

1. Run this SQL query to get all of your existing custom field (check my attached screenshot how to find that Gender custom field id)


// Replace #__ to your current table prefix

SELECT * FROM `#__social_fields` ORDER BY `id` ASC


2. Run this and double check is it all is under gender custom field


// Replace #__ to your current table prefix

// Replace 10 to your id what you found from your first step

select * from `#__social_fields_data` where `field_id` = 10 and `type` = 'user';


3. Run this sql query and delete it


// Replace #__ to your current table prefix

// Replace 10 to your id what you found from your first step

delete from `#__social_fields_data` where `field_id` = 10 and `type` = 'user';


Note : Make sure you have backup your database all the data before you execute above SQL query.

By the way, thanks for help Sabih.
Arlex Wong
·
Sunday, 14 May 2017 12:48
·
0 Likes
·
0 Votes
·
0 Comments
·
thanks i will try

that important as i will list out user by gender

but i dont want to list out admin and super user

but admin already click gender as male
kerrymusic
·
Sunday, 14 May 2017 15:29
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes, gender is 10, but if I search in field data table !! no result for gender !! ONLY Name in the table

select * from `#__social_fields_data` where `field_id` = 10 and `type` = 'user';
kerrymusic
·
Monday, 15 May 2017 05:15
·
0 Likes
·
0 Votes
·
0 Comments
·
It will not show any 'GENDER' name from the result is because the storing part will not store this 'GENDER' name, it actually based on the custom field id, if the 'GENDER" custom field id is 10, and when you execute this following SQL query from your database, it did show the result, you can run that delete SQL query.



select * from `#__social_fields_data` where `field_id` = 10 and `type` = 'user';
Arlex Wong
·
Monday, 15 May 2017 10:46
·
0 Likes
·
0 Votes
·
0 Comments
·
yes i know that is 10
so strange that table no result for 10
only 2
kerrymusic
·
Monday, 15 May 2017 11:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Then you have to check whether this is true, is it only 2 user account show that gender value is 'Male'?

If no, find one of the user id then run this following SQL query from your database.


SELECT * FROM `#__social_fields_data` where `uid` = useridhere;


And see whether got that `field_id` 10 . If don't have but it show this user profile highlighted 'Male', mean the PHP file get modified, it always show the 'Male' as the default value.
Arlex Wong
·
Monday, 15 May 2017 11:31
·
0 Likes
·
0 Votes
·
0 Comments
·
no result for gender at all
kerrymusic
·
Monday, 15 May 2017 13:38
·
0 Likes
·
0 Votes
·
0 Comments
·
have a easy way have one more option of "none" for gender?
if too complicate then forget it
kerrymusic
·
Monday, 15 May 2017 13:41
·
0 Likes
·
0 Votes
·
0 Comments
·
yes, custom work well
kerrymusic
·
Tuesday, 16 May 2017 14:07
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome. Glad to hear that your issue has been resolved now.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.
Arlex Wong
·
Tuesday, 16 May 2017 14:18
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post