CB Auto Actions (Query type) not working

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

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.

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

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.

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 is fixed in next release of CB.

Warning: mysqli_free_result(): Couldn't fetch mysqli_result in N:\xampp\htdocs\eintero\libraries\joomla\database\driver\mysqli.php on line 791

This can be fixed by applying the 2 fixes below.

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

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

Okay thanks Kyle - so then does the frontend report of 1054 when I try to update a profile suggest anything to you?

The error message should say where in the query it's erroring at.

Does 1054 mean there's an unknown column somewhere in my CB Auto Action - either in the Conditional or the query statement?

Typically yes as 1054 is an SQL error for unknown column.

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

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.