PayPal IPN Checkout issues: IPN Admin page & PP requiring signup

[Veazer]

PayPal Express Checkout is supported by Business Accounts. (although some have experienced success with just Premier accounts too)
That does NOT have anything to do with "Pro".
PayPal offers 3 account types: personal, premier, business. The differences are documented on their website.

"Pro" is just the ability to accept credit cards directly on your site without the customer ever going to the PayPal site to make payment.

Thanks for the clarification. Their website does not explain this sufficiently imho, users need to actually click signup to find a page detailing the differences. The best I could find before that was this comparison page that just shows differences between standard, pro, etc. but doesn't even mention personal, premier and business account. That said, this is indeed a business account.

I thought Paypal express checkout was the same as Pro (ie, accepting cards directly on your site) so that only compounded my confusion. Since installing PP EC I see the differences.

a. I have no idea what *else* may be missing from your database
b. you can fix the "specific" problem with the column-not-found error by running this via phpMyAdmin:

ALTER TABLE paypal ADD COLUMN zen_order_id int(17) NOT NULL default '0' AFTER paypal_ipn_id;

I make no guarantees about anything else. I'm very surprised that you're missing that field, as it's been there from a long time back.

I think I beginning to see the cause of the problem now, but I am unsure how to fix it. And I’m scared. I'll explain my [possibly botched] upgrade procedure, IIRC

I backed up the DB from the 1.2.4 store
I created a second DB on the server from this backup.
I created a fresh install of 1.3.7 and selected the new DB
During install, ZC recognized the old DB and upgraded the DB to 1.3.7

The problem is my old DB had 'zen_' prefixes for all fields and the new DB does not. I'm not sure how i managed that, i'll claim negligence on my part...

Therefore, it seems that ZC properly recognizes the fields in the new DB lack the 'zen_' prefix (all my customers, products and orders are present) except for the paypal module which is still looking for ‘zen_order_id’ when it should be looking for just ‘order_id’? I do indeed have ‘order_id’ on the ‘paypal’ table and the old DB has ‘zen_order_id’ on the ‘zen_paypal’ table. (Which seems a little strange, since none of the other fields on the ‘zen_paypal’ table have the ‘zen_’ prefix… Perhaps a naming scheme change since 1.2.4? )

Is there a way for me to make sure the PP modules are looking for the right table & fields since we can see they are looking for the old ones?

Have you installed the latest patch update for PayPal and v1.3.7?
http://www.zen-cart.com/forum/showthread.php?t=56216

Just did it after reading your reply. It fixed the ‘ipn_main_handler.php’ error but I still get the other error attempting to access the IPN page in admin.

Thanks again.