I recently moved my site from one host to another. I have been through the install and database upgrade procedures multiple times. The zen install says no upgrade is necessary.
I have Zen Cart 1.3.8a
Database Patch Level: 1.3.8

Everything seems to be in working order except for the admin area orders php. Paypal orders are not recording. I get the customer address and contact info, order number and payment method and then nothing.

Each PayPal order has this error code in the top of the page:
1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from zen_paypal where zen_order_id = 200900007 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.

The orders are processing fine through PayPal and luckily I can use the PayPal info to fill the orders, but I cannot use the ZenCart to communicate with customers or process PayPal orders. Since 50% of my orders are coming through PayPal this is becoming a bit of a bother. I have checked old threads and reinstalled the PayPal module all to no avail.

Suggestions on how to fix this bugaboo are very welcome.