Greg,
It works! To summarize what I've just done:
1) Tried a simple cash payment and got
1146 - Table 'whatever.TABLE_PAYPALIPN_TXN' doesn't exist
select o.orders_status,p.* from orders o LEFT JOIN TABLE_PAYPALIPN_TXN p
on p.item_number = o.orders_id AND o.customers_id = '5' order by
o.date_purchased desc limit 1
2) Realized I have a lot of problems, probably from the other IPN module, so I
took some guesses:
a) re-installed the original osC database
B) re-installed original account_history, checkout_success,
checkout_confirmation, checkout_payment, checkout_payment_address,
checkout_shipper, checkout_shipper_address, and checkout_success.
c) replaced checkout_process with yours
d) modified the cat/incl/pmt/paypal.php to hardcode the URL
3) Prayed, burned incense, and threw down some chicken bones
4) Tried it again and it all works!
Now I just need to delete hundreds of emails I got sent to myself, reverse a lot
of PayPal charges, and back it all up.
Next: Email myself with the orders also, not just the customers, and then figure out how I'll do taxes and UPS shipping to send that info to PayPal.
Thank you very, very much for your help. You have done an excellent job on this module and are a big help to a lot of us.
- John