Upgraded to 1.3.9h now shipping info not showing on invoices

[BongoFletch]

Hi I upgraded the store and now all orders before I upgraded do not show shipping and billing info on invoice and packing slips?


Thanks for your help

Fletch

[Ajeh]

Sounds like a table is out of date or lost some data ...

If you look via phpMyAdmin at the table:
address_format

how many records do you see?

If you look at the table:
orders

do you see the data in there and do the 3 fields containing:
_address_format_id

have valid numbers based on the table:
address_format

Did you run the Upgrade from the /zc_install for v1.3.9h or did you try to upgrade in some other manner?

[BongoFletch]

It is in the database just not showing up in the edit, invoice and packing slip pages themselves

Weird huh

Fletch

[Ajeh]

Could you perhaps answer my questions more specifically? Then perhaps we can help you get this fixed ...

What did you find in the database tables that I asked about?

[BongoFletch]

There is 1 or 2's in Customer, Delivery and billing fields. there are 6 different records in the address _format table

I upgraded from the database thru the update button in the zc_install folder

[Ajeh]

What do the records in the table:
address_format

read in your database?

Do you have definitions for address_format_id 1 and 2 in the table?

[BongoFletch]

This is whats in the database:

1 $firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country $city / $country
2 $firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country $city, $state / $country
3 $firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country $state / $country
4 $firstname $lastname$cr$streets$cr$city ($postcode)$cr$country $postcode / $country
5 $firstname $lastname$cr$streets$cr$postcode $city$cr$country $city / $country
6 $firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country $postcode / $country

[Ajeh]

So far, I cannot reproduce this issue ...

If you have the address_format table with the same id values as what you are seeing in the orders table I am not seeing a cause for the missing addresses on the invoice and packing slip ...

Do you see the addresses on the Orders themselves when you hit edit?

Can you check that the files on the server match the files that came with the Zen Cart v1.3.9h ...

I am wondering if a file or files is/are out of date ...

[BongoFletch]

Yes I will the other weitd thing is the addresses show on the emails that are sent'

Here is the header info on the orders.php page

* @package admin
* @copyright Copyright 2003-2010 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: orders.php 15994 2010-04-19 17:17:51Z ajeh $
*/

[BongoFletch]

No I don't see it on any orders even orders before the upgrade. The other weird thing is the addresses show on the emails that are sent but not in the back-end

Here is the header info on the orders.php page

* @package admin
* @copyright Copyright 2003-2010 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: orders.php 15994 2010-04-19 17:17:51Z ajeh $
*/