Missing Customer Details on Invoice

[azrahn]

Hi Azrahn

Yes I upgraded the database to 1.3.8 and manually transferred all the information across from the old 1.3.6 database.

Richard

Hi.

Let me get this clear.
You upgraded the 1.3.6 to 1.3.8 database and after that you copied the data across, right?

I have copied a database myself last night and had a few issues
For instance, my new database has a different sequence for 1 delivered/2 pending 3 processing etc etc.
So all orders that were delivered suddenly had a status of pending and vice versa.

[rikartalex]

Hi Ronald

Yes that's what I did but I haven't had the problem with the order sequence changing.

The only issue for me appears to be the missing customer name and address details from the invoice and the email confirmation.

Regards

Richard

[azrahn]

Hi Richard,

Maybe you can check the invoice or email confirmation related php files to see if you can find witch table it tries to use for that missing data. I think there must be something missing in your tables.
Did you copy the address_book table?
Ronald.

[rikartalex]

Hi Ronald

I've checked the tables and they have all the info, it just seems that the file is not reading it properly. The invoice.php file seems fine as well.

Regards

Richard

[azrahn]

Hi,

I just made a test order and recieved my confirmation.
The billing and delivery addresses are there and correct.
If you like i can pm them to you.

Ronald.

[rikartalex]

Hi Roanld

I saw them on the confirmation email and they also appear on the invoice. I am confused!

Thanks for your all your help with this.

Regards

Richard

[rikartalex]

Hi Ronald

I have worked out why it is doing it now. The address_format_id's are 6 in the orders database table instead of 1. When I manually change them to 1, then the address details appear. I just need to work out why it is doing this now.

Thanks for your help, it is greatly appreciated.

Regards

Richard

[azrahn]

Hi Richard,

So only the copied accounts have this problem and not new accounts?
If so, then hopefully you should be able to find a difference between a new account and a copied account.

Maybe you could check MySQL and PHP error logs for more info.

There is a debug tools somewhere in the download section which logs all zencart errors. Maybe that tool can shed some light on the issue.

Hope you find what is going on here.
Ronald.