CB Auto Actions (Query type) not working
- AiC13
- OFFLINE
-
Junior Member
- Posts: 25
- Thanks: 3
- Karma: 1
10 years 6 months ago - 10 years 6 months ago #234534
by AiC13
CB Auto Actions (Query type) not working was created by AiC13
Hi,
I am having problems getting a CB Auto Actions (Query type). I have debugging enabled and I am not getting any error messages, which leads me to think the trigger isn't firing.
What I want to have happen is when a CB user updates their profile, that a field in their CB Profile will get updated in another db table that is used by a different extension.
I have tried different syntax for the query statement, but none of them seem to work.
I have attached screenshots of the configuration for the CB Auto Action that isn't working. Any help or suggestions would be appreciated!
Best regards,
Paul Orwig
I am having problems getting a CB Auto Actions (Query type). I have debugging enabled and I am not getting any error messages, which leads me to think the trigger isn't firing.
What I want to have happen is when a CB user updates their profile, that a field in their CB Profile will get updated in another db table that is used by a different extension.
I have tried different syntax for the query statement, but none of them seem to work.
I have attached screenshots of the configuration for the CB Auto Action that isn't working. Any help or suggestions would be appreciated!
Best regards,
Paul Orwig
Last edit: 10 years 6 months ago by AiC13.
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68528
- Thanks: 9093
- Karma: 1434
10 years 6 months ago - 10 years 6 months ago #234544
by krileon
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.
Replied by krileon on topic CB Auto Actions (Query type) not working
Your query looks like you're using single quotes around column names and table names. You only use single or double quotes for literal values. Your query should be as follows.
Please to always enable debug mode and maximum error reporting in Joomla global configuration when testing so errors can be exposed.
UPDATE `#__jblance_user` SET `ug_id` = '[cb_flusertype]' WHERE `user_id` = '[user_id]'Please to always enable debug mode and maximum error reporting in Joomla global configuration when testing so errors can be exposed.
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.
Last edit: 10 years 6 months ago by krileon.
The following user(s) said Thank You: AiC13
Please Log in to join the conversation.
- AiC13
- OFFLINE
-
Junior Member
- Posts: 25
- Thanks: 3
- Karma: 1
10 years 6 months ago #234558
by AiC13
Replied by AiC13 on topic CB Auto Actions (Query type) not working
Thanks Kyle, you were right about the backticks - I didn't notice that!
I changed all the single quotes to backticks. Now I get a 1054 error on the frontend after I try to update a profile.
I have debugging enabled for CB Auto Actions, and Joomla debugging is set to on. When I look at CB Auto Actions Tools, it always says "No errors were found".
I do get a very long stream of Joomla errors on the CB Auto Actions views, here's a copy paste of them - please let me know if these suggest the problem/solution to you:
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\libraries\joomla\filter\input.php on line 656
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\libraries\joomla\filter\input.php on line 659
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\libraries\joomla\filter\input.php on line 656
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\libraries\joomla\filter\input.php on line 659
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Save Apply Cancel
Auto Action: Edit [Create row in jblance_user: Pioneer]
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Strict Standards: Only variables should be passed by reference in N:\xampp\htdocs\eintero\components\com_comprofiler\plugin\user\plug_cbautoactions\models\content.php on line 229
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
I changed all the single quotes to backticks. Now I get a 1054 error on the frontend after I try to update a profile.
I have debugging enabled for CB Auto Actions, and Joomla debugging is set to on. When I look at CB Auto Actions Tools, it always says "No errors were found".
I do get a very long stream of Joomla errors on the CB Auto Actions views, here's a copy paste of them - please let me know if these suggest the problem/solution to you:
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\libraries\joomla\filter\input.php on line 656
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\libraries\joomla\filter\input.php on line 659
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\libraries\joomla\filter\input.php on line 656
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\libraries\joomla\filter\input.php on line 659
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Save Apply Cancel
Auto Action: Edit [Create row in jblance_user: Pioneer]
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 328
Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Strict Standards: Only variables should be passed by reference in N:\xampp\htdocs\eintero\components\com_comprofiler\plugin\user\plug_cbautoactions\models\content.php on line 229
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68528
- Thanks: 9093
- Karma: 1434
10 years 6 months ago - 10 years 6 months ago #234561
by krileon
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.
Replied by krileon on topic CB Auto Actions (Query type) not working
All of that is safe to ignore. 1 is a minor bug in Joomla it self and the other is just a depreciation notice, which is already fixed for next CB release.
www.joomlapolis.com/forum/153-professional-member-support/222189-user-login-forgot-login-doesnt-work?limitstart=0#231858
www.joomlapolis.com/forum/153-professional-member-support/222189-user-login-forgot-login-doesnt-work?start=6#231990
This is fixed in next release of CB.Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in N:\xampp\htdocs\eintero\administrator\components\com_comprofiler\library\phpinputfilter\phpinputfilter.inputfilter.php on line 331
This can be fixed by applying the 2 fixes below.Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791
www.joomlapolis.com/forum/153-professional-member-support/222189-user-login-forgot-login-doesnt-work?limitstart=0#231858
www.joomlapolis.com/forum/153-professional-member-support/222189-user-login-forgot-login-doesnt-work?start=6#231990
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.
Last edit: 10 years 6 months ago by krileon.
The following user(s) said Thank You: AiC13
Please Log in to join the conversation.
- AiC13
- OFFLINE
-
Junior Member
- Posts: 25
- Thanks: 3
- Karma: 1
10 years 6 months ago #234562
by AiC13
Replied by AiC13 on topic CB Auto Actions (Query type) not working
Okay thanks Kyle - so then does the frontend report of 1054 when I try to update a profile suggest anything to you?
Does 1054 mean there's an unknown column somewhere in my CB Auto Action - either in the Conditional or the query statement?
Here's my query statement:
UPDATE `#__jblance_user` SET `ug_id` = `[cb_flusertype]` WHERE `user_id` = `[user_id]`
I've verified all those column names are correct. Do they each need the backticks (for the source and target db tables)? I'm not sure what I'm missing here...
Does 1054 mean there's an unknown column somewhere in my CB Auto Action - either in the Conditional or the query statement?
Here's my query statement:
UPDATE `#__jblance_user` SET `ug_id` = `[cb_flusertype]` WHERE `user_id` = `[user_id]`
I've verified all those column names are correct. Do they each need the backticks (for the source and target db tables)? I'm not sure what I'm missing here...
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68528
- Thanks: 9093
- Karma: 1434
10 years 6 months ago #234582
by krileon
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.
Replied by krileon on topic CB Auto Actions (Query type) not working
The error message should say where in the query it's erroring at.Okay thanks Kyle - so then does the frontend report of 1054 when I try to update a profile suggest anything to you?
Typically yes as 1054 is an SQL error for unknown column.Does 1054 mean there's an unknown column somewhere in my CB Auto Action - either in the Conditional or the query statement?
You're using an apostrophe ( ` ) around your substitution when you should be using single quotes ( ' ). Please see my query above as I gave you exactly what you needed. Below is the query again.I've verified all those column names are correct. Do they each need the backticks (for the source and target db tables)? I'm not sure what I'm missing here...
UPDATE `#__jblance_user` SET `ug_id` = '[cb_flusertype]' WHERE `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.
The following user(s) said Thank You: AiC13
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.478 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Professional Members Support
- CB Auto Actions (Query type) not working