kunena 1.6.1 gender integration

13 years 4 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.

Please Log in to join the conversation.

13 years 4 months ago #146806 by krileon
Replied by krileon on topic Re:kunena 1.6.1 gender integration

there's a way to alter the field value using a sql query from past definition to new one?

You'll need to perform a database query such as the following.

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: beatnantkrileon
Time to create page: 0.180 seconds

Facebook Twitter LinkedIn