Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

[SOLVED] auto action not working anymore. At a total loss please help asap

9 years 3 months ago - 9 years 3 months ago #267134 by tlwebdesign
Hi guys,

I have been developing a website. now trying to get it all the dev back to the live version.

I have an issue where the Auto Action is not working.

UPDATE `personeelsnummers` SET `status`= 'Geregistreerd' WHERE `personeelsnummer` = '[cb_personeelsnummer]';
UPDATE `personeelsnummers` SET `user`='[user_id]' WHERE `personeelsnummer` = '[cb_personeelsnummer]';
UPDATE `personeelsnummers` SET `naam`='[name]' WHERE `personeelsnummer` = '[cb_personeelsnummer]';
UPDATE `personeelsnummers` SET `afdeling`='[cb_bedrijfsonderdeel]' WHERE `personeelsnummer` = '[cb_personeelsnummer]';
UPDATE `personeelsnummers` SET `email`='
Last edit: 9 years 3 months ago by krileon.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 3 months ago #267156 by krileon
Why are you doing so many update queries? They all have the same condition and are modifying the same table. That can all be a single update query. Try the following action.

Global
Triggers: After New User, After User Registration
Type: Query
User: Automatic
Access: Everybody
Action
Query:
Code:
UPDATE `personeelsnummers` SET `status` = 'Geregistreerd', `user` = '[user_id]', `naam` = '[name]', `afdeling` = '[cb_bedrijfsonderdeel]', `email` = '[email]' WHERE `personeelsnummer` = '[cb_personeelsnummer]'

Please also ensure you've the latest CB 2.x nightly found below and latest CB Auto Actions 6.3.1.

www.joomlapolis.com/downloads/doc_details/640-community-builder-nightly-build

If your issue persists ensure debug mode and maximum error reporting in Joomla global configuration has been enabled so any errors that are occurring will output.


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.
The following user(s) said Thank You: tlwebdesign

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

9 years 3 months ago #267198 by tlwebdesign
Using the latest nightly did the job.

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

Moderators: beatnantkrileon
Powered by Kunena Forum