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

Started by Twototango, February 01, 2021, 15:04:29 PM

Previous topic - Next topic

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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

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

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.