PP Express - Errors - missing field in my database

[mommydesigns]

I set up PayPal Express today and on my first test order, I got this error when I logged into the Zen admin:

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

As the customer, i also got an error but I didn't capture it

When I went to look at our SQL, I also noted that 2 different prefixes - one is ws_XXX and the other is ws135_XXXX

I did the most recent upgrade from July 7th (pretty sure that's the date?!).

Help please!

[DrByte]

Somebody has modified your database and likely removed the "zen_" from the paypal table's "zen_order_id" field. Change it back to 'zen_order_id' and things might work better.

I suspect you've had other database problems as a result of someone removing "zen_" from other places when doing an upgrade or a move or some sort of maintenance.