Hot to restore the field address_type_name?

[Londom]

Hi,
i've deleted (not disabled) the field address_type_name and now i get the error "check failed: ST has no name" when filling shipping address.
I tried to recreate the field manually, but i still obtain the error.

[jenkinhill]

First:  http://forum.virtuemart.net/index.php?topic=79799.0

[jenkinhill]

Before doring anything, backup using Akeeba and test these on the backup copy. I'm assuming you did not already have a backup.....

I suspect that the relevant userfield data has been deleted from the database, so if you have not entered any categories or products you could use one of the reset all tables options in the tools & migration pane.

If you have products etc, then use phpMyAdmin to look at the table xxx_virtuemart_userfields -  address_type_name is usually shown with virtuemart_userfield_id = 7  - if it is missing then you will need to re-enter that data row. Probably the easiest way is to restore the whole userfield table to default, this can be done by running the attached sql file.

[attachment cleanup by admin]