[SOLVED] CB Auto Action After Save Registration; available fields?

What fields are available to the query using the After Save User Registration? My new user is filling in all the fields included in the query field list, but I am seeing a 1054 error. I'm assuming that all the fields filled in are available to the query using just the field name; is this correct?

Also, the user must select a subscription plan; is the plan_id of the subscription table available to the query? I am using SQL queries in the plans to store this info but it would be easier to manage if the action query could handle it.

Duh; read the tutorial and see that I need [] round the field names.

What fields are available to the query using the After Save User Registration? My new user is filling in all the fields included in the query field list, but I am seeing a 1054 error. I'm assuming that all the fields filled in are available to the query using just the field name; is this correct?

The entire POST data and any fields you have in CB > Field Management. I recommend using the below triggers though for what you're implementing to work for frontend and backend registrations.

onAfterUserRegistration, onAfterNewUser

Also, the user must select a subscription plan; is the plan_id of the subscription table available to the query? I am using SQL queries in the plans to store this info but it would be easier to manage if the action query could handle it.

Possibly, but it'd be in the POST data. I recommend just using CBSubs SQL Actions if you need to act on subscription state change or acting on the appropriate CBSubs triggers in CB Auto Actions for CBSubs behavior.

I'm now using AfterNewUser action but the simplest query is failing with 1054 error .
and this query seems to do nothing at all: (I am using the virtuemart Countries table to fill the cb_select_country query drop-down, to get an integer value, as required)

Your query isn't valid. Surround your substitutions with single quotes when used in a query. Example as follows.

'[user_id]'

We do sanitize the substitutions to be query safe, but we don't add the quotes automatically as there's various usages where that'd break things.

Your second query also has broken SQL. You've a rogue single quote after city in your column list. Example as follows how it should be formatted.

Thanks for the information; however I have set the action for AfterUserRegistration with the single query and am getting the 1054 error message again [when I tried the AfterNewUser trigger nothing happened]

When I use the Click to Execute option on the Globals page of the plugin, it works, inserting a record in the vmusers table with virtuemart_user_id =0; the same applies to the second query; test works; real data fails error 1054