Skip to Content Skip to Menu

Username UNIQUE

  • chanteur94
  • chanteur94
  • OFFLINE
  • Posts: 302
  • Thanks: 13
  • Karma: 1
9 years 7 months ago #260977 by chanteur94
Username UNIQUE was created by chanteur94
Hi

I notice that with CB Query Field we can have an unique 'alias' , and the validation operate without saving the form. (just after a tab for example)

Is is possible to have the same thing with the 'username' who is already 'unique' but validation operate AFTER saving the form.
(I try the tutorials but it doesn't work)

Thank you

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48478
  • Thanks: 8282
  • Karma: 1443
9 years 7 months ago #261023 by krileon
Replied by krileon on topic Username UNIQUE
You need to edit the Username field and add Query Validation provided by CB Query Field to query the database and check if the username exists then validate on empty results. Example configuration as follows.

Query:
Code:
SELECT `id` FROM `#__users` WHERE `username` = '[value]'
Validate On: Empty Results
Ajax Validation: Enabled


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 or Create an account to join the conversation.

  • chanteur94
  • chanteur94
  • OFFLINE
  • Posts: 302
  • Thanks: 13
  • Karma: 1
9 years 7 months ago - 9 years 7 months ago #261024 by chanteur94
Replied by chanteur94 on topic Username UNIQUE
I've already tried this and I obtain message display (see the 2 captures).

What's wrong ?

Thank you

CB 2.0.7 Joomla 3.4 CB Query 4.0.5
Attachments:
Last edit: 9 years 7 months ago by chanteur94.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48478
  • Thanks: 8282
  • Karma: 1443
9 years 7 months ago #261040 by krileon
Replied by krileon on topic Username UNIQUE
Username and Email fields are both already unique. There's also a built in username checker that you can turn on within CB > Configuration > Registration and enabling "Ajax Username Checker". The only reason to use CB Query Field is for a more customized check or error display.

As for the query field results your site has errors or something is forcing changes to the buffer or header. Check server error log for notices, warnings, or errors. If you see any then they need fixed. If they output to buffer (e.g. echo) they will break the JSON response. It's similar to why CB Gallery photos would not display for you. Will look into clearing the buffer for next release, but your install should not depend on ajax endpoints having to do this.

forge.joomlapolis.com/issues/5194


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 or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum