Paypal IPN error

[luvingmamma]

HI there I used paypal Ipn from august to march w/no issues and now everytime we get this error:
1054 Unknown column 'zen_order_id' in 'field list'
in:
[SELECT zen_order_id, paypal_ipn_id, payment_status, txn_type, pending_reason FROM zen_paypal WHERE txn_id = '' OR parent_txn_id = '' ORDER BY zen_order_id DESC ]


AND it does not finish the order- I never receive it- all past orders done with paypal are now unaccessible and I am not sure what to do :)

Any help is appreciated !
Brandy

[DrByte]

Sounds like you're using a v1.3.8 database with v1.3.7 or earlier PHP code.
Did you do an incomplete upgrade?

[DAC]

I seem to be having the same problem, but I had not done the upgrade.

[DAC]

Just finnished the upgrade, no luck with the Paypal issue

[luvingmamma]

This is old but I wanted to post the solution- i was forced to move to a completely new cart. we went to everyone to see about fixing the site to no avail.

i think pp was right - our i.t. did an upgrade it didn't work right so they backed it out but only partially

so on the new site it works fine and paypal ipn works properly as it never did in the old cart...

sorry so late but wanted to post this so if anyone is researching ....

[Ajeh]

Thanks for the update ... better late than never ...

It is always a great help to know both the problem as well as the solution ...