Address not showing

[HDG]

The addresses for users are being stored correctly, but not being displayed at all. Here's what I mean:

(The name is blanked out)

But if you click on Edit, it brings up the Fields correctly filled in with the address. Also when the item is purchased and the confirm email is sent, anything addresses are blank.

[Ajeh]

Check your database via phpMyAdmin ...

Do you have anything in the table: address_format

[HDG]

I have:

address_format_id
address_format
address_summary

But nothing in them, it seems:

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 sec)

[Ajeh]

That would tend to break things ...

Backup you datebase before doing this:

DROP TABLE IF EXISTS address_format;
CREATE TABLE address_format (
  address_format_id int(11) NOT NULL auto_increment,
  address_format varchar(128) NOT NULL default '',
  address_summary varchar(48) NOT NULL default '',
  PRIMARY KEY  (address_format_id)
) TYPE=MyISAM; 

That will remove and re-create the table ...

Then run this to re-load the settings:

# 1 - Default, 2 - USA, 3 - Spain, 4 - Singapore, 5 - Germany
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'); 

[Rigel]

Ajeh, I have the same problem as HDG. Tried your fix but although that went through ok still have problem. Have 1.3.9f installed. Any other things I can try?

[Ajeh]

In phpMyAdmin, find the records in the:
address_book

table, based on the:
customers_id

are they valid?

Next, check the record in the:
orders

table and check the fields:
customers_address_format_id
delivery_address_format_id
billing_address_format_id

and make sure that those are valid as well ...

[Rigel]

Thanks Ajeh. I've looked at all that and everything is fine except the orders table "customers_address_format_id" and similar fields appear as value 6 (rather than 1). I have manually changed the value and the billing/shipping address appears where it should, but new orders still come in as value 6. I have looked at the table construction and the parameters also appear to be correct.

In addition to that, the primary address does not display although the data is there and your database fix now appears to be working. Is this to do with html ouput perhaps? I am in version 1.3.9f (hosting php version would not support 1.3.9h) and despite rolling back code and removing overrides, the primary address still doesn't display on the address_book page. Is this part of the same problem? Or should I be looking at html special characters? I am using php 5.2.13.

[Ajeh]

What isn't supported in v1.3.9h by using your current php version?

The only thing that might not be supported is related to the htmlspecialcharacters on post #6 of:
http://www.zen-cart.com/forum/showthread.php?t=153143

and that can easily be fixed with the posted solution ...

[Rigel]

I had some correspondence with Dr. Byte because the documentation said that 1.3.9h would not work properly with php 5.3.13 and I had explained the misssing address details to the venerable doctor. I tried his workarounds but got no joy. (see http://www.zen-cart.com/forum/showth...display&page=2)

If you think that the only thing that isn't supported is special characters then I will revert, however, that will still leave me with the problem of these missing addresses and the value that is '6' that should be'1'.

[Ajeh]

Let's step back for a moment ...

You are saying the:
value that is 6 should be 1 ...

"what" value is 6 that should be 1 right now, when you are using v1.3.9h ...