address missing from invoice after upgrade

I did the upgrade to 1.3.9h on two sites. One is working fine but the other is missing the address fields on the invoice. All that displays is one comma. The phone and email are there - just the address is missing.

I checked the db and they are in there, just not displaying. I tried replacing the suggested tables in the database, restoring from a backup, even reinstalling and importing the data into a new database and new install without the template. Still no address. Yet the other site that I upgraded exactly the same way at the same time from the same levels is working fine. I am truly at a loss for why it's doing this.

Can someone suggest something else to try? I think I've tried the suggestions in the forum and it's still not working. Thanks in advance.

Between the two sites, what are the differences in the records in the address_format tables? There should be 6 records in there.

Also, what changes have you made to how countries are treated? Have you deleted several countries from your database for some reason?

Also, from the Similar Threads list at the bottom of this screen: http://www.zen-cart.com/forum/showthread.php?t=165960

Actually the cart that's working has 5 items in there, the cart that is not has 6. I recently set up payment processing to include Canada - I did it similar to the other cart (it has processing for several countries) except that it's just Canada. Do you think that might be it? Where should I look for differences besides shipping? Yes, I saw those threads but the solutions didn't help me.

Does this happen for every address, regardless of country? Or is it isolated to just certain countries?

It appears to be every US address. So far they haven't had any Canadian orders but the cart seems to be seeing the Canadian shipping costs properly if you check shipping and say you're from Canada.

I went through settings to compare them one by one and other than a few things that I knew need to be different everything was the same. The working site has some countries missing, it's the broken site that has them all!

Also, the only other difference I could find is in the working site is it's missing the option for "detailed line items in cart" and that item is there in the broken cart and says "no". I'm not sure if this is even matters.

Sounds like you've got corrupt data.
The address_format table needs an address_format_id record #2 in it.
And that corresponds to the countries table which needs a countries_id 223 record for USA which needs to also have an address_format_id value of 2
And then that should match up with your orders which have a format_id of 2.

If, however, you've altered your countries table data and deleted and re-added USA so that it has a different countries_id or have changed its address-format-value to something else or to a value that doesn't exist in the address_format table, then you'll continue to have the symptoms you're reporting.

I will have to digest what you said and may have questions after I think about it...but this happened immediately after the upgrade...before I reloaded any table data. Hmmmmmm let me ponder this a bit and see if I can get it working. If you have any suggestions on how to "uncorrupt" the tables, I would appreciate it. They've had several sales since the upgrade 3 days ago so I'd hate to lose all that data.

Well, what ARE the values for those things in your database?

The address_format table has an address_format_id record #2 in it that corresponds to the countries table which has a countries_id 223 record for USA which also has have an address_format_id value of 2 which matches up with the orders which have a format_id of 2.

I thought that might be it, but everything is as it should be. I didn't do anything to the countries table - just added Canada to zones.

Are you seeing any myDebug-xxxxx.log files in your /cache/ folder? These should show any PHP errors that are occurring ...
ref https://www.zen-cart.com/tutorials/index.php?article=82

Yes! Tons of them...basically they all say:

[29-Oct-2010 08:30:05] PHP Warning: htmlspecialchars() expects at most 3 parameters, 4 given in /home/content/p/u/g/domain/html/store/admin/includes/functions/general.php on line 39
[29-Oct-2010 08:30:05] PHP Warning: htmlspecialchars() expects at most 3 parameters, 4 given in /home/content/p/u/g/domain/html/store/admin/includes/functions/general.php on line 39
[29-Oct-2010 08:30:05] PHP Warning: htmlspecialchars() expects at most 3 parameters, 4 given in /home/content/p/u/g/domain/html/store/admin/includes/functions/general.php on line 39
[29-Oct-2010 08:30:05] PHP Warning: htmlspecialchars() expects at most 3 parameters, 4 given in /home/content/p/u/g/domain/html/store/admin/includes/functions/general.php on line 39
[29-Oct-2010 08:30:05] PHP Warning: htmlspecialchars() expects at most 3 parameters, 4 given in /home/content/p/u/g/domain/html/store/admin/includes/functions/general.php on line 39
[29-Oct-2010 08:30:05] PHP Warning: htmlspecialchars() expects at most 3 parameters, 4 given in /home/content/p/u/g/domain/html/store/admin/includes/functions/general.php on line 39
[29-Oct-2010 08:30:05] PHP Warning: htmlspecialchars() expects at most 3 parameters, 4 given in /home/content/p/u/g/domain/html/store/admin/includes/functions/general.php on line 39
[29-Oct-2010 08:30:05] PHP Warning: htmlspecialchars() expects at most 3 parameters, 4 given in /home/content/p/u/g/domain/html/store/admin/includes/functions/general.php on line 39
[29-Oct-2010 08:30:05] PHP Warning: htmlspecialchars() expects at most 3 parameters, 4 given in /home/content/p/u/g/domain/html/store/admin/includes/functions/general.php on line 39
[29-Oct-2010 08:30:05] PHP Warning: htmlspecialchars() expects at most 3 parameters, 4 given in /home/content/p/u/g/domain/html/store/admin/includes/functions/general.php on line 39

or

[13-Nov-2010 21:45:39] PHP Warning: htmlspecialchars() expects at most 3 parameters, 4 given in /home/content/p/u/g/domain/html/store/includes/modules/pages/shopping_cart/header_php.php on line 111

but I don't know what this means or how to fix it. Special chars?

Both tables are exactly the same now (with 5 entries) because I imported the working ones. It didn't help, nor did it seem to hurt.
It had 6 in the non-working site, and did not work with 6.

The site with deleted countries is the working site...the site with all the countries doesn't work.

That tells me you're using an old version of PHP and running into a conflict, which requires a workaround posted here: http://www.zen-cart.com/forum/showthread.php?p=953964#post953964

That did the trick! I contacted the host and had them upgrade php from 4.x to 5.x and now it's working just fine. I didn't even have to do the manual changes. :clap: Thank you DrByte for all your help!

I have the same problem but the PHP version seems to be 5.2.13 although the zen cart interface is only recognising 4.9.4/ I am checking with the hosting co but am not hopeful of getting them to update the php. Are there any other fixes to the above bug? If it can't be fixed then should I simply revert to 1.3.9g as I badly need to get the shopping cart all plumbed in and had hoped to do this after 1.3.9h.

Rigel:

I have the same problem but the PHP version seems to be 5.2.13 although the zen cart interface is only recognising 4.9.4/ I am checking with the hosting co but am not hopeful of getting them to update the php. Are there any other fixes to the above bug? If it can't be fixed then should I simply revert to 1.3.9g as I badly need to get the shopping cart all plumbed in and had hoped to do this after 1.3.9h.
The fix posted is the fix for the bug. Either upgrade your PHP, or apply the posted fixes.
Reverting to g is a bad move.

Thank you. I have now got them to change the PHP to 5.2.13, but this is not quite the version you mention, 5.2.3. I am still having the problem about not seeing address details on the /store/index.php?main_page=address_book in 1.3.9h and 1.3.9f. I can add addresses, delete and edit and the addresses are in the admin and in the db but they just won't display on this page (just under where it says Primary Address). I would be very grateful if you can give me a steer in the right direction to fix this. I have checked the cache logs and so far, today, no error logs, so it may be that this newer version of php has fixed most things, but not this final problem. Thanks again.

As per the title, this thread is talking about "addresses missing from invoice after upgrade".
You said yours was the same problem, but now you're saying that it's actually a different problem?

The addresses were missing from the invoices, but also from other areas - such as the account details page. I have had to revert to 1.3.9f as the hosting company will not upgrade the version of php beyond 5.2. 13 I have tried reloading the database and can now at least see the text strings set up in the address_format table. However, still no joy. Is there anything else that can be done?

Sorry to revive an old thread, but I'm having the missing address issue with ZC 1.5.0, PHP v5.2.17. I have Checkout by Amazon v1.0 installed and orders go through ok, except that I don't get the addresses other than the shipping address. With PayPal or Google checkout, I get a customer address, shipping address, and billing address, but with Amazon I get blanks for the customer, an address for shipping, and blanks for billing. It looks like this (except horizontally in a table):

CUSTOMER:
Katherine H

,

SOLD TO:
Katherine H

,

myemail######################

SHIP TO:
Katherine H

XXXXXX ST

MYTOWN, MA 01234-5678
US

This only happens with Amazon, but the Amazon help people actually pointed me at this thread when I tried to enlist their help. So does anyone have any ideas?