Forums / General Questions / Empty delivery or billing address in order table

Empty delivery or billing address in order table

Views: 687

Results 1 to 4 of 4
22 Aug 2018, 5:17 PM
#1
zcfan avatar

zcfan

New Zenner

Join Date:
Jul 2018
Posts:
2
Plugin Contributions:
0

Empty delivery or billing address in order table

Hi,

Zen Cart version is 1.5.5e
PHP 7.x
template from Template Monsters

Sometime we can't see the billing or delivery address in the admin are on the order details page.
Unfortunately after order inserted to order table this fileds are empty.

I made a script and put it into the checkout confirmation page to save the page state before the customer confirmation is processed. The saved html output shows the addresses but those values are missing from the database table. The confirmation email content does not show that values too.

I noticed when i step back from confirmation page to delivery or payment method page and change the
option sometime the confirmation page shows the old method, after refreshing page, it is shows the correct one.

There is no error log in the log folder.

I was looking for solution but can't find, yet.
Any suggestion how can we detect the source of this error?

Thanks!

22 Aug 2018, 7:34 PM
#2
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,725
Plugin Contributions:
56

Re: Empty delivery or billing address in order table

I have seen this issue one time. No logs, and nothing was peculiar about the order. Same configuration (1.5.5e/PHP7.1).

That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.

14 May 2019, 11:47 PM
#3
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,567
Plugin Contributions:
58

Re: Empty delivery or billing address in order table

swguy:

I have seen this issue one time. No logs, and nothing was peculiar about the order. Same configuration (1.5.5e/PHP7.1).
We are still seeing this as well. Seems to be an extreme edge case and has been happening for years...

29 Sep 2021, 7:12 PM
#4
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,725
Plugin Contributions:
56

Re: Empty delivery or billing address in order table

Just got a report of this on 1.5.7c - store does a TON of transactions and it has only happened twice.
Is it possible the session data is getting clobbered so that in includes/classes/order.php,

$billto = (!empty($_SESSION['billto']) ? (int)$_SESSION['billto'] : 0);
$sendto = (!empty($_SESSION['sendto']) ? (int)$_SESSION['sendto'] : 0);

winds up setting one or both to 0? If so, would it be better to do

$billto = (!empty($_SESSION['billto']) ? (int)$_SESSION['billto'] :  $_SESSION['customer_default_address_id']);
$sendto = (!empty($_SESSION['sendto']) ? (int)$_SESSION['sendto'] :  $_SESSION['customer_default_address_id']);

That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.