CB Query Field not working the same like before.

1 month 2 days ago #337812 by tlwebdesign

I'm in the process op updating a community website that was still on J3, CB 2.6.0 and Query Field Plugin 5.0.4+build.2017. 

There i have this query on a field: SELECT * FROM `personeelsnummers` WHERE `personeelsnummer`='[value]' AND `status` = 'Toevoegen' AND NOT EXISTS( SELECT * FROM `uxn04_comprofiler` WHERE `cb_personeelsnummer`='[value]')

Somehow this only worked during registration and not on editing the user in the back-end. Else the validation would fail in backend. 

Well i just now updated to latest CB and Plugin versions and it stopped working like it worked before. Now the validation is also triggered when editing a user on the back-end. 

What do i need to do to get the same behaviour as i had before? 

This code is actually from your tutorial about membership. But that is broken too then because this validation now also runs on editing a user. not only on registration like it did before. 

Kind regards,


Please Log in to join the conversation.

1 month 2 days ago #337820 by krileon
Backend validation can be turned off within CB > Configuration > User Profile by setting "Fields Validation in User Management" to "No". This isn't field specific. I don't quite understand what you're trying to accomplish with that query though. Ideally your NOT EXISTS should probably take into account self (e.g. AND `user_id` != '[user_id]').

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.188 seconds

Facebook Twitter LinkedIn