Missing Customer Details on Invoice

[rikartalex]

I freshly installed 1.3.8 and moved the database across from an existing website which was using 1.3.6.

Everything works great, except the invoice and the email confirmations are leaving the customer name and address blank for billing and delivery (shipping).

The orders table in the database has all the information. I think the information is just not being passed through to invoice.php properly.

Can somebody help?

url is www.valentinewigs.co.uk

Thanks

Richard

[azrahn]

Hi,

Did you also upgrade the database from v1.3.6 to v1.3.8?

Ronald.

[rikartalex]

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

[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