Adding fields to mijoshop via auto action

hi there, i just installed mijoshop and CB and would like to auto add the address fields from the registration of CB to the address fields of mijoshop. it adds the user etc but not address or other extra fields.
here is my code in auto action. (sorry, not that good with code) joomla 2.5.9 cb 1.9
also attached a screenshot of the auto action plugin.

That's not a valid query. You can't mix PHP inside of a query. Please see the below set of tutorials regarding SQL.

www.w3schools.com/sql/sql_intro.asp

You write the queries in the same way you would if you were using them in phpmyadmin with the exception that instead of your table prefix you use #__ and that substitutions can be used as well (e.g. `user_id` = '[user_id]').

The below will probably work. Am not familiar with that extensions database and is purely based off what you have already provided and am guessing customer id within your extension is user id (the ID as seen in _users and _comprofuler).

Note the above is just an update query. If the row doesn't exist it won't do anything.

INSERT INTO `wrkr1_mijoshop_address`
( `customer_id`, `firstname`, `lastname`, `address_1`, `city`, `postcode`)
(SELECT `user_id`, `firstname`, `lastname`, `cb_address` , `cb_city` , `cb_postalcode`
FROM `wrkr1_comprofiler`
WHERE `user_id` = (
SELECT MAX( `user_id` )
FROM `wrkr1_comprofiler` )
)

That's not correct again. Why are you using a select query for user id? That's just going to pull the last user row in your database and not the current user row. Please see my above reply. You should be doing the below.

WHERE `user_id` = '[user_id]'

In your usage if you had 2 people register at the same time then 1 would not working. Please ensure you're using the above so it is absolutely specific to their user id.