1. Forums
  3. Support and Presales
  5. Professional Members Support
  7. [SOLVED] proper name format (first letter capitalized)?

[SOLVED] proper name format (first letter capitalized)?

11 years 5 months ago #215078 by krileon
Replied by krileon on topic Re: proper name format (first letter capitalized)?
Enable debug mode and maximum error reporting in Joomla global configuration then attempt to register to see if an error is present. Aside from that I don't know what to tell you as it's confirmed working. For it to fail it's either configured wrong or something is storing the previous user object directly after CB Auto Actions, try ordering CB Auto Actions as last in CB > Plugin Management.

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.

11 years 5 months ago #215129 by thejungle
Replied by thejungle on topic Re: proper name format (first letter capitalized)?
CB Auto Actions is already last. Enabling debug shows the following at the top of the registration screen.
Notice: Undefined index: view in /mnt/vol1/home/t/h/thejun/public_html/components/com_content/router.php on line 48
I've no idea what this means but I've attached a copy of the file hoping that you might know

Please Log in to join the conversation.

11 years 5 months ago #215156 by krileon
Replied by krileon on topic Re: proper name format (first letter capitalized)?
It's a notice coming from Joomla SEF. That happens when a content article URL is relative and missing Itemid then gets SEFed. Ensure everything else is also up to date if you've other incubator projects installed. Aside from that I don't know what more to suggest, perhaps you've something else installed that's overriding your changes; try using the after login trigger to see if it'll fire there.

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.

11 years 5 months ago #215301 by thejungle
Replied by thejungle on topic Re: proper name format (first letter capitalized)?
Still doesn't work, although last night I created a user in the backend and when I viewed it from the front end this morning, there seems to have been a result, however the field displays "ucfirst(Philipa)". I did enter Philipa using a capital letter.

Does this give you any clues? Also not sure if it's related but I did install CB Auto Welcome (I use ACYmail to send welcome emails) and CB Emails over a year ago and they never worked.(They're now unpublished) You did have a look at the time but couldn't find a reason for them not working either. I have a number of other CB plugins that work fine
Attachments:

Please Log in to join the conversation.

11 years 5 months ago #215313 by krileon
Replied by krileon on topic Re: proper name format (first letter capitalized)?
Looks like the extra formatting functions only work in conditionals and not in other substitutions. The below is tested and confirmed working.

Type: Query
Triggers: onAfterLogin
Access: Everybody
Query:
UPDATE `#__comprofiler` SET `firstname` = CONCAT( UCASE( SUBSTR( `firstname`, 1, 1 ) ), LCASE( SUBSTR( `firstname` FROM 2 ) ) ), `middlename` = CONCAT( UCASE( SUBSTR( `middlename`, 1, 1 ) ), LCASE( SUBSTR( `middlename` FROM 2 ) ) ), `lastname` = CONCAT( UCASE( SUBSTR( `lastname`, 1, 1 ) ), LCASE( SUBSTR( `lastname` FROM 2 ) ) ) WHERE `id` = '[user_id]';
UPDATE `#__users` AS a LEFT JOIN `#__comprofiler` AS b ON a.`id` = b.`id` SET a.`name` = CONCAT_WS( ' ', b.`firstname`, b.`middlename`, b.`lastname` ) WHERE a.`id` = '[user_id]';

The above query will update first, middle, and last names in CBs table and change their first character to upper case. It'll then merge them together and update it in the Joomla users table.

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
  1. Forums
  3. Support and Presales
  5. Professional Members Support
  7. [SOLVED] proper name format (first letter capitalized)?
Time to create page: 0.243 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Support and Presales
  4. Professional Members Support
  5. [SOLVED] proper name format (first letter capitalized)?

Search

Login / Logout

User Menu