Magento 2.1 Customers Address Book Not Displayed Properly

[chrone81]

Steps to reproduce

1. Install Magento 2.1 CE
2. Add or Edit Address Book when checking out
3. Go to My Account to see my Address Book

Expected result

1. The Customers Address Book information should be displayed properly

Actual result

1. The Address Book in frontend "customer/address" and backend "Customer Information > Customer View > Addresses" display field variables instead of the address value we just entered.

[andimov]

@chrone81
Thank you for reporting!
Did you migrate from a previous version?

[andimov]

@chrone81
Try to use this solution: #5873 (comment)

[chrone81]

Nope, this is on new installation. :)

Thanks @andimov I'll look it up on my spare time.

[ilol]

@chrone81 did you have a chance to look up?

[chrone81]

@andimov @ilol Oops, I missed this one, sorry, busy at work. Let me check real quick today and update you later.

[chrone81]

@ilol Sorry I'm no expert with MySQL cli. How to update the entity_type_id to '2' properly?

select * from eav_entity_type;
+----------------+------------------+----------------------------------------------------+
| entity_type_id | entity_type_code | entity_model |
+----------------+------------------+----------------------------------------------------+
| 4 | customer | Magento\Customer\Model\ResourceModel\Customer |
| 7 | customer_address | Magento\Customer\Model\ResourceModel\Address |
+----------------+------------------+----------------------------------------------------+

update eav_entity_type set entity_type_id = '2';
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (chronic101_magento2.eav_attribute, CONSTRAINT EAV_ATTRIBUTE_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID FOREIGN KEY (entity_type_id) REFERENCES eav_entity_type (entity_type_id) O)

select * from eav_attribute_set;
+------------------+----------------+--------------------+------------+
| attribute_set_id | entity_type_id | attribute_set_name | sort_order |
+------------------+----------------+--------------------+------------+
| 4 | 4 | Default | 2 |
| 7 | 7 | Default | 2 |
| 10 | 10 | Default | 1 |
| 13 | 13 | Default | 1 |
| 16 | 16 | Default | 1 |
| 19 | 19 | Default | 1 |
| 22 | 22 | Default | 1 |
| 25 | 25 | Default | 1 |
| 28 | 13 | Top | 0 |
| 31 | 13 | Bottom | 0 |
| 34 | 13 | Gear | 0 |
| 37 | 13 | Sprite Stasis Ball | 0 |
| 40 | 13 | Sprite Yoga Strap | 0 |
| 43 | 13 | Downloadable | 0 |
| 46 | 13 | Bag | 0 |
+------------------+----------------+--------------------+------------+

[sevos1984]

Is this still actual in latest release version?

[sevos1984]

We are closing this issue because it hasn’t been updated in more than two weeks. If you can still reproduce this issue, please create a new GitHub issue report.