Address not showing

[Rigel]

Sorry. I thought I had explained I had had to revert to 1.3.9f so that is what I am working in at the moment, and one of the problems is that in the order table, the customers_address_format_id" and similar fields appear as value 6 (rather than 1).

[Ajeh]

Gotcha ... wanted to be sure we were on the same page ...

Before going through a lot of work ... let's peek at what is *really* broken ...

1 check the table:
address_format

and check the address_format_id that they are setup right ...

2 check the table:
countries

and check the address_format_id are setup right ...

3 if both tables:
address_format
countries

are using the correct address_format_id ... then let's check the next stage ...

4 check the table:
address_book

and check the records for the Customer based on the customers_id to see what the field entry_country_id they are setup for ...

4 check the table:
orders

for the 3 fields:
customers_address_format_id
delivery_address_format_id
billing_address_format_id

Based on all of these checks of the database ... where is the relationship between the address_format_id and the orders breaking down?

If the only issue is that you have countries that need to be fixed on the address_format_id then you can fix the data ...

Example: countries are setup to use address_format_id 6 and it does not exist or should really be set to 1 ...

This means all address_format_id that are set to 6 and should be 1 can be fixed and then the orders can be fixed for the 3 fields as well ...

Are you following where I am going with this?

If you cannot

[Rigel]

Ajeh - thank you so much, you are a genius. I didn't know to check the countries table. When I did, I found that the UK was set to 6. As soon as I changed that it all started to work again. When I compared the version h install to the version f, it seems as though somewhere, despite the documentation, a change is made to the database as version h has 6 rows in the zen-address-format table, not 5. Some others out there might not be aware of this. I wonder if it is a bug?

[Ajeh]

United Kingdom has always been 6 and the settings in the address_format

# 1 - Default, 2 - USA, 3 - Spain, 4 - Singapore, 5 - Germany, 6 - UK/GB
INSERT INTO address_format VALUES (1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country');
INSERT INTO address_format VALUES (2, '$firstname $lastname$cr$streets$cr$city, $state    $postcode$cr$country','$city, $state / $country');
INSERT INTO address_format VALUES (3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$state / $country');
INSERT INTO address_format VALUES (4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country');
INSERT INTO address_format VALUES (5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country','$city / $country');
INSERT INTO address_format VALUES (6, '$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country','$postcode / $country');

So it could be you lost some where the setting for the address_format_id definition for 6 ...

[samar777]

Hey Linda,

I just upgraded from 1.3.9g to 1.3.9H and some problems occurred.

1. address went missing from admin index page, " New Customers " Column"

2. addresses missing from packing slips and invoices.


I do use some mods like edit orders and all.

[Ajeh]

Could you check in phpMyAdmin, the table:
address_format

and make sure you have all 6 definitions?

[samar777]

Could you check in phpMyAdmin, the table:
address_format

and make sure you have all 6 definitions?

yes all there. 1 through 6.

also wanted to mention that if i use an old back up index file in admin

they show up on the "new customer" column, but not on invoice and packing slips.

[samar777]

seems to be fixed.

I followed DrByte's bug fix solution.

http://www.zen-cart.com/forum/showpo...64&postcount=6

I just did step #1 and all seems to be working fine, and therefore i left step #2 alone. I am a bit confused as I have PHP version 5.2.6 installed and this fix is supposed to be for versions lower than 5.2.3. so i don't know.



Is this a recommended solution? If not, i'd fix it when there is an answer. Thanks Linda.