CB Auto Actions (Query type) not working

Thanks Kyle - I had missed the distinction between where to use backticks and where to use single quotes/apostrophes within the query statement. Those Auto Actions are working now!

Thanks for the great job of giving support that you are doing here!

Best,

Paul Orwig

This CB Auto Action now works fine on my localhost w/ XAMPP, but when try to add it on the production site (Joomlapolis hosting), I get this error message in the browser when I add the query statement and then try to save it try to save it at that point, I get this response in the browser:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [no address given] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Note: I am able to apply/save this CB Auto Action as I work my way through the different fields. The error only happens when I add the query statement:

UPDATE `#__jblance_user` SET `ug_id` = '[cb_flusertype]' WHERE `user_id` = '[user_id]'

Any ideas why I am not able to save this CB Auto Action on the production site?

Server security. Please put in a hosting ticket as a security exception will need to be made so you can add that. You should see mod_security denying it in your virtualmin error logs.