Problem viewing orders

[MarkS99]

I tried to upgrade to ver 1.38 and it all went a bit Pete Tongue, so i deleted the lot and restored from backup but the last order taken shows a red dot at the side of it (Billing and Shipping does not match) when viewing orders in admin and when i click on it it only shows the customers number and no order details but at the top is the error msg
1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from zen_paypal where zen_order_id = 8 AND parent_txn_id = '' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

any ideas anyone?

[DrByte]

1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from zen_paypal where zen_order_id = 8 AND parent_txn_id = '' ]

That's because your database is still a v1.3.8 database but you're using v1.3.7 or older files to access it.

I suppose the fastest way to put a bandage on it is to edit your paypal table in your database, and rename the "order_id" field to "zen_order_id"

Then work on doing your upgrade again.

[MarkS99]

thanks ill give it a go and let you know how i get on

Mark