Missing entry in address_book

[RFree190]

I was checking the address_book table in the database and noticed that the entry_state field is empty. It is not being populated with data like the rest of the fields.

Anyone have any idea why?
Or, more importantly, how do I fix it?

Thanks!

Rick

[Ajeh]

Do you see filled in the:
entry_country_id
entry_zone_id

The State will be blank as that is a looked up value based on those ...

When you see a:
entry_zone_id

that is 0, then you will see a State ...

[RFree190]

Yes, those two have data in them.

My issue was, we are pulling out order data into an external order processing database, and the state was missing.

I have suggested to our programmers that they need to pull address info from each ORDER table, not the address book table.

Thank you for a quick reply. I appreciate it!