Hi there. I am getting a problem that seems to be common:

Someone makes a payment via paypal and we get an email without any details. Nothing is logged in Admin.

We've gone through the whole process several times including making sure there is bidirectional communications; all seems fine.

We when click on customers-PayPal IPN we get this error too:

in:
[select count(*) as total from paypal as p left join orders as o on o.orders_id = p.zen_order_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.

Couldn't find any posts that cleared it up.