Cannot edit orders

[CMYK]

Hi all,

I have a problem of not being able to edit orders.
When i press the edit button, the page opens up with this error on the top and the customers order showing underneath it, but cannot edit anything.


1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from zen_paypal where zen_order_id = 2 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.

Anyone have any ideas how to fix it please?

[mmwilcox]

I've had this same thing happen. I fixed it by opening the zen_paypal table in the database and changing the field 'order_id' to 'zen_order_id' which is what the error message seems to be looking for.

Someone smarter than me perhaps knows why this is happening. I have no idea. But I've taken this step and had no ill side effects. Still, you may want to backup, etc. first.

Hope that helps.

Matt