Error 1054 Unknown column 'address_type_name' in 'where clause' (SOLVED)

[Twototango]

Hi all, thank you for helping me with this problem.

Whenever I try to add an extra shipto adddress to an account, I get this error message.

1054 Unknown column 'address_type_name' in 'where clause'

Currently on VirtueMart 3.8.8 10472, Joomla 3.9.23 and PHP 7.4
Template Yootheme Pro + VMUIkit 10.2

Tried:
- Updating VM and AIO to current versions.
- PHP 7.3 and PHP 7.4
- Install and update database tables from VM Tools & Migration
- Joomla's own database 'fix' function
- Disabling VMUIkit and all overrides

Nothing seems to make any difference.

Also not loading the cart when login out and back in. maybe related maybe not can't say right now.
But maybe it's a clue for you.

Thanks Jack

[Jörgen]

You can not disable the field "address_type_name" in the input form, it is needed to separate an shipping address from the normal invoce address.

Jörgen @ Kreativ Fotografi

[Twototango]

Thank you Jörgen.

That's it... I overlooked that... the field was not only disabled... but totaly missing from the shopper fields.
Added a new one in the shopper fields and all is working again.

Time to curb my clients TOA i guess ;-)

Thanks agian Jack

[Jörgen]

Nice to hear you solved it

Jörgen @ Kreativ Fotografi