Zen Cart Logo
Forums / General Questions / Missing entry in address_book

Missing entry in address_book

Locked

Views: 510

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
15 Dec 2010, 5:05 PM
#1
rfree190 avatar

rfree190

Zen Follower

Join Date:
Sep 2007
Posts:
176
Plugin Contributions:
0

Missing entry in address_book

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

15 Dec 2010, 6:15 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Missing entry in address_book

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 ...

15 Dec 2010, 10:32 PM
#3
rfree190 avatar

rfree190

Zen Follower

Join Date:
Sep 2007
Posts:
176
Plugin Contributions:
0

Re: Missing entry in address_book

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!