Okay,
Initially I tried this and it failed at the point where it sends a verifcation email, but I can't be certain that I had deleted the test user account. I then deleted both from Hika and Joomla core.
On my second attempt I reached the stage where I needed to log in. Oddly the address fields were already filled in (see attachment) which can't be right.
After entering new user name/password/etc I get the same error as noted above:
JDatabaseMySQLi::query: 1054 - Unknown column 'address_street2' in 'field list' SQL=INSERT IGNORE INTO `qlf7t_hikashop_address` ( `address_street`,`address_street2`,`address_city`,`county`,`address_user_id`,`address_default` ) VALUES ( '2 Lawns Courtyard, Broad Road','Wickham Market','Woodbridge','Suffolk','8','1' )
I have left debug mode on if you have a chance to test it again. What do you suggest?
Note: I changed the names of some custom fields and added a new one (text entry) for County since all my customers are UK-based. The State field is linked to the Country one and not showing Country resulted in State not having any options. Since I just wanted State (or County), I had to create a new one.
Thanks a lot for your help with this Nicolas,
Luke