Skip to Content Skip to Menu

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

10 years 5 days ago - 10 years 4 days ago #267134 by tlwebdesign
[SOLVED] auto action not working anymore. At a total loss please help asap was created 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: 10 years 4 days ago by krileon.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 49333
  • Thanks: 8437
  • Karma: 1465
10 years 5 days ago #267156 by krileon
Replied by krileon on topic auto action not working anymore. At a total loss please help asap
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.

10 years 4 days ago #267198 by tlwebdesign
Replied by tlwebdesign on topic auto action not working anymore. At a total loss please help asap
Using the latest nightly did the job.

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

Moderators: beat, nant, krileon
Powered by Kunena Forum