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
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
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?
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
It is in the database just not showing up in the edit, invoice and packing slip pages themselves
Weird huh
Fletch
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?
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
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
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?
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
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
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 ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
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 $
*/
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 $
*/
Bookmarks