kunena 1.6.1 gender integration
- sorema
- OFFLINE
-
Senior Member
- Posts: 63
- Thanks: 0
- Karma: 1
13 years 5 months ago #146741
by sorema
kunena 1.6.1 gender integration was created by sorema
hi everybody i need some help figuring this out.
i fixed the gender CB profile field integration problem following istructions in this topic but the problem is that i have over 2000users in my website, who filled the field with old gender fields.. and now that i changed to _UE_MALE / _UE_FEMALE all of my users are with no gender. there's a way to alter the field value using a sql query from past definition to new one?
thanks in advance.
i fixed the gender CB profile field integration problem following istructions in this topic but the problem is that i have over 2000users in my website, who filled the field with old gender fields.. and now that i changed to _UE_MALE / _UE_FEMALE all of my users are with no gender. there's a way to alter the field value using a sql query from past definition to new one?
thanks in advance.
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68602
- Thanks: 9108
- Karma: 1434
13 years 5 months ago #146806
by krileon
From 1 to _UE_MALE (assumes 1 = Male)
[code:1]
UPDATE `jos_comprofiler` SET `cb_gender` = '_UE_MALE' WHERE `cb_gender` = 1;
[/code:1]
From 0 to _UE_FEMALE (assumes 0 = Female)
[code:1]
UPDATE `jos_comprofiler` SET `cb_gender` = '_UE_FEMALE' WHERE `cb_gender` = 0;
[/code:1]
Adjust as necessary, would need to be ran directly from database such as via phpmyadmin.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Re:kunena 1.6.1 gender integration
You'll need to perform a database query such as the following.there's a way to alter the field value using a sql query from past definition to new one?
From 1 to _UE_MALE (assumes 1 = Male)
[code:1]
UPDATE `jos_comprofiler` SET `cb_gender` = '_UE_MALE' WHERE `cb_gender` = 1;
[/code:1]
From 0 to _UE_FEMALE (assumes 0 = Female)
[code:1]
UPDATE `jos_comprofiler` SET `cb_gender` = '_UE_FEMALE' WHERE `cb_gender` = 0;
[/code:1]
Adjust as necessary, would need to be ran directly from database such as via phpmyadmin.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.147 seconds
